For Each Excel Row (Error BC30451)

Hello everyone.

Is it normal to have an error code BC30451 in this flow?

I’ve checked my other projects with this activity with the same linear flow, but no such error appeared. It seems like it’s a variable usage-related issue.

Hi @I_m_InTheMaking

This error is basically telling you that you are using a variable which you have not declared.

When you dragged/created an activity for each excel row, did you manually created that variable called “CurrentRow” or it was automatically created?

If you simply drag another activity like this, what variable is automatically defined there for the loop?

Use that one and it will resolve the issue.

Hello @sonaliaggarwal47 . Thanks for responding!

Upon checking, CurrentRow is there by default, so I am confused as to why the system does not identify it as a working variable.

I tried altering my workflow like this below, but still no luck in making it detect the CurrentRow:

@I_m_InTheMaking

can you try removing and adding for each loop again
OR
are you using Currentrow outside the for each loop anywhere?

Hello @Darshan_Sable ! Thanks for the response.

I’ve started from scratch again with a new project with the same workflow, and the error persists.

CurrentRow is only used within its scope if I’m not mistaken.

@I_m_InTheMaking update excel activities or instead of CurrentRow use another variable

@Darshan_Sable I updated the package.

I also tried changing the CurrentRow to another name.

When I run the workflow, the error still indicates “CurrentRow”.

@I_m_InTheMaking
try using stable package version instead of preview
after double click on error, which activity does it indicates?

@Darshan_Sable After double-clicking the error, it seems that the issue occurs because I misplaced another project directory inside the project folder that I am currently working on, because it redirects to another project.

I didn’t know it causes conflicts with the current project if there are other project folders inside of it.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.