web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power automate Use a s...
Power Automate
Answered

Power automate Use a stream to join two tables in Dateverse

(0) ShareShare
ReportReport
Posted on by

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

Categories:
I have the same question (0)
  • Verified answer
    v-chengfen-msft Profile Picture
    on at

    Hi @Anonymous ,

    I made a template for your reference:

    Here is tableA:

    vchengfenmsft_0-1673919717212.png

    Here is tableB

    vchengfenmsft_1-1673919948450.png

    Before creating a flow, we need to get the logical name of the ordernumber column

    vchengfenmsft_2-1673920114949.png

    Here is flow:

    The way we use characters to stitch html tables

    vchengfenmsft_3-1673920838019.png

    Use filter rows for tableB, where the logical name of tableB ordernumber is required

    vchengfenmsft_4-1673920884218.png

    Fill the filtered values into the table

    vchengfenmsft_5-1673920938246.png

    Email the html table

    vchengfenmsft_6-1673920968188.png

     

    Here is result:

    vchengfenmsft_7-1673921521938.png

     

     

    Best Regards

    Cheng Feng

     

  • Community Power Platform Member Profile Picture
    on at

    Thanks, my good brother!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard