I just try to finish my first app with PowerApps and i have one last thing to figure out:
I connected Outlook to the app, so I can display the name of the current company-employee.
I connected a tasklist as a 'gallery' from sharepoint to the app.
In the Sharepoint tasklist employees are set as a table (with some attributes), so I can display them just a s a dropdown [AssignedTo.DisplayName].
Now i want to filter the tasks in the gallery to see just the tasks, that belongs to the current employee [User().FullName].
I tried this:
It doesn't work, because [User().FullName] is a text and [Dropdown2.Selected.Value] comes from a table.
Is there something I can do to solve this problem?
If you want the gallery to display just tasks assigned to the current user then the Items property of the gallery would look something like this:
Filter(TaskList, AssignedTo.Email = User().Email)
Thanks for the answer.
I tried the solution
Filter(Gallery1, AssignedTo.Email = User().Email)
in all variants - it doesn't work.
Filter(Gallery1, AssignedTo.Email = "MyEmail")
Filter(Gallery1, AssignedTo.Displayname = User().Fullname)
I think there must be a trick to convert [AssignedTo.DisplayName] into a text.
Then [User().Fullname] can be compared with [AssignetTo.DisplayName].
If this formula is going into the Items property of Gallery1 then "Gallery1" shouldn't be listed in the filter. The first parameter of the Filter should be the SharePoint Task List.