Answered

Updating person field in SharePoint List based on dropdown value

(0) Share

Report

Posted on by Surfmania77

Hi,

I'm trying to work out how I can change the value in the person column of a SharePoint list based on the value of a dropdown value in the App, I currently have all this set up manually but want to automate this somehow.

The scenario is, I have an Asset Management App and my dropdown list contains the asset status. What I would like to do now based on the action of a button is that when I select 'In Stock' from the list and hit the submit button I want the person field to change to a chosen 'User Account'.

Is this possible and how can I do this?

Thanks in advance.....

Craig

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Vijay Tailor 2,961 on at

Like (0)

Report

Hi @Surfmania77 ,

YOu can Create a flow like below and Pass the selected value of Dropdown and validate in the flow.

and on true Condition update, the User Person field value just passes the user email id. in Update actions.
and Call the FLow in Powerapp and Pass value like below.
Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
Surfmania77 64 on at

Like (0)

Report

Hi,

Thanks for the reply, you make it look so easy but can you be a bit more granular please, appreciate you helping too.

Your response was a tad too high level for me.

Was this reply helpful? Yes No
Surfmania77 64 on at

Like (0)

Report

Hi @VijayTailor

Are you able to provide a simplified overview of this for me?

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Hi @Surfmania77 ,

See the Demo for Detailed Steps.

Hope this will help you to understand the process. of the Approach I suggested.
Part 1.
Name - FLowSubmit (See the Attachment)

Part 2.
Name - FlowPart2PowerApp (See the Attachment)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

FLowSubmit.gif

FlowPart2PowerApp...

Was this reply helpful? Yes No
Surfmania77 64 on at

Like (0)

Report

@VijayTailor

Thanks, that's the button control but what about the control of updating the item in a gallery for that item to update on SharePoint?

That will move selected item to 'In Stock'

Was this reply helpful? Yes No
Surfmania77 64 on at

Like (0)

Report

Select 'In Stock' and that particular gallery item will update in SharePoint assigned a chosen account

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Hi @Surfmania77 ,

if you want to Update using Gallery with Button then why you need a FLow, Your can Directly Patch the Data into SP List , On List is Updated then Gallery Data Updated Instantly.

Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No