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 / Lookup Value from Data...
Power Automate
Answered

Lookup Value from Dataverse table and join with another Dataverse table

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I have a flow which is scheduled to run once a day. It is listing the rows in table 1 which were created that day, putting that data into a csv file and then emailing that file to an external user.

 

Table 1 - Meter Readings

Unit ReferenceMeter TypeReadingDate Taken
BORTH0058Electric50000012/06/2024

 

Table 2 - Property Information

Unit ReferenceAddressCountry
BORTH005858 Borthwood RoadUK

 

I want to add the Address to the final csv file, therefore sending a csv file which looks like.

 

CSV File

Unit ReferenceAddressMeter TypeReadingDate Taken
BORTH005858 Borthwood RoadElectric50000012/06/2024

 

Examples above but the expectation is that there could be 300 readings taken in 1 day, so i'd need it to match each Unit Reference on the Meter Readings table.

 

I'm thinking this should be simple but i can't get it to work.

My Flow without any linking >

Initialise Variable - RowCount - 0

>>
DataVerse - Table 1 - "List Rows" filtered to yesterdays date
>>
DataVerse - Table 2 - "List Rows" 
>>
Set Variable - RowCount - Table1
>>
IF table 1 has greater than 0 rows proceed
>>
Create CSV table
>>

Send Email with Attachment

Categories:
I have the same question (0)
  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @PowerMeAutomate 

    I have demonstrated this using SharePoint. But same logic can be used for Dataverse as well

    The way I will achieve this is by creating an array variable to store combined data

    SudeepGhatakNZ_0-1718332940563.png

     

    SudeepGhatakNZ_1-1718332961446.png

     

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
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard