I'm trying to parse through a JSON Custom Object to return a specific instance of a report based on the report's title for my project.
I know I can solve this by creating a loop that checks each instance one by one, however I was hoping there was something more efficient. The only other 'hacky' solution I can come up with is to use the "Parse text" action on the raw JSON to eliminate everything prior to and after the section I want and then rebuild the remaining text back into a JSON Custom Object. Any ideas? Thanks!
Solved! Go to Solution.
I am currently limited to on-premise and this is more or less a proof-of-concept, but I ended up using "Parse text" and "Get subtext". It ain't pretty, but it works.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.