Accepted Solutions
Hi @krish11
One possible option is to convert this string to pipe delimited |.
You can do this in one long expression or using many compose actions. So this can be tidied up but the end result is :
Assume Compose is my original CSV
1. replace(outputs('Compose'),',,',',"",') //replace all instances of ,, with ,"",
2. replace(outputs('Compose_2'),'",','|') //replace all instances of ", with |
3. replace(outputs('Compose_3'),'"','') //replace all instances of " (double quotes) with nothing i.e. '' (single quotes)
4. split(outputs('Compose_4'),outputs('ReturnLine')) //split the string by a return line (which is a compose with a return line in it)
5. use a select on the result and skip element 1
Each value of the map is split(item(),'|')?[0] //0 is element 1 etc, split each result and choose the element by number
A tidy solution is :
And here is the combined expression for the TidiedCSV Compose.
split(replace(replace(replace(outputs('Compose'),',,',',"",'),'",','|'),'"',''),outputs('ReturnLine'))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
Hi @krish11
One possible option is to convert this string to pipe delimited |.
You can do this in one long expression or using many compose actions. So this can be tidied up but the end result is :
Assume Compose is my original CSV
1. replace(outputs('Compose'),',,',',"",') //replace all instances of ,, with ,"",
2. replace(outputs('Compose_2'),'",','|') //replace all instances of ", with |
3. replace(outputs('Compose_3'),'"','') //replace all instances of " (double quotes) with nothing i.e. '' (single quotes)
4. split(outputs('Compose_4'),outputs('ReturnLine')) //split the string by a return line (which is a compose with a return line in it)
5. use a select on the result and skip element 1
Each value of the map is split(item(),'|')?[0] //0 is element 1 etc, split each result and choose the element by number
A tidy solution is :
And here is the combined expression for the TidiedCSV Compose.
split(replace(replace(replace(outputs('Compose'),',,',',"",'),'",','|'),'"',''),outputs('ReturnLine'))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
I really appreciate all your help. I don't believe you created a video for my problem. Really impressive.
I did exactly all steps as you mentioned here and in the video.
But still, in the end, I'm not getting JSON format. What I'm getting is this:
This is not what you have mentioned in the previous screenshot. And I have used the same data that you used.
And still, I wrote JSON format by Myself and tried to add in the SharePoint List but nothing is coming in the List.
You helped me a lot. But I don't know what I am Missing. And flow ran successfully every time. But no content like yours.
And one more question I have for you what you wrote in ReturnLine? I wrote the same ReturnLine in Input.
Please let me know if I am doing wrong at any steps. Thank You again.
@Paulie78 , @DamoBird365 Hello,
I am transferring This CSV file to the SharePoint List. But this is happening every half an hour and this creates items is creating NEW records every time. I don't want to repeat if that record already exists in the list.
For that, I have used Get Items from SharePoint List and then compare those 2 lists.
for Expresion in Filter query I have compare both lists unique ID column,
equals(item()?['file_x0020_id_x0020_'], items('Apply_to_each')['file_id '])
But this expression is throwing an error. And the condition part I am comparing the Length of those Apply to each section.
But It's not working. Can anyone please suggest a better way to compare both lists?
Helpful resources
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.
