I have built a flow that will import a table in Excel file.
My scenario is doing the following:
But when running a flow, it gave me the below error in the step 4. Parse Json:
"Invalid type. Expected Integer but got string"
In Parse Json connector, I specified the data type as "integer" but flow thinks it's string.
Fyi here is the field in Excel table as input:
Any suggestion how I can convert a String to Integer there? What am I missing?
Thank you.
Solved! Go to Solution.
@v-xiaochen-msft Thanks for the answer but isn't it possible to do this with Parse JSON function? The reason I'm asking this is there are tons of fields to handle so it takes a lot of time to do regression test if I decide to use Select function instead.