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?
+adding additional error that i have
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
Hi @martatracik ,
The reason for this problem is:
1. The Key Value is empty, so this column cannot be found and updated.
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:
Here is flow:
Here is result:
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'?
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
31 | |
28 | |
25 | |
23 | |
13 |