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

Filter 1 person tasks (data from sharepoint list) - from multiple choice field

Task_List

Ppl_list

Task1

Person C

Task2

Person C

Person D

Task3

Person B

Person C

Person D

 

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:) 

 

 

 

 

 

4 REPLIES 4
Highlighted
Super User III
Super User III

Try:

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.

 

Highlighted
Community Support
Community Support

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.

 

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.
Highlighted

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

 

 

 

Highlighted

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:

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M7...

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Sort-gallery-with-multiple-fields/td...

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Delegation-Formula-Help/m-p/394039#...

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,152)