Unanswered

User() as Sharepoint List Source

(0) Share

Report

Posted on by Johnolnes

234

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

TuongDoan 573 Moderator on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Johnolnes 234 on at

Like (0)

Report

Thanks for the quick reply, @TuongDoan

I'll give it a go!

Was this reply helpful? Yes No
Johnolnes 234 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Verified answer

Johnolnes 234 on at

Like (0)

Report

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

Was this reply helpful? Yes No