Now to the interesting part of this flow: We want to exactly post this random list item but we if we look into our Dynamic Content, it gives us only content from the Get items action, but that is before we get a random list item, and as we do’t want to tweet ALL list items, this isn’t a good idea. The output of this Compose action will reflect a random list item. The arguments inside of the expression 1,length(body('Get_items')?) mean that our flow needs to pick a random number between 1 and (as this value could change over time) the amount of list items (which is expressed by our length(body('Get_items')?))expression. We use the rand() expression to get a random list item from that list. We need to do some magic so we get a random item, I used the following expression for that:īody('Get_items')?))] Now our flow needs to get all items from the list that we want to randomly pick one item from. This is a screenshot of my list:Īnd this is the overview of the flow that we are going to build:įirst things first, our trigger needs to be the Recurrence trigger, in which we specify, in which rhythm this flow shall run. Let’s say we wanted to post a random item from a SharePoint list to twitter each day using Power Automate. Now that you know what JSON is, here is a little use case. If you want to know what exactly is JSON and what you need to know about it, please read this great article by Bob German in the Microsoft 365 PnP Community at TechCommunity or watch this cool video by April Dunnam first, I will just wait here for you. We can see a a lot of JSON in our Power Automate flow run history, and if you wonder, how you can parse JSON to make Dynamic Content (which is selectable) out of it so you can more easily make use ob an object, then this post is made for you.
How to use Parse JSON action in Power Automate
0 kommentar(er)
