34
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
| A-0129 |
| A-0134 |
| A-0247 |
| A-0281 |
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,
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
