I am reading data from an excel table and writing to Dataverse. I have a few fields in the excel table that should be numeric; but are sometimes empty or a user could mistakenly write a letter or word into, and cause it to have invalid data. The target fields in Dataverse are set to type decimal.
When I run the flow the bad fields are causing an error.
The empty field is showing as value "" (two double quotes) which is not numeric and causes the error.
I need a way to check for invalid values and replace with 'null' in those cases. And I would like to do that with an expression if possible. I am currently using an expression to map the excel fields to the Dataverse fields as shown above, for example, the AIRLINES0600 uses this =
items('Apply_to_each_2')?['AIRLINES0600']
Would it be possible to add some additional logic to this line? Test for numeric and if it fails use the value null instead? I don't know the syntax enough to know how to do this.
Thank you.
