Create Item using Power Automate

[Welson80]

Hello everybody.
I have a SP List to receive the data coming from Power Automate. In this list, the user does not have writing permission, only the user who made the Flow.
The user sends the request via Power Apps to Automate.
Is it possible to change the owner of the request via Power Automate? Because a permission error occurs because the user cannot write to the List.

Error: Attempted to perform an unauthorized operation.
clientRequestId: a433e8d9-a75b-4588-b989-9bc9a3f64dab
serviceRequestId: 73eed5a0-4065-4000-13a7-63326a930968

-> Flow works if the user has a Collaborator for example

Tks!

[ManishSolanki]

Hi @Welson80 

You need to configure the SharePoint connection to run under the context of owner account but not with the user who runs the flow. Pls follow the below step for the configuration:

Go to flow details page and scroll down to "Run only users" block. Click 'Edit' link present on the right side:

Next, scroll down to 'Connections Used' section and locate SharePoint connection in the list. From the dropdown, change the option 'Provided by run-only user' to select the connection of the flow owner who has the access to SharePoint list:

Save the changes & retest the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Welson80]

Hello @ManishSolanki, thanks for your answer.

I'm using Power Apps as a trigger and I don't think it supports this function.
There is no option for me to run only users.

[ManishSolanki]

I did not realize it 😞

[Welson80]

No problem @ManishSolanki 
Thanks for the help!

[Welson80]

To work around, I created a temporary List, and created another Flow to take items created there and launch them in the List that the user has access to. Soon after the "copy" it deletes the item from the Temp List.
Work around? 😄

[ManishSolanki]

Excellent 👍

[FLMike]

Hello,

I am a little confused, you said that the flow runs as the person who created it, but it only works if the user (the one making the request) has collaborator.

That sounds more like a run-as user flow not a run as a specific person/system account/role etc

Can you clarify please.

Cheers
If you like my answer, please Mark it as Resolved
and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft

Site: https://gernaeysoftware.com

LinkedIn: https://www.linkedin.com/in/michaelgernaey

[FLMike]

Hello Again,

If its running as the primary owner (the creator), and that account doesn't have the privs you need, you need to add another owner and then remove the other.

However, it's a slightly different if its solution aware flow or a non-solution aware flow.

Please Check out here for more information: Change the owner of a cloud flow in Power Automate - Power Automate | Microsoft Learn
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey