Cross reference information from 2 lists in to send in 1 email

(0) Share

Report

Posted on by CBrinky

Hi all,

My current flow is ->

When an item is created or modified

Site address: Sharepoint

List Name: My List Name

Condition

"Dynamic content" is equal to "VALUE"

If yes

Send email to people

If no

Nothing

The flow grabs information from list 1 when a column = "value" and sends other values from other columns in an email.

I want to add some more columns into the same email from list 2.

List 1 and List 2 have "Job Number" & "Sales Order Number" columns where the values are = to each other & a 3rd column in list 2 that holds a column that list 1 does not have.

How can I use those 2 columns that are related to add the 3rd unrelated column in to an email?

Thanks in advanced for the help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @CBrinky ,

I recommend that you look for Sales Order Numbers with the same number in list 2 by using the current Sales Order Numbers of list 1 in the flow.
This is my test for your reference:

Best regards,
Rimmon

Was this reply helpful? Yes No
CBrinky 2 on at

Like (0)

Report
Copy link

Link copied!

I feel like I'm misunderstanding something - I tried this and it fails flow.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @CBrinky ,

Please read the content and picture below and then modify your flow.

The formula in filter query can filter records of list 2 which's Job Number column has same value with Job Number dynamic content of trigger.

Best regards,
Rimmon

Was this reply helpful? Yes No