Can you elaborate your requirement? I am unable to understand. Are you trying to filter the powerapps related to a particular SharePoint list?. Today in PowerApps, this feature is not available, but I think in the SharePoint List Modern View this is available. Please check the SPO.
Hi there and thanks for your reply.
In short I have a modern list that I have created a Power App for and am completly happy with everthing except "filtering the list".
By this I mean it is a time reporting app for the guys on site to report activity.
All I want to change is the list that each individual sees when they use the app.
I would like this to just be their own returns not the entire teams.
Perhaps a filter that just shows items created by them?
Perhaps a filter that just display items with thir own names in the NAME field?
Appreciate any help as I am really keen to use this software but only capable of doing the basics!
Hi. You need to do the following:
MyGallery.Items = Filter ( Whatever is in the Items property now, NAME = User().FullName)
Please let me know which step you need further help with, or if it is not working.
thanks for the help.
By default powerapps has created the following in the Items box.
SortByColumns(Search('Time Reporting', TextSearchBox1.Text, "Description"), "ID", If(SortDescending1, Descending, Ascending))
Would you be able to please let me know where to insert the function text you have suggested below?
No matter how I try I just dont know and get errors!
OK, now that you have found the right gallery property, you are half way there.
This will work if your table 'Time Reporting' has a column with the name of the site worker, either explicitly as a stand-alone column or you can use the created by or modified by columns for example as you already suggest.
If this is the case, then I need to know a few things is order to be specific with the help:
If the answer to 5 is yes, then the answer is simply this:
Gallery1.Items = Filter ( SortByColumns(Search('Time Reporting', TextSearchBox1.Text, "Description"), "ID", If(SortDescending1, Descending, Ascending)) , MyPersonColumn = User().FullName)
If the answer to 5 is no, then I need to know one more thing: is your SharePoint on-line (Office365 plan) or on-premise?
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications