Raw Output in flow but not in updated row in Excel

[Tinnitus]

Hi everyone

Thank you already for helping me. I have an issue with a flow I've built and it's behaviour.

I see the data in the raw output but it doesn't get stored in the Excel File. And I suspect my filter isn't correct.

The flow:

The flow itself triggers when a new file is uploaded to a SharePoint.

It reads the Excel File and I initialize all the required variables: Firstname, Lastname, PostalCode, EmailAddress and FirstnameLastname (as an identifier for the update of rows in the Excel File).

Then the variables get set with the values from the Excel file in a apply to each loop.

All this works so far.

And I think now comes a part that could be connected to my real issue.

Based on the values in the variables based on the Excel file, I filter the contacts from MS D365 CE/CRM. The filter is built like this:

(emailaddress1 eq '@{variables('lineitem_emailaddress')}' or emailaddress2 eq '@{variables('lineitem_emailaddress')}') or lastname eq '@{variables('lineitem_lastname')}' and firstname eq '@{variables('lineitem_firstname')}' and address1_postalcode eq '@{variables('lineitem_plz')}'

What I want to achieve is: Check if the email in the variable lineitem_emailaddress is either in field emailaddress1 or emailaddress 2.

And also I'd like to check if the variable lineitem_lastame is in lastname and if the variable lineitem_firstname is in firstname and if the variable lineitem_plz is in address1_postalcode in a combination.

So either it should check for the emails or the combination of Lastname, Firstname and PostalCode (PLZ).

I think this also works so far but I'd appreciate it if someone could double check the filter and either confirm if that's the right way to do it to achieve what I want or if there's an error in it. I'm unsure by now where to set parentheses.

And now the real issue.

When I test this with a dataset I do get bad results sometimes.

Firstname	Lastname	Postalcode	Email	OutputID
John	Doe	80000	john.doe@email.com	10000
John	Doe	80010	john.doe@email.com	10000
John	Doe	80000	john.doe@email.net	-

As you can see with my filter I should get the same OutputID for every entry in that table. Because either the Email is correct to identify him in the database or the combination of Firstname, Lastname and Postalcode. But I don't get that data in my Excel File.

Strangely I do get the data in the raw output when I check the flow after it has run. But it's not written into the Excel File. While other entries are correctly updated.

Also I suspect that the flow itself only checks for the emailaddress and not the combination of Firstname, Lastname and Postalcode.

Every input and help is highly appreciated.

If you need any further information, let me know.

[Tinnitus · Accepted solution]

Hi everbody again

I think I just found the issue. As I'm using an identifier, that in this example would be the same for all three lines, the update that looks for the identifier would only update the first entry it finds in the Excel File with the correct identifier value. Correct?

Thanks for a short clarification/confirmation if that's the issue.