Export Excel

[gikido]

Hello everybody

I want to export excel from powerapps canvas and I tried to export it from the gallery but the problem is that the excel only contains 100 lines...so i would like export excel from database, collecting all registers on a JSON object, but i don't know how to do it. 

[v-bofeng-msft]

Hi @gikido ,

I've made a test for your reference:

1\ I assume there is a gallery and it's items property is :

Filter(Table1,true)

2\Create a flow(CreateCSVFile)

3\Insert the flow to the canvas app

4\Add a button and set it's OnSelect property to:

Launch(CreateCSVFile.Run(JSON(Filter(Table1,true))).sharelinke)

In addition , you can also use PCF to download a csv file, please check this link:

Export as Excel from PowerApps (without Automate) | by Pixel Perfect - PowerApps | Medium

Best Regards,

Bof

[gikido]

@v-bofeng-msft thank you for your reply,

I did the same thing, and the excel file was generated but the problem is that it only contains the first 100 records of the gallery while there are more than 4000 records. second problem is that the order of the columns is generated according to the alphabetical order and I want to classify them according to a precise order.

[v-bofeng-msft]

Hi @gikido ,

Could you please show me show me your 'FlowName.run()' formula?

In addition, please do not use 'Gallery.AllItems', cause It will only return records that the gallery has already loaded ( The gallery does not load all records at once)

Best Regards,

Bof

[gikido]

@v-bofeng-msft  Yes i think the problem is in using 'Gallery.AllItems', but I don't know what I'm going to replace it with; knowing that I have 3 filters

[v-bofeng-msft]

Hi @gikido ,

You could replace Gallery.AllItems directly with the formula in the Items property of this Gallery.

Best Regards,
Bof

[gikido]

@v-bofeng-msft Thanks I managed to generate the excel file but this time I got 2000 records. can I have more since the table contains more than 3000 records. (the sql server database)

[v-bofeng-msft]

Hi @gikido ,

Cause JSON is not delegable or maybe you're using a function that can't be delegated. You can get the first 2000 records first, and then get the last 1000 records separately into JSON strings. Then convert them, into arrays separately in flow, and finally merged with unions.

Another way is to filter data sources in flow, as flow has no delegation restrictions.

Best Regards,

Bof

[gikido]

Hello @v-bofeng-msft 

for the delegation there is no sign. and for the method of having 2000 records then 1000 then merged with union is that you can give me more details on this method.
for the filter at the flow level how can I do that? knowing that I have almost 5 filters and each time the user chooses different values?