cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBala
Helper II
Helper II

Getting date from 2 SharePoint list

Hi,

I need some help trying to figure out how to build the flow.

 

Have 2 SharePoint list:

  • Employee Order
  • Order Details

The flow will run on Employee Order list,  based on the status, it sends email. I figured that part using  trigger.

PBala_4-1597267655668.png

What I need help with, based on the Order ID, (Employee Orders), information from the Order Details needs also be part of the email.

 

Employee Orders

PBala_0-1597266689582.png

 

Order Details

PBala_2-1597267236133.png

 

 

So when the email is sent on status received for Order 72,  Email also should include, items, quantity and size from the Order Detail list.

 

Below is my flow;

 

PBala_3-1597267546210.png

 

Any help is much appreciated.

 

Thanks

Pbala

 

1 ACCEPTED SOLUTION

Accepted Solutions

which step blocked your flow?

From my experience, you need a sharepoint "get items" action filtered with your order id, then use "create HTML table" to convert the returned item arry into HTML table, insert the output into your mail body.

Michael_Shen_JT_0-1597596568268.png

 

View solution in original post

2 REPLIES 2
PBala
Helper II
Helper II

hi,

Can anyone help me with the above request.

 

Thanks

which step blocked your flow?

From my experience, you need a sharepoint "get items" action filtered with your order id, then use "create HTML table" to convert the returned item arry into HTML table, insert the output into your mail body.

Michael_Shen_JT_0-1597596568268.png

 

View solution in original post

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,979)