Send an email and in the body add some values of a column

(0) Share

Report

Posted on by Eri_V

In my list I have several columns i.e Responsible, Status, and Documents

Responsible is mandatory and a "Person" column and documents is a "choice" (multiple flags) column.

When an item status is modified to "Incomplete", I need to send an email to the "Responsible" and in the body message I need to list values of the column Documents that have not been checked.

Name

Responsible

Status

Documents

Item1

Andy

Incomplete

(Unchecked) ID

(Checked) Drivers Licence

(Unchecked) Birth certificate

Automatic email to Andy must display in the body message the following text:

Hi,

Your lead considers that your file Item1 is incomplete. The following documents are missing :

Birth certificate

---------------------------------------------

I'm having troubles getting these unchecked values and the name.

Any ideas?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Eri_V 33 on at

Like (0)

Report
Copy link

Link copied!

Any ideas?

Was this reply helpful? Yes No
rsaikrishna 3,703 on at

Like (0)

Report
Copy link

Link copied!

@Eri_V

Created a sample with your requirement to show unchecked options:

For this sample, I created 3 array variables:
varDocsArray: This array variable is used to capture all the selected options.
varAllDocuments: This array is a hard-coded array with all the options the choice field contains. You can store the values in a separate SharePoint list and read it to fill this array.
varNotCheckedDocumentsArray: This array captures all the values which were not checked.

Also, I created a SharePoint list "DocumentCheckList" and create one item by selecting "ID" and "Birth Certificate" values.

Here is the flow:

In the above "Apply to each - All Selected Options", I am appending each selected value to "varDocsArray".

Now, another Apply to each to loop thru all the options and checking for unselected values:

Expression: join(variables('varNotCheckedDocumentsArray'),',')
The above expression is to convert a string array to string value.

Here is the execution result of the above flow:

Please review the flow and let me know if you have any questions.

Regards
Krishna
If my reply helped resolving the issue, please mark it as Accepted Solution

Was this reply helpful? Yes No
Eri_V 33 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I'll try.

Was this reply helpful? Yes No
Verified answer

rsaikrishna 3,703 on at

Like (0)

Report
Copy link

Link copied!

@Eri_V

If my post helped you, can you please mark the reply as Accepted Solution? So that, other users can refer this post.

Regards
Krishna Rachakonda

Was this reply helpful? Yes No