Unanswered

2 Inquiries about Export CSV from PowerApps

(1) Share

Report

Posted on by Lino

123

Hello everyone,

I got an ExportToCSV button. in powerApps with the code as follows: (The first part just connects to a Sharepointlist).

My Flow looks like this:

My questions are the following:
1. I cannot seem to change the position of the columns. For example, the "ID" does not appear as the first column in the csv file. I do not know where and what to change to modify this.
2. How can i change the titles of my columns. The columns i call into the ShowColumns function came directly from Sharepoint.

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi Lino

I only way I know of doing this is to create the CSV "manually" as below. You then do not need Parse JSON in the Flow as it is already in the proper format
Set( varCSV, "ID,Title,Description,Project Status,Analyst,Manager,Creation Date,Launch Date,Completion Date,Type,Category,Product,BU,Region,Market" & Char(10) & Concat( AccessLevelTable, ID & "," & Title & "," & Description & "," & 'Status (ProjectStatus)' & "," & Analyst & "," & Manager & "," & Creation_Date & "," & Launch_Date & "," & Completion_Date & "," & Type_T & "," & Category_T & "," & Product_T & "," & BU_T & "," & Region_T & "," & Market_T & Char(10) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No