Collect two dataverse table and export to excel

(0) Share

Report

Posted on by AA-21021826-0

Can someone guide me,

I've two dataverse table pulled into canvas app in power apps.

Table 1 pulls records from Allocation and Table 2 pulls from Collateral Position.

I have already created a "ExportExcel" control and where I wanted to use this on the fx option to pull records from both table 1 and table 2, export into a single excel file with two tabs (for table1 and Table2). I was looking at reza dorrani video's on excel export but he only mentioned about using that from gallery (fx = JSON(ShowColumns(Gallery4.AllItems,.......) and not for tables records .Can someone help?

Categories:

Building Power Apps

help on formula.jpg

I have the same question (0)

All responses (2)

Answers (0)

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @AA-21021826-0

To export data from two Dataverse tables into a single Excel file with two tabs, you can use Power Automate to handle the export process.

This is a example of how the flow might look:

PowerApps Trigger -> List rows (Allocation) -> List rows (Collateral Position) -> Create file (Excel) -> Add a row into a table (Sheet1) -> Add a row into a table (Sheet2) -> Respond to PowerApps

And in Power Apps, you can call the flow like this:

Set(varExcelURL, YourFlowName.Run()); Launch(varExcelURL);

Hope this helps.

Was this reply helpful? Yes No
AA-21021826-0 6 on at

Like (0)

Report

Hi SpongYe,

Thank you for your answer

Can it be done in PowerApps without using Power Automate ?

Was this reply helpful? Yes No