cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SLBMetrology
Helper III
Helper III

Power Automate to change a Choice Column within a List depending on another cell entry

I have a form that is feeding into a List. I need to create a flow that automatically changes a choice field in my list to 'Critical' depending if someone enters a specific entry in another column within the List.

 

The exact scenario... Our production team fills out a form when they are in need of a work request. They have the option to choose the priority.   We want to ensure that any entry with the issue regarding a "JIT" comes in as 'Critical', therefore I want to create a flow to ensure that even if they wrongly choose "low" priority the flow will later change it.

 

I am new to all this so the more detailed the explanation the better.

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @SLBMetrology ,

if I understand correctly, you already have a flow that takes input from MS Forms form and creates an item in a list? 

I'd add a 'Condition' before the 'Create item' action. In the 'Condition' check if the other column contains 'JIT'. If yes, create the item using the data from the form, except the priority: set the priority always to 'Critical'. If no, create the item using the data from the form, including the priority, as you do now.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

2 REPLIES 2
tom_riha
Super User
Super User

Hello @SLBMetrology ,

if I understand correctly, you already have a flow that takes input from MS Forms form and creates an item in a list? 

I'd add a 'Condition' before the 'Create item' action. In the 'Condition' check if the other column contains 'JIT'. If yes, create the item using the data from the form, except the priority: set the priority always to 'Critical'. If no, create the item using the data from the form, including the priority, as you do now.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

SLBMetrology
Helper III
Helper III

@tom_riha Oh geeze that was way easier than I was making it out.  I'm just starting out with all this and I seem to always over complicate things.  I appreciate your help!!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,009)