Power Platform Community Forum Thread Details

Hi guys,

I have this request of a client and I am searching for a solution. I think I am searching in the right direction now but I do not know how to do it. I hope you can all help me with this, I am fairly new here so I appreciate every help I can get from you guys.

First of all I will tell you what I am working with.
I have Sharepoint list, that I am using as my source for my PowerApp. The PowerApp is made for users who are going to submit a request for a substitute who can take over their shift.
The sharepoint exist of multiple columns, the ones important columns for this question are:
Agent which is the requestor and is a person's column
Substitute which is also a person's column
And a date column FROM which shows the date of the shift.

In Power apps I have a form where the requestor can change the substitute.

As you can see on the right we have as a substitute Colleague,Test who is going to do my work on 05/12/2023 if it is approved.
The field of this peoplepicker is Choices([@'sharepointsource'].Substitute)

My question now is, is there a possibility and how do I adjust the people picker that if the person is already working on that date, that it will not show up in the list of choice of the people picker?

For example if I want to choose the Colleague, Test again for the same date on another one's shift, it is not possible, because the name will not show up as a choice because Colleague,Test is already working on that date.

Categories:

Building Power Apps