cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eri_V
Helper I
Helper I

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

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. 

 

IDNameResponsibleStatusDocuments
1Item1AndyIncomplete

(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 : 

ID

Birth certificate

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

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

 

Any ideas?

 

task10.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@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

 

View solution in original post

4 REPLIES 4
Eri_V
Helper I
Helper I

Any ideas?

@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:

 

P1.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

P2.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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:


P3.JPG

P4.JPG  

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:

P5.JPG

 

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

 

Thanks, I'll try. 

@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

 

View solution in original post

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (2,317)