Progress of work in sharepoint with automatic flow

[PrzemekOpa]

Hi,

I want to create a flow which is sending emails depends on progress of item in my Sharepoint list. 

Status is actually a progress mode, I've put there a list of several option to select.

For instance: if I select QiR - Quality and save it as a new item, send email to ...

[MarvinBangert]

Hi @PrzemekOpa 

If you want to send different emails (like to different persons, or different content etc.) you should consider using a "Switch" instead of a "Condition". Where your question mark is, you need to input a dynamic value from the SharePoint action you use in your flow on top. The value should be something called "Status - Value".

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

[PrzemekOpa]

I don't get it. What should I put in condition mode to make sending email depends on current status?

[MarvinBangert · Accepted solution]

Hi @PrzemekOpa 

as I understand you, you want to send an email, whenever an item within your SharePoint List is changed, correct? So, your trigger is "When an item is created or modified" / "When an item or a file is modified"? Next you have a "Condition", if the "status value" is something specific, send an email. To do this, you can select "dynamic content":

You can use this "dynamic content" on various positions, to put in information you already get from your SharePoint list, and you don't need to put this in manually. But this solution would make your flow huge because you would need to copy this six times (for each item in your "Status" field because in "Condition" you can only make one comparison).

If your email always looks the same, but only the information in it is different, you could consider achieving this by just using dynamic content, e.g.,

Result:

Hi,

an item was modified:
Title: Test
Status: Choice 1

Hi,

an item was modified:
Title: Test 2
Status: Choice 2

 Depending on the items the flow is running on, the layout of the email is always the same, but the information is different. This only works if you want to send it to the same people and the layout of information within the email is always the same.

If you have different email layouts and/or different people you want to send it to, you should consider using a "Switch" action:

Instead of using multiple "Conditions", the "Switch" action lets you create different cases (using the "+" between the last case and default). In the "on" field you enter the dynamic value where your information is in ("Status value") and then you can put in the different Status choice options within the "equals" field. Afterwards within the case block, you can put all the actions you want to run (like "send an email" with different layout or people addressed).

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

[PrzemekOpa]

Thank you @MarvinBangert