web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Convert csv file to JS...

Power Automate

Answered

Convert csv file to JSON format

(0) Share

Report

Report

Posted on by JeffGimo

221

Is there a way to convert csv files to JSON format?

I have tried searching for same question but no luck.

Please advise.

Categories:

I have the same question (0)

All responses Img

All responses (18)

Answers Img

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you please post a sample format of your CSV file? Is that got a header?

Was this reply helpful? Yes No
JeffGimo 221 on at

Like (0)

Report
Copy link

Link copied!

Please see picture as I can't attach the csv file.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @JeffGimo

Please see this post

Microsoft Flow (advanced) tutorial : creating a CSV to JSON converter from scratch | Serge Luca aka "Doctor Flow" (Office 365 MVP and Microsoft Power Platform MVP) (wordpress.com)

Thanks

Was this reply helpful? Yes No
JeffGimo 221 on at

Like (0)

Report
Copy link

Link copied!

The sample examples are not working as per my testing. Will wait for another response. There might be some work around here.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report
Copy link

Link copied!

You really should be able to post a sample of the CSV here, even if it is only a few lines. If you would like a compelling response it would be really helpful. You can fictionalise the data if it is sensitive.

Was this reply helpful? Yes No

JeffGimo

221 on at

Like (0)

Report

Here's the sample data:

Session Data by ID
SSID	Session Count (%)	Client Count (%)	Duration (%)	Total Usage (%)	Usage (In/Out)
test1	90 (54.22%)	26 (48.15%)	1d:11h:35m (62.06%)	939.09MB (50.69%)	814.94MB/124.15MB
-	36 (21.69%)	13 (24.07%)	0d:2h:55m (5.09%)	0.00B (0.0%)	0.00B/0.00B
test2	21 (12.65%)	13 (24.07%)	0d:8h:35m (14.97%)	538.12MB (29.05%)	500.54MB/37.58MB
test3	14 (8.43%)	8 (14.81%)	0d:8h:0m (13.95%)	25.28MB (1.36%)	20.60MB/4.68MB
test4	3 (1.81%)	2 (3.7%)	0d:0h:20m (0.58%)	55.76KB (0.0%)	26.93KB/28.84KB
test5	2 (1.2%)	1 (1.85%)	0d:1h:55m (3.34%)	350.14MB (18.9%)	338.73MB/11.41MB

Was this reply helpful? Yes No

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

But that isn't a CSV. If you want a good result, you should post the CSV that you are going to use in Power Automate.

Was this reply helpful? Yes No
JeffGimo 221 on at

Like (0)

Report
Copy link

Link copied!

Sorry. Can you teach me how to upload a csv file? I get this error below upon trying.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just open the CSV on your machine, copy and paste a few lines, ideally into the code window:

Was this reply helpful? Yes No
JeffGimo 221 on at

Like (0)

Report
Copy link

Link copied!
Thank you so much.
here it is
Session Data by SSID,,,,, SSID,Session Count (%),Client Count (%),Duration (%),Total Usage (%),Usage (In/Out) test1,90 (54.22%),26 (48.15%),1d:11h:35m (62.06%),939.09MB (50.69%),814.94MB/124.15MB -,36 (21.69%),13 (24.07%),0d:2h:55m (5.09%),0.00B (0.0%),0.00B/0.00B test2,21 (12.65%),13 (24.07%),0d:8h:35m (14.97%),538.12MB (29.05%),500.54MB/37.58MB test3,14 (8.43%),8 (14.81%),0d:8h:0m (13.95%),25.28MB (1.36%),20.60MB/4.68MB test4,3 (1.81%),2 (3.7%),0d:0h:20m (0.58%),55.76KB (0.0%),26.93KB/28.84KB test5,2 (1.2%),1 (1.85%),0d:1h:55m (3.34%),350.14MB (18.9%),338.73MB/11.41MB
. Thanks for the instruction.

Was this reply helpful? Yes No

Join the conversation