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?
Solved! Go to Solution.
Hi @Mgodby
Yes you can use Parse JSON flow step.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @Mgodby
Yes you can use Parse JSON flow step.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
37 | |
37 | |
32 | |
28 |
User | Count |
---|---|
39 | |
37 | |
31 | |
28 | |
23 |