Answered

How to compare two column and get there email id to send email to them

(0) Share

Report

Posted on by Aswath1

My requirement is to Compare two columns and get their email address and send an email notification.

(Compare the PartnerByCustomer Column with partner names in the partner list, take the email id from there, and send a notification).

So here are the column names.

Screen Shot 2023-05-30 at 1.36.21 PM.png

so here is the partner list which is getting compared:

Screen Shot 2023-05-30 at 1.36.40 PM.png

plz help how to fill in get items function by using fillter query.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Aswath1

Is your PartnerByCustomer in anther list instead of partner list?
If so, you could use Get items for the list that contains PartnerByCustomer > add anther Get items for the partner list, write the formula in Filter Query:
PartnerByCustomer eq 'DynamicContentofParnersName'
Add a condition and let:
length(outputs('Get_items_2')?['body/value'])
is not equal to 0, if yes, send an email to the addresses stored in the Email column.

If all the columns are in the same list, then use one Get items is enough, and write the formula in Filter Query:
PartnerByCustomer eq 'DynamicContentofParnersName'
Or use a Condition to let ParnerByCustomer equals to ParnersName.

Best regards,
Sylvia

Was this reply helpful? Yes No
Aswath1 42 on at

Like (0)

Report
Copy link

Link copied!

Is your PartnerByCustomer in another list instead of a partner list?
My PartnerByCustomer is in the sales pipeline list. not in the partner list

Was this reply helpful? Yes No
Verified answer

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Aswath1

Thank you for letting me know! Then you could follow the first method I provided, which is:
Use Get items for the list that contains PartnerByCustomer (here is sales pipeline list) > add anther Get items for the partner list, write the formula in Filter Query:
PartnerByCustomer eq 'DynamicContentofParnersName'
Add a condition and let:
length(outputs('Get_items_2')?['body/value'])
is not equal to 0, if yes, send an email to the addresses stored in the Email column.
Here is a similar demo for your reference:
Solved: Re: Compare value between 2 Sharepoint List and Up... - Power Platform Community (microsoft.com)
Hope it helps.

Best regards,
Sylvia

Was this reply helpful? Yes No
Aswath1 42 on at

Like (0)

Report
Copy link

Link copied!

thank you soo much

Was this reply helpful? Yes No