cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chickennanban
Helper I
Helper I

Converting text to number

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.

chickennanban_0-1663726795974.png

Fyi here is the field in Excel table as input:

chickennanban_2-1663727041686.png

Any suggestion how I can convert a String to Integer there? What am I missing?

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @chickennanban ,

 

You could try to use select action.

Sample:

vxiaochenmsft_0-1663731604390.png

vxiaochenmsft_1-1663731636975.png

 

Best Regards,

Wearsky

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @chickennanban ,

 

You could try to use select action.

Sample:

vxiaochenmsft_0-1663731604390.png

vxiaochenmsft_1-1663731636975.png

 

Best Regards,

Wearsky

@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
Community Support
Community Support

Hi @chickennanban ,

 

Parse Json cannot convert data.

 

Best Regards,

Wearsky

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,858)