Modify row SharePoint and Send email to Assign Person in an Email

[Lucas_Ignatius]

I just create flow with trigger (When an item or a file is modified), and then will be send email to assign person.

But there is a little problem when send email to Assign Person more than 1 person it will be separate send 2 email didn't 1 email in To Column, can this possible to sent 1 email so people can know each other who received this email

[v-duann-msft]

Hi @Lucas_Ignatius 

Thank you for posting.

According to your description, you would like to send only one email to recipients to let them know each other. If any misunderstanding, please kindly let me know.

Actually, you got separate email messages due to this loop. If that’s the case, we can modify flow as below:

Expression:

concat(triggerOutputs()?['body/Author/Email'],';')

concat(outputs('Compose'),triggerOutputs()?['body/Editor/Email'])

Once tested, I’m able to get one email to two recipients with no issue.

Hope the content above may help you.

Best regards,

Anna

[Lucas_Ignatius]

Okay, it's correct about I need.
But it still need column name assign person and created by? or only add this : concat(outputs('Compose'),triggerOutputs()?['body/Editor/Email']) and concat(triggerOutputs()?['body/Author/Email'],';')

New Flow

Sharepoint List

[v-duann-msft]

Hi @Lucas_Ignatius 

Thanks for your quick reply.

If you already have extra column to store 'created by' and 'modified by' data. Please help to change bold part based on your parameter.

We use concat function to combine 'created by' with ';', as well as the 'modified by'. 

concat(createdbycolumn,';')

concat(outputs('Compose'),modifiedbycolumn)

Hope it helps.

Best regards,

Anna

[Lucas_Ignatius]

So is change this variable ?

concat(triggerOutputs()?['body/Author/Email'],';') --> concat(triggerOutputs()?['createdby'],';') 

concat(outputs('Compose'),triggerOutputs()?['body/Editor/Email']) -->concat(outputs('Compose'),triggerOutputs()?['AssignPerson'])

Is okay what i write above that?

Thanks

[v-duann-msft]

Hi @Lucas_Ignatius 

Thank you update.

Yes, it could be like this. The parameters come from output of 'when a new item or file is modified' action. If you can find them from dynamic content area, it should be all right.

Thanks

Anna

[Lucas_Ignatius]

I just try for created column is correct but for assign person is still problem will be sent 2 - 4 email, is my script variable correct?

[v-duann-msft]

Hi @Lucas_Ignatius 

In 'To' area, just input :concat(outputs('Compose'),triggerOutputs()?['AssignPerson']). Please remove the previous 'assignPerson email' value. The 'assignPerson email' is already combined within 'concat' expression, they are duplicated.

Anna

[Lucas_Ignatius]

I try again, but it only sent one person and is only me, another person not received 

[v-duann-msft]

Hi @Lucas_Ignatius 

Could you please change flow to below? I would like to check detailed output from your end. In two compose actions, please input that two expressions in order and test with the recent succeeded one.

Normally, we would get results:

Sorry for the several back-and-forths, it's difficult for us know the actual problem from your side and assist you.

Thanks for your patience.

Anna

[Lucas_Ignatius]

there is same script for compose? or what script must I'm use?

[v-duann-msft · Accepted solution]

Hi @Lucas_Ignatius

No, I'm just trying to check the output from your end. The correct flow may look like the original version in my first response. But to figure out why you only get different results. We need to check step by step. It's difficult for us to do further investigation as I mentioned because sometimes customers feel confused about what I'm trying to do. 😂

If we got trouble communicating with each other due to certain gap, I recommend go to below website to request a remote troubleshooting support. We are different teams as they can do remote session and check your desktop directly if allowed by you. I believe it would be better for us to resolve the flow quickly and avoid misunderstanding.

https://flow.microsoft.com/en-us/support/

Just go to this team and show the flow I configured. Tell them your request and show your environment. Then, they will modify your flow as required.

Apologize for the inconvenience and no offence.

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Best regards,

Anna

[Lucas_Ignatius]

I Can't because it will be paid 😅

So there is possible have problem on my script may be? can you suggest an idea, may be you need field or something more information to help me about this case?

anyway for column AssignPerson on SharePoint List, I'm created new column with type Person, it is okay?

[v-duann-msft]

Hi @Lucas_Ignatius 

Nonono...they are 7x24 free support. Otherwise I will definitely inform you in advance.🤔

Anna

[Lucas_Ignatius]

okay, Thanks I just created report. I hope can get soon solution.