You’re offline. This is a read only version of the page.
Announcements
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 Reference | Meter Type | Reading | Date Taken |
| BORTH0058 | Electric | 500000 | 12/06/2024 |
Table 2 - Property Information
| Unit Reference | Address | Country |
| BORTH0058 | 58 Borthwood Road | UK |
I want to add the Address to the final csv file, therefore sending a csv file which looks like.
CSV File
| Unit Reference | Address | Meter Type | Reading | Date Taken |
| BORTH0058 | 58 Borthwood Road | Electric | 500000 | 12/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
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
Share
Report
All responses (
Answers (
