cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jones2271
Helper I
Helper I

comma delimited info from Infopath repeating table into CSV

I have some data from a repeating table form in infopath that is concatenated into a sharepoint list column. I have a flow that I need to gather this info and put into a .csv file. I have tried splitting, and replacing, to get rid of \n that is somehow being added to the entry, but I cannot remove it. Here is my Infopath concatenated field:  concat("001231,", PLC, ",", PLCDescription, ";") which results in the data in PLCInfo in SharePoint:

Capture.PNG

In my Flow: the inputs and outputs have added a \n:

Capture2.PNG

Capture6.PNG

 The JSON Array:

The apply to each to get the SharePoint info into an array that can be used in a CSV TableThe apply to each to get the SharePoint info into an array that can be used in a CSV TableCapture5.png

Final CSV File: 

My CSV fileMy CSV file

Is there any way to have the user ID: 001231 populate each column?

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,230)