Hi, imagine i have a sharepoint list like this.
In my Powerapp list i would like to display tasks that Person C is assigned to. How the filter should look like? Right now i can't even use "ppl_column" since this datatype is table.
Any help is welcome:)
Filter(Choices(PSList.pp_list),Value = "Person C")
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi @PowerAppsUser4 ,
Could you please share a bit more about the "Ppl_list" column? Is it a Person type column (with "Allow Multiple selections" enabled) or Multiple Choice type column in your SP List?
Do you want to display the Tasks which the Person C is assigned to?
Based on the needs that you mentioned, I think the Filter function could achieve your needs. Please consider take a try with the following workaround:
Set the Items property of a Gallery to following:
Filter( 'Your SP List', "Person C" in Concat(Ppl_list, Value & ";") )
If the "Ppl_list" column is a Person type column with "Allow Multiple Options" enabled, please modify above formula as below:
Filter( 'Your SP List', "Person C" in Concat(Ppl_list, DisplayName & ";") )
Please take a try with above solution, then check if the issue is solved.
Hi @v-xida-msft ,
Thank you for your reply. Right now (after I used your proposition) I have an warning that inform me about delegation - and since the list is longer than 2000 records this is not going to work for me. Right now I can't see any records ( I typed my name exacly the same as it is in the list).
PPL_List column is a multi choice column in my SPlist
Hi @PowerAppsUser4 ,
The 'in' operator is not delegated within SP List data source. If the amount of your SP List records is more than 2000, you could consider bulk-load your SP list records into a collection in your app, then use the collection as data source in Filter function instead of the original SP List data source.
Please check and see if the following threads would help in your scenario:
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Did you miss the call? Check out the Power Apps Community Call here.
We are excited to announce the Power Apps Super Users!
Check out our new profile badges recognizing authored solutions!