Sharepoint Views

(0) Share

Report

Posted on by finnt

Can anyone please help with filering a powerapp list to display a certain sharepoint view?

Help appreciated...

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Perumal 604 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
finnt 10 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Thanks again.
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi. You need to do the following:

Confirm that the list is being shown in a gallery
Find the gallery's Items property
Add a Filter function around the existing items property and use the User() function to get the current user's email or display name, something like this:
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.
finnt 10 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Appreciated again.
Meneghino 6,949 on at

Like
a
(2)

Report
Copy link

Link copied!
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:
Which column do you want to use to identify the site worker?
What is the name of this column? (assume it is MyPersonColumn for now)
What data does this column contain when seen from PowerApps? (i.e. a text of the name, a text of the email, or an integer ID or a GUID?) (you may need to create a text box in PowerApps and set its Text property to First('Time Reporting').MyPersonColumn in order to be sure)
When you create a text box in your app and set its Text property to User().FullName, does it properly show your name?
Is the data in 3 and what you get in 4 exactly the same?
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?