web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to format values f...

Power Apps

Answered

How to format values from Gallery collection to JSON then CSV file

(0) Share

Report

Report

Posted on by allan_t

310

Hoping someone can help me understand how to adjust formatting of some values going in or coming out of a JSON object.

Canvas Power App

added a Download button so the user can download a CSV file of data from a Gallery.
The process creates a collection from the gallery data,
JSONFile variable contains the data from JSON function.
A Power Automate flow then runs to convert the JSON object to a CSV table, file created and saved to the users OneDrive.

Download button OnSelect property is:

Power Automate flow to create the file is:

Problem: some of values in the JSON object are ugly when put into the CSV table.

Eg.

ResponseDetails column data contains all the html tags making it difficult for the user to read it.

<div class="ExternalClassblahblahblah"><p>This Request will require full regression testing from end to end at warehouse</p></div>

LeadAssigned column data contains array symbols, making it difficult for the user to read.

[{"DisplayName":"Smith, John"}, {"DisplayName":"Jones, Robert"}]

I'm sure there's a way to reformat this info so it's readable to the user. I don't how or where to do it in the process. Any help would be greatly appreciated. Thank you.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @allan_t ,

I've made a test for your reference:

1\I assume there is an array:

2\My flow

1)

item()['ResponseDetails']

2)

items('Apply_to_each')['LeadAssigned']

3)

item()['DisplayName']

4)

{ "Column1":@{items('Apply_to_each')['Column1']}, "LeadAssigned":@{body('Join')}, "ResponseDetails":@{body('Html_to_text')} }

Best Regards,

Bof
allan_t 310 on at

Like
a
(0)

Report
Copy link

Link copied!

This was really helpful, thank you again.

Join the conversation