{"id":110990,"date":"2018-10-31T04:24:09","date_gmt":"2018-10-31T11:24:09","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-halloween-costume-decisions-made-easy-with-flow\/"},"modified":"2025-06-11T08:06:23","modified_gmt":"2025-06-11T15:06:23","slug":"intermediate-flow-of-the-week-halloween-costume-decisions-made-easy-with-flow","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-halloween-costume-decisions-made-easy-with-flow\/","title":{"rendered":"Intermediate | Flow of the Week: Halloween Costume Decisions Made Easy With Flow"},"content":{"rendered":"

What’s Up Flow Fans?\u00a0 \u00a0Happy Halloween!\u00a0\u00a0<\/p>\n

This weeks Flow of the week is written by April Dunnam. April is owner and lead consultant at\u00a0ThriveFast<\/a>, a Microsoft Partner focusing on building business solutions with SharePoint, PowerApps and Flow. She is an active blogger and speaker, blogging under the name SharePoint Siren<\/a>. Check out her YouTube Channel<\/a>\u00a0and follow her on Twitter\u00a0HERE.<\/a>\u00a0Also, be sure to leave some questions or comments below and she will be happy to answer them!<\/p>\n

The Goal:<\/h1>\n

It’s Halloween and you still haven’t picked out a Halloween costume.\u00a0 We want to find a way to make Flow do the work and pick out a Halloween costume for us!<\/p>\n

Requirements:<\/h1>\n
    \n
  1. A Flow subscription<\/li>\n
  2. A SharePoint list that contains a variety of possible costume options<\/li>\n
  3. A PowerApps subscription (optional) – For this article, I decided to create a PowerApp to kick off the Flow and return the costume.\u00a0 This isn’t a requirement though as you could accomplish the same result with just a Flow button if you wanted to.<\/li>\n<\/ol>\n

    Setting up the Costume Database<\/h1>\n

    The first step is to set up and configure the SharePoint list.\u00a0 You’ll want to create a new SharePoint list called Costumes using the Custom list template.\u00a0\u00a0In addition to the already included Title column add three other columns Single Line of Text Columns:\u00a0 Gender, Category, Image.\u00a0\u00a0Populate the list with some of your favorite Halloween costumes and tag what Gender and Category it falls under (Superhero, Time Period, Horror, etc).\u00a0 You can also include an Image of the costume so we can see that in PowerApps.\u00a0\u00a0<\/p>\n

    <\/p>\n

    Creating the Flow<\/h1>\n

    In Flow, create a Blank Flow and rename it to HalloweenHelper.<\/p>\n

    For your Trigger, Select PowerApps.\u00a0 If you don’t want to use PowerApps then use Flow Button as your Trigger.<\/p>\n

    To retreive a random costume, we need to add a “SharePoint – Get List Items” Action.\u00a0 We will point this action to the site where we created our Costumes list.\u00a0 In the Filter Query of the Get List Items Action we will input the following formula so that we only return costumes that fit the selected gender and category:<\/p>\n

    <\/p>\n

    Now that we have a list of the costumes that meet our requirements we need to get that down to one randomly selected item.\u00a0 To do that, we will add a “Compose” action.\u00a0 In the input for the compose action, we will utilize Flow’s rand function which let’s us get a random item.\u00a0 The formula will look like this:<\/p>\n

    body(‘GetCostumes’)?[‘value’][rand(0,length(body(‘GetCostumes’)?[‘value’]))]<\/p>\n

    <\/p>\n

    Now that we have a random item, we need to pass that item back to our PowerApp.\u00a0 To do that, add a “Respond to PowerApps” action.\u00a0 If you are using a Flow button instead of a PowerApp then you would insert a “Notify” action.\u00a0\u00a0<\/p>\n

    In the Repond to PowerApps action, add two inputs:\u00a0 SelectedCostume and SelectedImage.\u00a0\u00a0<\/p>\n

    Set the value of the SelectedCostume output to the following expression:\u00a0 outputs(‘GetRandom’)[‘Title’]<\/p>\n

    Set the value of the SelectedImage output to this expression: outputs(‘GetRandom’)[‘Column4’]<\/p>\n

    <\/p>\n

    Rename your Flow and Save.<\/p>\n

    The PowerApp<\/h1>\n

    For the PowerApp side of things, create a blank phone layout app.\u00a0 On the landing page, insert two buttons that allow you to select the gender for the costume.\u00a0 On click of each of those buttons,\u00a0 use the Set function to set a variable which holds the selected gender.\u00a0<\/p>\n

    <\/p>\n

    The next screen is a gallery of all of the categories to choose from.\u00a0 Once a categoy is selected, we want that to call and execute the Flow to get a random costume. If you want to call a Flow from PowerApps, click on the OnSelect property of the button that you want to use to execute the Flow.\u00a0 Select the “Action” bar in the ribbon then select “Flows”.\u00a0 A list of all the Flow’s with PowerApps as a trigger will show up on the right hand side.\u00a0 Select the Flow you just created and pass in the gender and category options.\u00a0\u00a0<\/p>\n

    <\/p>\n

    The last screen is the one that shows you the result.\u00a0 We will just need to insert an image control and a label.\u00a0 Set the Image property of the image control to varResult.selectedimage and set the Text property of the label to varResult.SelectedCostume.\u00a0\u00a0<\/p>\n

    <\/p>\n

    <\/p>\n

    Conclusion<\/h1>\n

    To see how it all comes together in action, check out the video below:<\/p>\n