How to add a row to a table if a particular cell is not blank?

[Patricia11]

Hello all,

I created a flow that updates Excel on Sharepoint when an email regarding a quote arrives.

If the quotation number field in Excel is blank, update the row in Excel using the title as a key.

If the quotation number field in Excel is not blank, add a row to the table.

However, even if the quotation number field is not blank, the Excel row is overwritten and updated.

If you know the solution, could you please tell me?

Thank you in advance.

[FLMike]

Hi @Patricia11 

can you please share some images of a Run, where the condition was met (was empty) but it stillwent to the no side.

Because this should never happen. So we need to find one you think SHOULD have gone to the Yes side, then compare the Condition to see what you actually put in there.

Second. Please add a Compose right above your Condition. I want you to put the expression that you put in the left side of the Condition, so we can clearly see what the value was.

Then, you can resubmit a run where you believe it should have worked, and we can get the values from the Condition and the Conditions outputs

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Patricia11]

Hi @FLMike 

Thank you for your reply.

There are no images of runs that were no-sided even though the conditions were met (they were empty).
All rows are updated if the conditions are met.

The problem is that the row is updated even though the condition is not met.
I would like to add a row to the table without updating the row if the condition is not met.

Is there a problem with setting the conditions?

Below is an image of the flow result when the quotation number is not blank (when you want to add a row to the table), and an image of the Excel file and email.

▼email sent

▼Updated excel file (I want to add rows to the table without updating)

Thank you in advance.

[FLMike · Accepted solution]

Hi @Patricia11 

This is why I wanted you to place a Compose above the condition and put the exact same thing that you typed into the condition. So that we can see the value that the condition sees.

You believe it should be NOT blank and therefore create a new record, but the Condition disagrees.

I need to see what it thinks it sees

The condition itself empty() - if you can share that

In the Compose above can you just put whatever is in between the () in the empty expression.

If you are able to test, you can simply add that and then re-run the flow you just showed me and it will give us the details of what it saw and why it didn't think it was empty

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Patricia11]

Hi @FLMike 

Thank you for your reply.

When I put the "substring" inside the parentheses of empty() as you taught me, the row was not updated and the row was added to the table.

Thank you very much for your help.