Converting text to number

[chickennanban]

I have built a flow that will import a table in Excel file. 

My scenario is doing the following:

1. getting the tables on an excel file
2. Listing the rows on the table
3. Storing the list of rows in an Array called Table_Output
4. Using Parse JSON with a defined Schema for further steps..

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.

[v-xiaochen-msft · Accepted solution]

Hi @chickennanban ,

You could try to use select action.

Sample:

Best Regards,

Wearsky

[chickennanban]

@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.

[v-xiaochen-msft]

Hi @chickennanban ,

Parse Json cannot convert data.

Best Regards,

Wearsky