web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Create table from csv ...

Power Apps

Answered

Create table from csv string

(0) Share

Report

Report

Posted on by Jeff_Dalton

5

Hi!

I hope someone can help me with this:

I am importing data from an Azure runbook into PowerApps by using Power Automate. The output i get looks like this:

Header1,Header2,Header3,Header4

Value1,Value2,Value3,Value4 ...and so on

Now I need it to be formatted as a table to be able to present it in a nice way.

I've been trying to use the Split function but I wont get it in the way I want.

Any Ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@Jeff_Dalton

Suppose you have a CSV string like this:

Set(myCSV, "Header1, Header2, Header3, Header4 Value1, Value2, Value3, Value4 Value5, Value6, Value7, Value8 Value9, Value10, Value11, Value12" );

Use this code:

ClearCollect(myTable, Split(myCSV, Char(10)) ); Clear(myTable2); ForAll( myTable, Collect(myTable2, { Heading1: First(Split(Result,",")).Result, Heading2: Last(FirstN(Split(Result,","),2)).Result, Heading3: Last(FirstN(Split(Result,","),3)).Result, Heading4: Last(Split(Result,",")).Result} ) );

To get this result:

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Jeff_Dalton 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot! This was exactly what i wanted.

Was this reply helpful? Yes No

Join the conversation