cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Sending an email to users from SharePoint Online when field is changed to complete

I'm trying to create a flow from one list.

 

If status is = closed

and if type A is yes

and number is 1

then send email 1

 

If status is = closed

and if type A is no

and number is 1

then send email 2

 

If status is = closed

and number is 2

Do nothing

 

Is this possible or am I missing something?  I can't get it to work.  Thanks for any help.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Doogiegood ,

 

Just create the flow as my screenshot without an Apply to each:

1.png

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
Super User III
Super User III

Hi!

Yes I believe it is possible. You are using as trigger either 'When an item is created' or 'When an item is created or modified' right?

 

Can you share a screenshot from your current flow design? Also, can you confirm Sharepoint List columns format ('single line of text', 'number', 'yes/no', 'choice'...) The more context info we get, the faster we can provide a good suggestion to overcome your challenge.

Thanx!

 

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



#4#4#3#3#2#2#1#1

Hi!

Can you also confirm Sharepoint List columns/fields format ('single line of text', 'number', 'yes/no', 'choice'...) ?

I mean, the columns/fields you need to evaluate in the Condition

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Status is Choice

Event Type is Choice

Major Incident is Yes/No

 

If status is = closed

and if Major Incident  is yes

and Event Type is 1

then send email 1

 

If status is = closed

and if Major Incident  is no

and Event Type is 1

then send email 2

 

If status is = closed

and Event Type is 2

Do nothing

Hi!

If 'Status' is of type choice, then you need to choose 'Status Value' instead of 'Status' from your dynamic content menu

 

You will find a good example with in this thread on how things can slightly change depending on the SP column type

https://powerusers.microsoft.com/t5/Building-Flows/Setting-variable-in-expression/td-p/495557

 

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @Doogiegood ,

 

Please refer to screenshot below to create the flow:

1.png

 

Please make sure to choose the Status Value dynamic content and the Event type Value dynamic content in the Condition.

And make sure that the "closed" is an option in the Status column, the "1" is an option in the Event type column.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks.  I think I'm starting to understand a bit more. I am getting an error now, but I'm not sure how to fix it.

 

1122

 

 

Hi!

Which expression/dynamic content output did you assign as 'Apply to each 3' input? 'EventType' field from Sharepoint list?

If so, this is the reason for the error: 'EventType' is a string, but 'Apply to each' needs an array (i.e. a list) as its input

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



I think that is my issue; 

Which expression/dynamic content output did you assign as 'Apply to each 3' input? 'EventType' field from Sharepoint list?

 

I'm not sure what to put in this and it is only giving me three options, Event Type, Shift and Technicians.  I want it to trigger off Status Value of Completed.

Hi!

I would remove 'Apply to each 3' and follow the example @v-alzhan-msft already shared

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @Doogiegood ,

 

Please remove the Apply to each and add the Condition under the trigger directly.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your assistance. I very much appreciate it.  However I just am not getting it.  I am going to have to wait until my organization gets some training. 

I don't understand  how to "add the Condition under the trigger directly."

 

Power Automate is far more confusing to me. I liked workflows in SharePoint Designer.  🙂

Hi @Doogiegood ,

 

Just create the flow as my screenshot without an Apply to each:

1.png

 

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (73,713)