web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Set read only SP list ...
Power Automate
Unanswered

Set read only SP list permissions but PowerApps write

(0) ShareShare
ReportReport
Posted on by 60

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:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @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?

     

  • joeuser1 Profile Picture
    60 on at

    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.

    joeuser1_1-1715248687190.png

    that brings me to this.

    joeuser1_2-1715248732371.png

     

    From there I get:

    joeuser1_3-1715248795918.png

    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?

    joeuser1_0-1715248505406.png

     

  • joeuser1 Profile Picture
    60 on at

    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.
    joeuser1_0-1715266322444.png

    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.
    joeuser1_1-1715266473581.png

     

    Any Ideas?

  • joeuser1 Profile Picture
    60 on at

    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))
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

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

     

  • joeuser1 Profile Picture
    60 on at

    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.

    joeuser1_0-1715336023684.png

    I even set the power automat flow to run as me...

  • joeuser1 Profile Picture
    60 on at

    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'])

    joeuser1_0-1715619636511.png

    joeuser1_1-1715619685322.png

    Any help or ideas would be much appreciated. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 299

#2
11manish Profile Picture

11manish 274 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard