Answered

User() as Sharepoint List Source

(0) Share

Report

Posted on by Johnolnes

230

Patch(
 User(),
 { 
 Title: txtProjectName.Text
 }
)

So this doesn't seem to work too well, and I can't find a workoaround where the User().FullName = 'Users FullName' to dynamically have the individual update only their designated list.

The Sharepoint connection is set up and it corresponds to the User().FullName

Any tips?

Thanks in advnace

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

Johnolnes 230 on at

Like (0)

Report

Re: User() as Sharepoint List Source

The solution was to use the PATCH method with the "HTTPS request" action as per this post:

Update-Item-only-fetches-columns-that-has-values
Johnolnes 230 on at

Like (0)

Report

Re: User() as Sharepoint List Source

A little update on this process @TuongDoan :

Made a request on the power automate forums:
Using ParseJSON to dynamically update SP list base... - Power Platform Community (microsoft.com)

Found this thread by @Maarten_DIF that seems interesting, but the solution @Expiscornovus is offering is way over my league, so I'll have to continue the search or delve deeper:
Solved: Re: Post new SharePoint List Item in a list dynami... - Power Platform Community (microsoft.com)
Johnolnes 230 on at

Like (0)

Report

Re: User() as Sharepoint List Source

Thanks for the quick reply, @TuongDoan

I'll give it a go!
TuongDoan 550 Super User 2025 Season 1 on at

Like (1)

Report

Re: User() as Sharepoint List Source

You can't patch User() because it's not a table or collection. If you want to dynamically have the individual update only their designated list, use Power Automate instead since it allows you to use custom value input.

Use JSON function to convert your table or collection to JSON object, send it to Power Automate and use Parse Json action to read data. Then use Create Item to create a record.

---------------------------
Please select "Accept as solution" if the solution I provided assisted you in resolving this issue. This will help others in finding the solution more expediently 😄 Also, a Thumbs up would be a great compliment!