Unanswered

Set read only SP list permissions but PowerApps write

(0) Share

Report

Posted on by joeuser1

I am trying to keep a SharePoint list I have for visitors read only. That works fine...

I created a Power app that updates the list when the PowerApps form is completed. However, if a person is not a member, they cannot update the list with the PowerApps.

I need the power app to update the list, but need to keep the list read-only when folks visit the list.

I have read it is possible to do with using power automate, but not sure where to start.

I'm not sure how I would implement the "Grant access to an item or a folder" using the power app as a trigger.

We do have a group I can use for the Recipients call everyoneexceptexternalusers.

Make sense?

Any help would be much appreciated.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@joeuser1

Construct a Power Automate flow triggered by Power Apps. Within the flow, ensure that the SharePoint action utilizes the connection credentials of a designated individual having write permissions for the target list. This individual can be either a service account or a service principal. Does that help?

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Copy link

Link copied!

I wish that did help, but it does not.
As of now, I'm trying to get the power app to trigger the flow. However, I don't know how to pull the items to update the SP.
So what I did, was click on the update button on my powerapp form, and then clicked create new flow.
that brings me to this.

From there I get:
But I need to place it to my SP list so I change it to what is below... But how do I get the updated items on the list from the form?

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Copy link

Link copied!

I'm getting closer... So for my submit button on my PowerApps I have this.
If(UpdateForm.Mode = FormMode.Edit, PowerApp.Run(JSON(UpdateForm.Updates, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes) ), SubmitForm(UpdateForm))

My power automate This is my flow.
List Name: string('SPList')
Item: json(triggerBody()['text'])

The only problem I have now is I get this error in Power Automate when it is triggered.

Any Ideas?

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Copy link

Link copied!

So at this point I have it working, but the flow runs forever.
I changed the update button in the Power App to
PowerApp.Run (SubmitForm(UpdateForm))

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Do you have a dynamic list or is it the same list everytime?

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Copy link

Link copied!

The list is static except for a few fields.

As for the Powerapp/Power Automate, it was a Fial, it works for me, but others get what's pictured below.
I even set the power automat flow to run as me...

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Copy link

Link copied!

Okay, so I followed this Run Power Apps connections with elevated permissions via Power Automate | Impersonate flow actions (youtube.com) and I can get it to work under my account (without Grant access to an item or a folder). So from there, I'm trying intergrade this https://youtu.be/EJyZfYMi4n0?si=ImM5KOdQXNwmKU3O&t=964
I cant figure out what expression I should use for the ID: I placed json(triggerBody()['text']) in the ID for Grant access to an item or a folder but it fails.
List Name: string('SPList')
Item: json(triggerBody()['text'])
Any help or ideas would be much appreciated.

Was this reply helpful? Yes No