Unanswered

Turning Semi-Colon delimited CSV in Excel File

(0) Share

Report

Posted on by Hack-7

226 Moderator

Looking for some guidance on what (I think) shouldn't be too complex, not just not working in my favor. I am processing a gallery in PowerApp that is generating an Export to Excel, but because the columns are not in the desired order, I wanted to rework the process which has put me down a rabbit hole and now I want to get this working.

I am using a button in my App using UpdateContext() and Concat()

UpdateContext(
 {
 varCSVFile:
 "ID;Building;City;State_Province" & Char(13) &
 Concat(
 galList.AllItems,
 ID & ";" &
 BuildingName & ";" &
 City & ";" &
 ProvState & ";" &
	 Char(13)
 )
 }
);

My Flow triggers properly and if I add 'Terminate' after the 1st Compose I see the data as expected Header, then new line data, then new line, etc...

Then everything goes sideways... If I try and add a Compose for first() it does not work. if I just try a spilt() by ';' that also does not work...

I have watched some videos and looked at other threads. I just can't seem to figure this out.

Any thoughts or suggestions?

Cheers

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Anil_g 668 Moderator on at

Like (0)

Report
@Hack-7

I believe as per format..first you need to split with char(13) and that gives each row then split with semi colon to get each column under that row
cheers

Was this reply helpful? Yes No
Hack-7 226 Moderator on at

Like (0)

Report

@Anil_g that is what I assumed but I am not sure how to properly spilt() off the char(13)! Still a Flow rookie.

Cheers

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report

@Hack-7

try with split(stringhere, '\r')

First check in the flow run history how the value is coming from power app

instead why not join with some other character and split?

cheers

Was this reply helpful? Yes No
Hack-7 226 Moderator on at

Like (0)

Report

@Anil_g yes this is what I was thinking of doing to simply the actions. Add something like the '|' character with the char(13)

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report

@Hack-7

That would help a lot..and did you happen to check how the string looks in the flow run page?

cheers

Was this reply helpful? Yes No
Hack-7 226 Moderator on at

Like (0)

Report

@Anil_g Yes, I am looking at the output of the Flow as I move along the testing.
My issue now is this.
The source from PowerApps comes in to the Flow as:
Header1;Header2;Header3|char(13)
ID1;Building1;City1|char(13)
ID2;Building2;City2|char(13)

Then I have a Compose that does this:
split(outputs('Content'), '\r')
And it Returns this:
Header1;Header2;Header3|char(13)|\rID1;Building1;City1|char(13)|\rID2;Building2;City2|char(13)

My next Action is:
split(first(outputs('splitOnEndOfLine')), ';')
But that returns:
[
"Header1",
"Header2",
"Header3",
"ID1",
"Building1
...
]
I am not sure where I am going wrong on this!

Was this reply helpful? Yes No