How to remove parts of a text?

[Mgodby]

I have a GET request that pulls data from Project Online Tasks. My issue is that it returns the data as JSON.

In PowerApps I was able to remove the first 9 characters and the last 3 to just get 55. Is there a way to do that in Flow?

[abm · Accepted solution]

Hi @Mgodby 

Yes you can use Parse JSON flow step.

[v-litu-msft]

Hi @Mgodby,

Yes, there are substring() function you can use to get the "55".

Or use the method provided by @abm, after parse JSON, will get "55h" string, then use replace() function to remove "h", for example: replace('55h', 'h', '')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.