cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iamandyf1996
Level: Powered On

Re: read csv file and write to destination

This worked almost perfectly for me!

 

I'm having one little issue - the data in one of the columns consistently ends with a comma (,) which is tricking the "process each column" section into thinking that it is mulitple columns because the criteria of "end with a (,)" is being met.

 

Below is an example of the format of the data in the column. In this example, row 1 and row 3 would cause issues, but row 2 would work perfectly. 

 

         ExampleColumn

"Thing 1, thing 2, thing 3,"

"Thing 5, thing 6, thing 19"

"Thing 1, thing 12, thing 7,"

 

Is there any way around this without someone physically having to open the file and correct the data in the column?

 

Thanks,

Andy.

1 REPLY 1
Highlighted
iamandyf1996
Level: Powered On

Re: read csv file and write to destination

Whoops - this is just a combination of it being too early on a monday and me being stupid...

 

I created a compose that replaced (,",) with (",), then replace the @{split(items('process_escape_char'),'"')} to @{split(outputs('Compose'),'"')} in "set each data row" and that looks to have resolved my issue.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 214 members 5,362 guests
Please welcome our newest community members: