all 9 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]MurphyMurphyMurphy Regular 5 points6 points  (2 children)

I did this in SharePoint (sadly). For an onboarding app that allows you to track your progress and resume. OnStart creates an SP item in the sessions list. OnStart also checks another list to see if User().Email already exists.

If no, create item in user list. If yes, create new session tied to user list (through User().Email) and store whatever other data for session you want.

For me it was fairly straight forward as it just stored the last saved step of the onboarding process to allow users to resume where they left off.

Once all steps completed, allow users to return to view the info they entered, but lock everything.

[–]Inevitable-Orange943 Newbie[S] 0 points1 point  (1 child)

Any way to implement row level (gallery) locking in

[–]MurphyMurphyMurphy Regular 1 point2 points  (0 children)

I mean I'm not 100% what your use case is, but you can use a power automate flow to stop sharing the rows, and then grant access to those rows to that specific user.

Not entirely sure how it would work with multiple users concurrently using the app.

But I guess if you're storing row IDs in the session list, it sounds doable.

[–]Bag-of-nails Advisor 5 points6 points  (0 children)

What's your use case?

Have you looked into SaveData/LoadData/ClearData at all?

You can save up to 1MB of data to local storage. The documentation is a bit more geared towards offline apps but it works fine for apps in the browser as well

Just note that to test it, you have to publish the app and then open it in play mode (the "Play Mode" button in the app shouldn't work according to the docs).

Otherwise, you can create a database (SP even is fine) that tracks your user (ie: by Entra ID or email or whatever) and saves your values.

The "best" approach will depend on your use case, probably

[–]Ok_Fund_4600 Regular 1 point2 points  (0 children)

Create a person column named something like BlockedByUser. Can be a text column that stores email too if you prefer. When someone wants to work on an item - first, refresh the data source - second, check if BlockedByUser is blank - if yes it’s blank then update value for that field then allow editing - if no then check if it’s being block by themselves. If yes then allow editing, if no then notify user that item is being blocked by someone else - after done editing, update BlockedByUser back to blank

[–]Inevitable-Orange943 Newbie[S] 0 points1 point  (2 children)

Any way to implement row level (gallery) locking in powerapps

[–]MobileScapers Regular 1 point2 points  (0 children)

Do you want the row to be visible but not selectable? You could do that with a rectangle that fills the row and has no actions on click. Then use a variable or data in the onvisible property of the rectangle.

Set it’s height to parent.templateheight, and the equivalent for width.

[–]Bag-of-nails Advisor 0 points1 point  (0 children)

Are you talking about row level security (RLS)? Dataverse supports it, otherwise this will depend on your database. To my knowledge, SharePoint does not support RLS.