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

Announcements

News and Announcements icon
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 Microsoft Employee

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
    Microsoft Employee 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
    Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard