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

[issac_franklin]

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 🙂

[BCLS776 · Accepted solution]

You can do this with a basic control called the Data table - here are the basic steps:

1. Connect your app to the Sharepoint List data - I'll refer to it as mySPList in my example
2. Add a Data Table to a screen
3. Select the Data table and put something like this in the Items property: Filter(mySPList, 'Current Owner'.Mail = User().Email, 'Asset State' = "In Use")
4. 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
5. Edit the "No data text" property of the data table to show your desired message

Hope that helps,

Bryan

[issac_franklin]

Hello Bryan,

Thank you for your reply and the solution,

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


Best Regards
Issac