Exporting data to Excel from Dataverse for Teams

(1) Share

Report

Posted on by HFG

516

Hello,

Does anyone know if it's possible to export data from Dataverse for Teams to an Excel? Would I need to pass through Power Automate?

Thanks

HFG

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (3)

Report

Hi @HFG,

Currently there is no export data feature on Dataverse for Teams. You would need to use Power Automate to pull the records out using the CDS connector and then insert the rows into an Excel table using the Excel Online connectors.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
HFG 516 on at

Like (0)

Report

Thanks @ChrisPiasecki!

Was this reply helpful? Yes No
HFG 516 on at

Like (0)

Report

Hi @ChrisPiasecki ,

I have another question I'm hoping you might have the answer to.

The current solution uses SharePoint as the data source for PowerApps. Unfortunately, we hit an issue with doing an Excel report using Power Query so had to revert to Power Automate. The problem is that there will soon be more than 5000 rows in one of the tables and we will hit the problem that Power Automate cannot handle this many rows. Do you know if the 5000 rows limit is an issue between Power Automate and Dataverse for Teams? I imagine it is.

If so, can you think of any other way I can get information from a table with more than 5000 rows into an Excel? The Excel itself will have no more than a few hundred lines, but will need to find and pull information from the table that has more than 5000. I hope that makes sense.

Thanks

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @HFG,

For the List Records action on the CDS connector, click settings, then turn Pagination on and increase your limit to up 100k. If you need to export more than that, you'll need to parse the skip token manually and fetch records in a do until loop until the skip token is empty. This is explained in detail in the article below.

http://linnzawwin.blogspot.com/2021/01/retrieve-more-than-100000-dataverse.html?m=1

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
HFG 516 on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
michaelgaci 14 on at

Like (0)

Report

Does anyone know why Microsoft doesn't have a prebuilt solution for doing this? It seems like it wouldn't be that hard to include an option as it's a simple and desirable feature.

Was this reply helpful? Yes No