Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Help Building a Conditional Flow Based on Column Change in SharePoint

I have a list with a drop down with 4 users.  I created a flow, that when a user is selected it will automatically send that user an email.  Now I also need to build a flow where if that dropdown is assigned to another user at a later time, then that new user will receive the email but I'm getting stuck on the logic, if anyone can please help. 

Dual Super User
Dual Super User

Re: Help Building a Conditional Flow Based on Column Change in SharePoint

HI @MikeNJ00 


You can use the when an item is created or modified trigger and based on this trigger, whenever the dropdown is updated the flow will be triggered and then you can configure an email action accordigly. So every time the dropdown changes the flow triggers and sends an email to the address selected in the drop dow. Makes sense?


If you could share a screen shot of the flow you built so far, I mitght be able to assist you better. 


Hope this Helps!


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Level: Powered On

Re: Help Building a Conditional Flow Based on Column Change in SharePoint

So mine is a little complicated.  It's a PowerApps form where this field is autopopulated through Powerapps based on criteria on other fields, but you can change this field through quick edit mode in the SharePoint list.    The dropdown contains text for the users name.  So I created a flow to alert the user orginally by setting up 4 conditions when the item is created.  And when that user is populated originally the flow kicks off an email based on that as you can see below.  Or maybe it's not complicated and I can easily add this trigger in?


Helpful resources


Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,118)