cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Restrict people control

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.

 

Approvers.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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:7.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

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:7.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Worked as Charm .Thank u !!

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,979)