Help Updating a Dataverse Table with Excel Table

[JBart]

I've been trying to build a flow following the solution from this post - I'm running into two issues.

https://powerusers.microsoft.com/t5/Building-Flows/Update-Datavere-record-from-Excel-Data/td-p/81082...

1. I get to the Apply to each 2, Condition step, and this is the error I'm receiving: 

There are definitely 10 serial numbers in my Excel table that do not exist in my Dataverse table. 

This is my current flow set up: 

2.  What am I doing wrong in the "Add a New Row" setup?  ID is an auto-generated number in the Datavers table, how do I handle this?  Also, Date Disposed is not in my Excel file, that should be blank.

Thank you in advance for your time and help!

[v-liwei-msft · Accepted solution]

Hi @JBart ,

I suggest you change len to length.

I think this link will help you a lot:

Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

Best Regards,

Levi