converting string to parsejson

[Ali123]

Hi All

i wanted to convert string i.e  [{"col1":"2000","col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"},{"col1":"20","col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"}] which is coming from powerapps to parsejson before converting i also wanted to change data type from string to number for col1

any solutions?

[Sundeep_Malik]

Hey @Ali123 

Take a compose action and add your string in it:

[{"col1":"2000","col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"},{"col1":"20","col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"}]

After this use parse JSON action and use outputs of above compose in that, in schema again add your string.

For your column 1. I am not sure how to do it.

You can initialize a string in the starting.

And before storing the above data in a database, use set variable action and add the column 1 in it.

I hope this helps.

[Ali123]

Thanks for the reply sundeep,

im doing this for converting that string in col1 to convert it to int..how to do it

[Sundeep_Malik]

@Ali123 

Do the following:

Make a compose, pass your inputs in that. After that use outputs of that compose: 

After this make a array variable.

Use apply to each and pass the body of parse json.

Inside apply to each use action append to array and in the value add col1 with formula: 

int(item()['col1'])

Now you have got an array of integers. 

I hope this helps. 

[Ali123]

im getting this error

Unable to process template language expressions in action 'Append_to_array_variable' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[Sundeep_Malik]

@Ali123 

It worked for me. Can you show the flow in edit mode? And also what you wrote in append array. 

[Ali123]

i think wrong column name i given

[Ali123]

int(item()?['col1'])

[Sundeep_Malik]

@Ali123 

Instead of col1 use your variable:

CurrentYearCredits

[Ali123]

[

  2000,

  2000

] output coming like this but i need full array

[Sundeep_Malik]

@Ali123 

Ok I thought you just needed the integer values. Now just instead of an array, use compose:

For the column 2 & 3, dont write int, only write item()?['col2'] & item()?['col3'].

Or if you want to append it to an array variable you can do that do. Just use compose first and then the output of that compose in append array.

[Ali123]

but i need final output array like this [{"col1":2000,"col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"},{"col1":20,"col2":"2022-09-14T00:00:00","col3":"2022-09-14T00:00:00"}]

[Sundeep_Malik · Accepted solution]

Hey @Ali123 

got a better approach for you. My bad. 

Use the body of parsejson in select action:

This is much easier approach. My bad. Its 1am here. So, feeling a little bit sleepy. haha. 

[Sundeep_Malik]

@Ali123 

I hope the select one worked?

[Ali123]

yes it worked i actually i tried that before but in put for select is in string so it not worked now its working, here also 1pm :D, thank you for your support will mark this as solution