Skip to main content

Notifications

Community site session details

Community site session details

Session Id : s9KEYD8Mad1J9xpO4bm16e
Power Automate - Building Flows
Answered

Cascade dropdown in MS form stored to Sharepoint List with Power Automate

Like (0) ShareShare
ReportReport
Posted on 21 Mar 2024 13:53:39 by 9

Hi,

I have an MS form and I store the data in a sharepoint list, with the help of Power Automate. The trigger is "When a new form is submitted", then populate the list with the responses.

 

The form has several dropdown fields, which are cascaded, meaning when a user chooses an option from the drop down, it will have a new dropdown populated specifically for that particular option, if he choses from the first dropdown another option, then he will have another list populated and so on.

 

A simple example, with Continents->Countries->Cities:

Screenshot 2024-03-21 at 15.12.50.pngScreenshot 2024-03-21 at 15.17.10.pngScreenshot 2024-03-21 at 15.17.15.pngScreenshot 2024-03-21 at 15.17.20.pngScreenshot 2024-03-21 at 15.17.26.pngScreenshot 2024-03-21 at 15.17.32.pngScreenshot 2024-03-21 at 15.17.40.pngScreenshot 2024-03-21 at 15.17.48.pngScreenshot 2024-03-21 at 15.17.57.png

The tricky part and the question, is how do I store this data, from the cascading fields, into the sharepoint list, through the Power Automate Flow?

Screenshot 2024-03-21 at 15.28.42.png

Basically, for each of the questions (country and city), I have multiple possible answers, depending on the initial continent chosen.

 

Thanks!

  • Verified answer
    vesdinu Profile Picture
    9 on 26 Mar 2024 at 09:38:16
    Re: Cascade dropdown in MS form stored to Sharepoint List with Power Automate

    The coalesce() function did not work for me. For some reason, empty or blank values were not considered null, therefore, they were still considered as valid inputs. The rest of the above suggestions have nothing to do with my initial question, they are just advertising for that youtube channel on my question.

     

    What actually worked for me was something found here: https://www.youtube.com/watch?v=kbqXsKPTmZk

    So, what I had to do was to add a "Compose" step, in which I took the Dynamic content values for all the countries and created an array with them: createArray(Country1,Country2,Country3, etc).

    Screenshot 2024-03-26 at 11.32.02.png

    Then, I added a "Filter array" step and filtered the incoming array for empty values, in order to get only the non-null values.

    Screenshot 2024-03-26 at 11.31.50.png

     

    In the end, in the "Create item" step, I passed in the first element of the incoming filtered array.

    Screenshot 2024-03-26 at 11.33.46.png

    Same thing I did for the cities, meaning another compose and another filter array steps. Even though this workaround is quite long, it works for what I needed. 

    Screenshot 2024-03-26 at 11.35.58.png

    Data is coming nicely in my list (ignore the empty title, I simply didn't put anything to populate it):Screenshot 2024-03-26 at 11.37.18.png

     

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 21 Mar 2024 at 14:53:02
    Re: Cascade dropdown in MS form stored to Sharepoint List with Power Automate

    @vesdinu You need to use an expression and the coalesce() function. Separate each dynamic content with a comma.

    coalesce([Italy city],[Span city],[China city],[etc])

    I would also recommend switching to the Classic Designer. The new designer is still buggy especially when using the MS Form trigger and action.

     

    You might also be interested in these YT Tutorials:

     

    How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    I cover the following in this video tutorial:

    âś… How to get a Microsoft Form Response into SharePoint

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form response

    âś… How to Build a Microsoft Form with Conditional Fields

    âś… How to used Branching in Microsoft Forms

    âś… How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    âś… How to parse a Microsoft Form multiple choice response as string of text

    âś… How to convert a text response to a number

    âś… How to use the Switch action

    âś… How to create a custom email confirmation for a Microsoft Form submission

    âś… How to Create a Custom View in a SharePoint list

    âś… How to use the Compose Action

    âś… How to write Power Automate Expressions

     

    ----

    How to Get Microsoft Form File Uploads Attached to an Email đź“§

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    I’m not going to cover how to get the values from your form since I've already covered that in a different tutorial.

     

    IN THIS VIDEO:

    ‌✅‌ Two types of MS Forms

    ‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌✅‌ Where Microsoft Group Form File Uploads are Saved

    ‌✅‌ How to Add a File Upload Question to an MS Form

    ‌✅‌ How to get a Microsoft Form ID

    ‌✅‌ How to get a Microsoft Form Response

    ‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌✅‌ How to Get the File Content from an MS Form File Upload

    ‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌✅‌ How to Create an Email Key

    ‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌✅‌ How to Create a Dynamic Output Based on Form Selection

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard