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

All responses (7)

Answers (1)

Sort by

Verified answer

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Surfmania77 64 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Surfmania77 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VijayTailor

Are you able to provide a simplified overview of this for me?
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Surfmania77 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@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'
Surfmania77 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Select 'In Stock' and that particular gallery item will update in SharePoint assigned a chosen account
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

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