cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sorcerer
New Member

Create a CSV without JSON

Is it possible to create a CSV file in Power Automate without using a JSON?

 

I have a Cognito Forms trigger, and I just want to map the data that is filled out in the form and via a couple of calculations into a csv file.

 

I've tried with the "Create a CSV table" data operations action, but I don't understand how to use the "From" field.

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

Hi @Sorcerer 

 

A CSV is a plain text file.  So you can use a compose and construct the line(s) as you see fit using dynamic content and expressions.

 

Damien

View solution in original post

5 REPLIES 5
DamoBird365
Super User
Super User

Hi @Sorcerer 

 

A CSV is a plain text file.  So you can use a compose and construct the line(s) as you see fit using dynamic content and expressions.

 

Damien

View solution in original post

eliotcole
Power Participant
Power Participant

We've just been playing with CSVs a LOT in this thread here:
Extracting a substring from parsed JSON data in a Loop

😉

Hi @eliotcole 

 

Looks like you have written a book about them 😂

eliotcole
Power Participant
Power Participant

hahahaha, cheers, @DamoBird365 ... I know ... right?!

 

If I had, though, it'd be a horror story:

Legacy Data And Not Letting Go

 

(obviously that casts shade at no-one ... we just know that people will take their "spreadsheet Dbs" to their grave in their cold dead hands, am I right?)

Ah I see, thank you so much!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,964)