Unanswered

PowerApps submit, but not read - Sharepoint

(0) Share

Report

Posted on by Mr_S_Ball

Hello all.

I’m trying to build a form from a Sharepoint list for my entire workforce to use. However, I only want personnel to be able to submit the data and not read. I then want a single team to be able to use/access the data afterwards. I know this is pretty achievable through powerapps itself, but don’t want users accessing the data from the back end. Is this possible without Dataverse?

I’m thinking I could potentially set up a flow, to automatically move or copy the submitted form data from an open sharepoint list that everyone can contribute, to another identical list, which has restricted permissions for my review team. The next stage would be to automatically delete the data from the open list to prevent anyone else (even) the person submitting being able to view. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Take a look at the following video

Run Power Apps connections with elevated permissions via Power Automate | Impersonate flow actions - Bing video

Was this reply helpful? Yes No
Mr_S_Ball 16 on at

Like (0)

Report

Many thanks for this. It is along the lines of what I’m looking for, but still doesn’t prevent the user submitting a form from being able to later read or view what they have submitted. I’ll have a play with automate to see if there’s a solution on there. Cheers.

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (2)

Report

In the video the user doing the submission only has read access to the SharePoint list, so they can't edit what they have submitted. It should be possible to change that so that they submit locally to a collection and then the values in the collection are submitted by the flow to the SharePoint list. In that case the user wouldn't need any access to the list itself.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Hello @Mr_S_Ball

Had the same concern before.

First on the SharePoint List, here is what I did with the settings only allow users to make see what they created and be able to view what they created (i know this is not what you want but keep on reading)

Then in PowerAutomate, this is what I did. For the role, I actually choose just the Edit option.
Full MS Documentation here:
https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions

Please test it cause I don't have access to that dev environment anymore. It's a rough scratch from my memory. I think you might need to make a few more tweaks but I hope you get the idea.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (1)

Report

Hello @Mr_S_Ball

Had the same concern before.

First on the SharePoint List, here is what I did with the settings only allow users to make see what they created and be able to view what they created (i know this is not what you want but keep on reading)

Then in PowerAutomate, this is what I did. For the role, I actually choose just the Edit option.
Full MS Documentation here:
https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-item-file-permissions

Please test it cause I don't have access to that dev environment anymore. It's a rough scratch from my memory. I think you might need to make a few more tweaks but I hope you get the idea.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No
Mr_S_Ball 16 on at

Like (0)

Report

Many thanks. I’ll give this a try when I’m back in the office on Monday.

Was this reply helpful? Yes No