Add row in excel not working

Questions
, ,
1

It was working yesterday - today it works to update a record, but I cannot get it to add a record - any help would be great.. I recreated the add a worksheet row .. still no success

image
image1422×743 89.3 KB

image
image1349×706 97.7 KB

3

Hi,
you can remove the filter and define this route as a fallback - it should work in your case.
Anyway, the problem is in the filter, as far as I understand, if #15 will return any data - the Row ID will exist, so the filter will not be passed.

Hopes it help,

4

ok … even as a fallback it does not take the path ? where must be some value returned if it doesnt find a match? but where – I tried setting a variable nothing triggers add row… i recreated the module .. linked it directly and it added a row.. but with condition … it doesn’t run

image
image1108×491 54.6 KB

5

Can you show the configuration of the List module? It looks like it didn’t find anything and the scenario stopped instead of continuing.

6

correct - it seems to just stop … here is the configuration.. when a record is found, it’s updated.. when no records are found .. it stops .. mystery to me!

image
image1129×525 58.4 KB

7

Hi @Jacqueline_Proud

It seems that when the filter condition returns true, the scenario continues and the first route is executed, based on its own filter.

But when the condition is not met (the email does not match between the 1st and 2nd modules), the filter interrupts the execution.

Looks like the correct operation of the filter.

Remove the first filter and add its condition (email matches) for both routes. On the first one, use Equals to case insensitive. On the second one use Does not equal to case insensitive.

That should do it.

@damato