I'm a day and a half into this Flow at this point! Wow. Learning a LOT! Feel like I'm down to one final problem to solve (yeah right 🙂 ). Hoping someone can assist here.
Ideas for this one?
I don't think there is a way to make the schemas dynamic. But you could use a Switch statement on some defining value to select which Parse Json action to use in your stream.
Thanks for the reply @Pstork1 . I appreciate you thinking about this. Feels like it would be VERY valuable to be able to add Dynamic Content to the Parse JSON action to accommodate this.
No need for a Switch statement with 12 (or more!) options.
Or even more ideal, specify a URL where the schema is stored and have Flow fetch it.
I agree it would be useful, but it doesn't exist today and I don't think you will see it anytime soon.
Switch action for 12 defined parse json actions as suggested by @Pstork1 will work
It can be made dynamic but would involve a lot of work with expressions
For example - when you query the list and get the response
You can run a for loop on the response results using expression:-
body('action_name')?['d']?['results'] - This will point to the array response of items
Next within the for loop to read each item,
use expression item()?['columninternalname']
To make columninternalname - dynamic - you would need to first query the column names and store them also in a collection
so within the loop for the items array
run another loop on the collection(array) of internal names and then use expression
Main_loop_name - is the name of the main for loop (body('action_name')?['d']?['results'])
item() - will give you the current column name from the columns array
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!