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
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications