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

Can a response reference another list? Read for example

Hey everyone,

 

I have a form that asks for their Warehouse ID. All of this info goes to an MS List. I also have a MS list with all warehouse information (ID, address ect). I want to be able to send an email with the WH address. So somehow i would need flow to look for the WH ID provided from responses in another list. Is this possible? I hope i explained it right.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Charliemacdmv 

 

Thank you for your explanation.

 

If that’s the case, we’d better modify part of the flow.

 

List A to collect response details(You can add several other columns as required.):

v-duann-msft_0-1620024040227.png

 

List B to find according WH address based on ID.

v-duann-msft_1-1620024040230.png

 

Flow overview:

v-duann-msft_2-1620024040233.png

 

For the first 4 steps, they are all the same.

v-duann-msft_3-1620024040237.png

 

For the updated steps(Please pay attention to the painted part 😞

v-duann-msft_4-1620024040241.png

 

After testing, I’m able to receive email with address information.

v-duann-msft_5-1620024040242.png

 

Hope it helps.

 

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

 

Best regards,

Anna

View solution in original post

3 REPLIES 3
v-duann-msft
Community Support
Community Support

Hi @Charliemacdmv 

 

Thank you for posting.

 

According to your description, you would like to send email with WH address, but it’s stored in listB. We need to find this address based on response stored in another listA. If any misunderstanding, please kindly let me know.

 

So based on my understanding, I created two list. One is collection of responses and another one is used to store WH ID and its email address.

 

ListA:

v-duann-msft_0-1619667354464.png

ListB:

v-duann-msft_1-1619667354467.png

 

Flow overview:

v-duann-msft_2-1619667354476.png

 

Flow in detail (Condition is used to compare WH ID between two list and help to find email address accordingly)

v-duann-msft_3-1619667354481.png

 

v-duann-msft_4-1619667354484.png

 

Once tested, I’m able to send email to that WH.

v-duann-msft_5-1619667354488.png

 

Hope the content above may help you.

 

Best regards,

Anna

Thank you for the response. That's sorta what I wanted. I wanted to be able to grab the physical warehouse address from the list and send that in an email.  So response says WH ID is 12345.  Then we reference the second list and grab the WH address for 12345 and populate it in an email.  Is that a little clearer? Thanks for your time.

Hi @Charliemacdmv 

 

Thank you for your explanation.

 

If that’s the case, we’d better modify part of the flow.

 

List A to collect response details(You can add several other columns as required.):

v-duann-msft_0-1620024040227.png

 

List B to find according WH address based on ID.

v-duann-msft_1-1620024040230.png

 

Flow overview:

v-duann-msft_2-1620024040233.png

 

For the first 4 steps, they are all the same.

v-duann-msft_3-1620024040237.png

 

For the updated steps(Please pay attention to the painted part 😞

v-duann-msft_4-1620024040241.png

 

After testing, I’m able to receive email with address information.

v-duann-msft_5-1620024040242.png

 

Hope it helps.

 

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

 

Best regards,

Anna

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (47,359)