Unanswered

Go to label not working

(0) Share

Report

Posted on by Alphadrag

164

Hi all, as attached in the image, this is my flow. My issue is that if it detects that the excel worksheet is completely empty without data, it will show an error, which i have described below the images. Thus, i have put on error on line 55, and if there is an error, it will go to the label "No CourseCode", and proceed on to the next part of the flow for the next worksheet, which is after the label. However, it is not working. Any idea why? In line 53 of the code, i have also used the same go to label, but that is working

And also, besides using label, how can i do it such that if it detects that get first free row is empty, it will not run through the for loop and proceed on to the next loop?

Error that shows: Start cell row cannot be preceded by end cell row. This is caused by the empty data

This is an image of the excel file, just focus on the red column. I blocked out the other columns as it is not necessary.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alphadrag

According to the logic you have written in line #55, FirstFreeRowOnColumn will return 2.

And you have done a minus 1. So it becomes H2 - 1 = H1

So you are reading values from a bottom row to an upper row ie; H2 to H1 which is incorrect and hence you are getting the error Start cell row cannot be preceded by end cell row.

- Remove the minus 1 and Change to FirstFreeRowOnColumn in line 55

- remove the error handling in line 55

- In line 56, if it finds any data in ProgramName datatable then it will go inside the For loop.

If its has no rows then it will go to line 63 which is after the For loop

Post back how it goes with you.

Was this reply helpful? Yes No
Alphadrag 164 on at

Like
a
(0)

Report
Copy link

Link copied!

What am i doing wrongly? I am trying another way which is to use loop. However, changes is only made to the first row. Below is my flow, which part did i do wrongly?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

It is not clear what you are trying to achieve and what is happening.

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

You're looping it reading and replacing text in row 2 (the first row as its not counting the title row), you need to actually increment the rows, i.e. have an index variable in place inside the read from excel worksheet column H, row "index variable" instead of "2". You in fact already have this index variable which you have called the Loopindexprogram, just put that in there, should work.

Was this reply helpful? Yes No