Answered

PowerApps with Power Automate Export to Excel issue

(0) Share

Report

Posted on by CK24

I used Reza Dorrani's video but I am running into an issue with My Export to Excel. My Completion data Column is messing up every time on Row 19 and after. I have sorted my list and exported ascending & descending and the still the same issue. Removed column and added a new one. In power automate it appears to be the output before it gets to Excel. I checked my SharePoint list and the data is fine there. I can provide more information if needed but here are a few example rows of raw input data from PowerApp to Power Automate: 56,"Created 3/7/2022","Req DD ","3/7/2022" 62,"Created 3/8/2022","Req DD ","3/8/2022" 65,"Created 3/9/2022","Req DD ","1646805600000" 66,"Created 3/9/2022","Req DD ","1646805600000"

Export Excel Comp...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CK24 9 on at

Like
a
(0)

Report
Copy link

Link copied!

With the help of a co-worker this issue was resolved by adding the below in Bold:
Set(ExportCSVVar, "");
Clear(ExportCSVCol);
ForAll(BrowseGallery1.AllItems, Collect(ExportCSVCol,
{ID:IDnmbr.Text,
'Date Reported':DteRptd.Text,
'Completion Date': If(!IsBlank(CompDate.Text),Text(CompDate.Text,DateTimeFormat.ShortDate),""),
'Requested Due Date':ReqDD.Text}));
Set(ExportCSVVar, "ID,Date Reported,Requested Due Date,Completion Date"&Char(10)&Concat(ExportCSVCol,
ID&","
&Char(34)&'Date Reported'&Char(34)&","
&Char(34)&'Requested Due Date'&Char(34)&","
&Char(34)&'Completion Date'&Char(34)
&Char(10)));
Set(SuccessVar,ExportCSV.Run("LD Ticket Tracker CSV File",ExportCSVVar).filepathlink);
Launch(SuccessVar&"?e=kFkoax&Download=1")

Was this reply helpful? Yes No
SamanthaLavoie 161 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I'm having a similar issue. I also used Reza's video to create an Export to Excel button and the excel file that is exported has additional data in every column that looks like {"Value":"Column Data"}, plus there are additional columns of information in the excel file that is not in my sharepoint list such as "create by...". I just want the excel file that is exported to look like my share point list. How can I fix this?

Thank you in advance to anyone who has an answer to this problem.

Was this reply helpful? Yes No