cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drax_2106
Regular Visitor

Split CSV in excel column to different rows using Power Automate

Hi All!

 

I want to build a certain format for a report wherein after creating an excel table with the required fields, I want to split a CSV value column (For Instance, Code below) 

IDResponse_Info1Response_Info2Code
1MarcWhite22,18,89,737
2RobJr23,17,90

like:

IDResponse_Info1Response_Info2Code
1MarcWhite22
1MarcWhite18
1MarcWhite89
1MarcWhite737
2RobJr23
2RobJr17
2RobJr90

 

This should be the final report format that the end user sees in the excel file. Please help in solving this problem statement.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @drax_2106 :

I've made a test for your reference:

1\My Table:

vbofengmsft_0-1639451399031.png

2\My Flow:

vbofengmsft_1-1639451458705.png

vbofengmsft_2-1639451471701.png

The Result:

vbofengmsft_3-1639451509323.png

Best Regards,

Bof

 

 

 

 

View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @drax_2106 :

I've made a test for your reference:

1\My Table:

vbofengmsft_0-1639451399031.png

2\My Flow:

vbofengmsft_1-1639451458705.png

vbofengmsft_2-1639451471701.png

The Result:

vbofengmsft_3-1639451509323.png

Best Regards,

Bof

 

 

 

 

Hi @v-bofeng-msft 
This looks good but I am not able to see the split function clearly. If you could send that picture once again, it would be great!!

 

Thanks!

Hi @drax_2106 :

Sure.

split(items('Apply_to_each')['Code'],',')

vbofengmsft_0-1639467437296.png

 

Best Regards,

Bof

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,085)