cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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.

 

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.

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:

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
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (38,608)