cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattiaD
Frequent Visitor

Error after Switch function

The Switch function should update a row in an Excel Online (Business) but gives the following error:
The execution of template action 'Update_a_row' failed: an unexpected exception encountered when evaluating branching condition.

 

does anyone know why, thank you all in advance

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

@MattiaD update row looks fine, I found a similar thread, please check this out

 

The problem appears to be that the numeric value should in fact be a string. If you change the e.g. Equals 5 to Equals "5", then it works.

 

In your case, the value is 1, please can you try?

 

https://powerusers.microsoft.com/t5/Building-Flows/An-unexpected-exception-encountered-when-evaluati...

 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

View solution in original post

6 REPLIES 6
jinivthakkar
Super User
Super User

@MattiaD please can you share screenshot of the update row action ?

MattiaD
Frequent Visitor

@jinivthakkar 
Of course, this is the error it gives me:

MattiaD_0-1644391381278.png

while in edit mode this is indicated:

MattiaD_1-1644391413953.png

 

jinivthakkar
Super User
Super User

@MattiaD the second image is blur, when you upload, please can you select the size to be large ?

 

Okay, now it should be better I have selected as large size

er.png

jinivthakkar
Super User
Super User

@MattiaD update row looks fine, I found a similar thread, please check this out

 

The problem appears to be that the numeric value should in fact be a string. If you change the e.g. Equals 5 to Equals "5", then it works.

 

In your case, the value is 1, please can you try?

 

https://powerusers.microsoft.com/t5/Building-Flows/An-unexpected-exception-encountered-when-evaluati...

 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

Yes, thank you very much it worked

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,391)