Answered

Get a list of item by comparing a column

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (6)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Re: Get a list of item by comparing a column

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Get a list of item by comparing a column

Would you please be able to write the expressions?

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Get a list of item by comparing a column

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Get a list of item by comparing a column

Thank you..

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Get a list of item by comparing a column

Thank you for your help.

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

Solved!!!!!!!!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Get a list of item by comparing a column

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...

Was this reply helpful? Yes No