Answered

Power automate Use a stream to join two tables in Dateverse

(0) Share

Report

Posted on by Community Power Pla...

How to JOIN two Dataverse tables in Power Automate

I have two tables with the same order numbers, and I need to connect them using a stream and then sift through some of the information in it, how to do it

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Power automate Use a stream to join two tables in Dateverse

Thanks, my good brother！
Verified answer

v-chengfen-msft on at

Like (1)

Report

Re: Power automate Use a stream to join two tables in Dateverse

Hi @Anonymous ,
I made a template for your reference:
Here is tableA:
Here is tableB
Before creating a flow, we need to get the logical name of the ordernumber column
Here is flow:
The way we use characters to stitch html tables
Use filter rows for tableB, where the logical name of tableB ordernumber is required
Fill the filtered values into the table
Email the html table

Here is result:

Best Regards
Cheng Feng