Multiple filters / only show tasks by the assigned user

(0) Share

Report

Posted on by Matt22365

131

I hope someone can help

I have created an app to update a SP task list. However, I would like the gallery to only show open actions for the logged on user.

The formula I am using is - Filter(Tasks,Completed= "0"&&'Assigned To'= User().FullName)

Where "Completed" = 0 when the task isnt completed

The formula works until I add the Assigned to section. Is there something I have done wrong?

Thanks for your help in advance

Matt

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Try:
Filter(Tasks,Completed= "0"&&'Assigned To'.Value= User().FullName)
------------

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.

Was this reply helpful? Yes No
Venxir 125 on at

Like (0)

Report

Assigned To column is probably of the type "People" in SharePoint. This means that you cannot compare it to a string and be done with it. You can check this by doing ClearCollect(ColTasks,Task) and see what's in the new table.

Also check this similar thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-I-filter-by-a-SharePoint-People-Picker/m-p/329970/highlight/true#M94780

Was this reply helpful? Yes No
Matt22365 131 on at

Like (0)

Report

Hi
Thanks for the quick response. That change, unfortunately, didn't work

Thanks
Matt

Was this reply helpful? Yes No
Matt22365 131 on at

Like (0)

Report

Hi
Thanks for the quick response
I don fully understand what I need to do from that related thread, do I need to somehow link the people picker list with the task list? if so, how would I structure the formula?
Thanks
Matt

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Can you give a screen shot of the error?
------------

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.

Was this reply helpful? Yes No
Matt22365 131 on at

Like (0)

Report

Hi
Its not so much an error, its just not showing data. If I remove the assigned to section it shows all tasks where completed = 0 so I know that section is working
Thanks
Matt

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Does the user who has logged in has record In that List related to the User().FullName?
------------

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.

Was this reply helpful? Yes No
Matt22365 131 on at

Like (0)

Report

Hi
Yes ive tried a few users who haven open items, all get the same blank Gallery
Thanks

Was this reply helpful? Yes No
Verified answer

Matt22365 131 on at

Like (0)

Report
Hi
I found the fix for this issue. There was 2 problems:
the people column in sharepoint was set to just members of the task list. This stopped the 'assigned to' field from appearing in the fields in my App. I changed it to the full company and that field appeared
The formula was wrong, this is the correct one - Filter(User().Email in 'Assigned To'.Email)
I hope this helps anyone with the same issues as me
Matt

Was this reply helpful? Yes No