Answered

MS Flow fails at end of textfile

(0) Share

Report

Posted on by arobinson15

I have a flow that reads a tab delimited text file and writes data to an online Excel spreadsheet. It reads all of the rows but then fails after the last row. The tab delimiter, newline character, and an array for each data row are initialized.

The text file has headers. Each data row contains tabs and ends with the return character. The array value is set as follows:

skip(split(body('Get_file_content_using_paht'),variables('CarriageReturn')),1)

In the apply to each routine, the variable that splits the data into columns is set as follows:

split(items('apply_to_each_-_data_rows'),variables('TabDelimit'))

ISSUE: The return character at the end of each row is being included in the last column's value. This is not desired but I can live with this since the data in inserted into the online spreadsheet as expected. However, the flow rails after the last row is processed. It does not recognize when it's reached the end of the file.

How can I get flow know when it's reached the end of the text file. Please advise.

Thanks,

ARobinson15

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @arobinson15

Before your process each line check the length is greater than zero.

Thanks

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @arobinson15,

Could you please provide an instance of the entity need to processed?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

arobinson15 19 on at

Like (1)

Report

Thanks for your recommendation. It helped me learn a about another Flow function. However, LENGTH did not work in this case.

I did get the flow to end successfully by adding a COMPOSE action.

Thanks again.
ARobinson15

Was this reply helpful? Yes No