Answered

Editing a record from the gallery based on connected user

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an app I'm learning with which is based on a SharePoint list to allow users to choose menu items. The app is displaying in a gallery on PowerApps and on my iPhone showing a list of staff and their menu choices.

I now want to add a button 'Edit' to allow the connected user to edit their own menu selection, but not anyone elses. The default automatically created apps have an edit option for each gallery item which depends on the Parent object to identify which item is to be edited.

I would like there to be a single Edit Button on the gallery screen, which when pressed identifies the connected user, and opens an edit screen with their menu choices so they can change them. I'm pretty new to this so any help would be greatly appreciated.

Andy

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

This cannot be achieved within PowerApps so far. If you want the users to only be able to read and edit the items that they created by themselves, you need to give the setting on SharePoint list.

Under List settings > Advanced Settings > Item Level Permissions > select the checkbox according to your need:

After this, you still create the the app using the SharePoint list connection. As the owner permission on the list, you could see all the items in the app. But after you share the app with the users of this list, they will only be shown with the items that they created.

Please go ahead and have a test. Let me know if this works for you.

Regards,

Mona
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Mona,

I thought I had it working. I created an edit screen, and set the item of the editform to be
LookUp ('Menu Choice',Staff_x0020_Name.DisplayName = Office365Users.MyProfile().DisplayName)
In my testing I had it set to
LookUp ('Menu Choice',Staff_x0020_Name.DisplayName = "My Name")
which works, I thought I had changed it and was getting all pleased with myself until I spotted I hadn't. It's changed now so I'll republish and test again

Tested, it works great.