Export data from collection in Excel

(0) Share

Report

Posted on by VDI

337

In gallery I have given option to select one or multiple records and then user can export selected records.

I am trying to export 2 different collection data into one excel file.

use case: export data from 2 collection into 1 excel file (in excel, should have 1 sheet for 1 collection data and 2nd sheet for 2nd collection data).

I did this using flow and able to export data in csv format but problem is, how to export 2 different collection data into one excel file as mentioned in above use case?, currently exporting it into two different excel.

I already tried one solution that - upload excel to one-drive and then connect that excel in power apps and use Patch().

but, if two ore more user are accessing the app at same time then it will not give me the correct data after export in excel.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@VD ,

Do the collections have the same field names and types? If so, combine them and then export Collection3

ClearCollect( Collection3, Collection1, Collection2 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
VDI 337 on at

Like
a
(0)

Report
Copy link

Link copied!

This will merge two collection in single and download an one excel file with only one sheet but it will combine both collection data.
All I want is, download one excel file that contain two different sheets, one is for 1 collection data and second sheet is for 2nd collection data.
PawelL 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, did you find a solution? I'm struggling with same thing but with 7 collections