cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martatracik
Resolver I
Resolver I

ActionFailed. An action failed. No dependent actions succeeded.

Hi all! 

I have a flow that finds a specific value in an excel cell, sends an email with information and finally changes found value to another one. Unfortunately, recently flow correctly finds the value, sends an email, but does not change the value. The error it shows is: ActionFailed. An action failed. No dependent actions succeeded.
Do you know how to fix it?

martatracik_1-1669297672899.png

 

4 REPLIES 4
martatracik
Resolver I
Resolver I

+adding additional error that i have 

martatracik_0-1669298106867.png

 

martatracik
Resolver I
Resolver I

i've just read that it is because of the empty rows in my Excel file, i havent spot any, just an empty row at the very end of the file that i removed. let's see if that will work now  

v-chengfen-msft
Microsoft
Microsoft

Hi @martatracik ,

The reason for this problem is:
1. The Key Value is empty, so this column cannot be found and updated.

vchengfenmsft_0-1669340421206.png

In order to avoid the problem of empty column values,
Please use the Filter query in [List rows present in a table] to filter out the columns whose key column value is not empty.

Here is a test for your reference:

Here is excel:

vchengfenmsft_2-1669341055276.png

Here is flow:

vchengfenmsft_1-1669341031606.png

Here is result:

vchengfenmsft_3-1669341093543.png

 

Best Regards

Cheng Feng

 

thank you, does it mean that i need to add in Filter query in [List rows present in a table] my Key value with ne 'Null'? 

martatracik_0-1669807400815.pngmartatracik_1-1669807457300.png

 

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,155)