Answered

Get a list of item by comparing a column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Suppose I have a SharePoint list and I need reminder of the due date. One column have some similar values whereas the other column have all identical values.

Rather than sending email for each overdue item of list, I want the email to be send in a way so It get the similar value (Eg - yes, no) and make a list of other identical value and send me in a same email.

Eg.

Test Name	Status	Supervisor
1	Pass	x
2	Fail	y
3	Pass	a
4	Pass	x
5	Fail	b

Email :

Hi,

You record says that Pass items are :

1 (Test name) - x (Supervisor name)

3 - a

4 - x

Thanks

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

Ed Gonzales 4,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
Hey there. Not totally sure I've got the requirements right, but it looks like if you use the following, you'll get the results you want:
Recurrence Trigger to run however often you want.
SharePoint List Items (you can either add a filter here...something like Status eq 'Pass'....or do the Filter Array in a separate step.
Create HTML Table using the output from the filtered results.
Send an email with the output from the HTML table in the body of the email.
Hope that helps.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Would you please be able to write the expressions?
Ed Gonzales 4,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there.
So, if you use the Filter Array action, you won't need to write any expressions. It would look something like this:

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you..
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help.

By using select it helped me to get the item I need

Solved!!!!!!!!!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Edg,

I have a quick question in this flow, I changed my column of Supervisor (Select multiple users) and now the flow is not working. Do I need to change the expression in the HTMl table?

Please advise as it's bit urgent...