Hi,
I want to make a flow that when a text or csv file adds to SharePoint, convert it to excel or add the content to a Sharepoint list
The text file rows are like:
02;E02;A-0192;10,000;10,000
so I need to set each part in a column.
Would you help, please?
Hi @Setayesh ,
Because Do until creates up to 60 loops.
You can consider using Apply to each instead of Do until.
Create an integer variable, each time the variable is incremented, and determine if the expected value has been reached. If it is, then the action that is expected to be executed is not executed.
Hope it makes sense.
Best Regards,
Hi,
Many thanks for the respond, I tried that. I need to check each row but it just can get the first 60 rows and I dont know how to fix it. the rows are more than 30000.
the file data is like bellow now: just necessary data kept in csv file
Hi @Setayesh ,
You can use Get file content to get the file content first. The file content of the text file should be plain text.
Then use the split() function to split the content.
Finally, use the array index to reference the value of each element and add it to each column.
Best Regards,
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional