cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NickSz
Level: Powered On

SharePoint list item added trigger email with condition

I'm trying to have the flow triggered if a list item is added AND a category value column is equal to the value set in the flow (i.e. if new item added and column value = A, send email, if not, do not send email).

I can't as far as I can tell place a condition on the trigger of a flow? I have to imagine there's a easy fix.

Now I have a hey user profile action between the trigger and the condition which it's skipped on falling.

Any pointers would be helpful...
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: SharePoint list item added trigger email with condition

Hi @ NickSz,

 

Could you please share a screenshot of the configuration of your flow?

What is the type of the “category column” that you mentioned?

 

If you want the flow would be triggered when an item is created in the sharepoint list and the value of the category column is equal to a value such as “A”, you couldn’t achieve it until now, because Microsoft flow could support trigger a flow with an item currently, and trigger a flow with an column is not supported in Microsoft flow currently.

However, you could add a condition under the trigger to check if the value of category column is equal to “A”, if the category value is equal to “A”, then send the email, else if the category value isn’t equal to “A”, do nothing.

 

I have made a test on my side and I have created a sharepoint list as below:

The “category” column is a choice type column with value “A”, “B” and “C”.

I have created a flow as below:

 1.png

When an item is created in the list, and the value of “category” column is equal to “A”, the flow would run successfully as below:

 2.png

 

 

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: SharePoint list item added trigger email with condition

Hi @ NickSz,

 

Could you please share a screenshot of the configuration of your flow?

What is the type of the “category column” that you mentioned?

 

If you want the flow would be triggered when an item is created in the sharepoint list and the value of the category column is equal to a value such as “A”, you couldn’t achieve it until now, because Microsoft flow could support trigger a flow with an item currently, and trigger a flow with an column is not supported in Microsoft flow currently.

However, you could add a condition under the trigger to check if the value of category column is equal to “A”, if the category value is equal to “A”, then send the email, else if the category value isn’t equal to “A”, do nothing.

 

I have made a test on my side and I have created a sharepoint list as below:

The “category” column is a choice type column with value “A”, “B” and “C”.

I have created a flow as below:

 1.png

When an item is created in the list, and the value of “category” column is equal to “A”, the flow would run successfully as below:

 2.png

 

 

 

Regards,
Alice Zhang

View solution in original post

NickSz
Level: Powered On

Re: SharePoint list item added trigger email with condition

Okay I follow your logic.

 

I had come to a simillar solution--allbeit more rudimentry. 

 

Thank you for the help!

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 134 members 5,295 guests
Please welcome our newest community members: