Restrict people control

[Ashub1]

I want to bind People control which should be populated from approval list based on some filters.As for FM1 PRJ Approver person column all this 3 names should be populated based on filter.

[v-xida-msft · Accepted solution]

Hi @Ashub1 ,

Could you please share a bit more about your scenario?

Could you please share a bit more about the People control that you mentioned? Is it a People Picker ComboBox within your app?

Could you please show more details about the Approver column? Is it a Person type column in your SP list?

Based on the needs that you mentioned, I suppose that you want to restrict the avaiable options of People Picker ComboBox based on the Title column value in your app, is it true?

I have made a test on my side, please take a try with the following workaround:

Add a Dropdown control or ComboBox control within my app, set the Items property to following:

Filter(
        Split(
               Concat(Filter('20190701_case7', Title = "Machine Learning"), Executors.DisplayName & ","),
               ","
        ), 
        !IsBlank(Result)
)

On yuor side, you should type following formula:

Filter(
        Split(
               Concat(Filter('Your Approver List', Title = "A specific Title value"), Approver.DisplayName & ","),
               ","
        ), 
        !IsBlank(Result)
)

Note: I assume that the Approver column is a Person type column in your Approver list, which could only select single one user.

Please take a try with above solution, check if the issue is solved.

Best regards,

[Ashub1]

Worked as Charm .Thank u !!