Jul 04 2019 11:53 AM
Hi i have two list:
1 Project list (that takes requests from request list)
2 Request list
I want to make a dropdown list in project but i want to see only untaken requests.
Example:
Project 1:
dropdown list:
Request a (selected)
Request b (selected)
Request c
after a while i make Project 2 where only request c is avilable:
Project 2:
dropdown list:
Request c
(a and b were taken i project 1)
how to do it?
Jul 05 2019 01:04 AM
You have to provide some custom UI to achieve this since SharePoint List Forms out of the box don't allow you to specify such behavior.
There are several ways you can consider to provide this custom UI:
Hope this helps!
Jul 05 2019 01:08 AM
@Paul Pascha I tried to do a "invisible" list (request not taken) that moves items to "finished request list" after the project has been created ... my problem was that I can't manage this in Microsoft Flow because I lost link connection to items in finished items...