I have a problem with maintaining a SQL table from an Excel file. Found a similar request here: Excel for-each to match data with SQL and tried to follow the solution.
My problem is that I get an error in the select query.
Message is: "Term 'Key_Field eq 'xxxxxx'' is not valid in a $select or $expand expression."
The Key_Field is the name of my field in the SQL table, that holds the same info as the field Key coming from the Excel file.
Then some compose fields, before this:
The lefthand side of the condition: empty(body('Get_rows_(V2)')?['value'])
But I'm not even getting to that stage.
So, instead I tried to remove the Select Query from 'Get Rows (V2)', and add the key fields in the condition part, like this:
I have more fields to add to the condition, but picked only one, for the test of it. It results in False, even though both fields are text fields. So to secure that the field from Excel actually is a text field, I tried to do a compose action to create a string, and use the output for comparison, but the result is the same: False.
How do I get the comparison to work, so I can insert new rows and update existing ones?
