How to Fetch data from Sharepoint List and display only the data of respective user

(0) Share

Report

Posted on by issac_franklin

113

Dears,

I am a complete beginner to PowerApps and trying to build an simple application (Hopefully) which will perform the below task.

1. Application should be read-only where once Users open the application they should be able to see only the assets assigned to them in Sharepoint lists. Users should not see any other assets and do not have write permission.

About our setup :

We maintain the Asset Manager which was available in Sharepoint List by default and the field 'Current Owner' is 'Person or Group' and Asset state has default ones as 'In Use', Users should be able to see only the 'In Use' state and which is assigned to them once the application is loaded.

If there is no assets, It should display the message as 'No Assets Assigned to you'.

Thanks in advance, Looking forward to hear from you 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BCLS776 8,994 Moderator on at

Like (2)

Report
You can do this with a basic control called the Data table - here are the basic steps:
Connect your app to the Sharepoint List data - I'll refer to it as mySPList in my example
Add a Data Table to a screen
Select the Data table and put something like this in the Items property: Filter(mySPList, 'Current Owner'.Mail = User().Email, 'Asset State' = "In Use")
Select the data table control so you can see the context menu on the right hand side. Select Fields and add several columns to show to your user
Edit the "No data text" property of the data table to show your desired message
Hope that helps,
Bryan

Was this reply helpful? Yes No
issac_franklin 113 on at

Like (0)

Report

Hello Bryan,

Thank you for your reply and the solution,

It indeed worked as expected, Thanks again...!

Best Regards
Issac

Was this reply helpful? Yes No
spanishshp 5 on at

Like (0)

Report

Hello there

I don't know if you all are aware of the lack of security here. Even if you show only that table already filtered in your app, if you go to your browser DevTools, you will find there all jsons with all info of all the lists you have connected to your powerapp😅

No idea if this was already reported, if not... Hope someone can prioritize it please...

Was this reply helpful? Yes No