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

Like (0) Share

Report

Posted on 21 Mar 2024 13:53:39 by vesdinu

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.png Screenshot 2024-03-21 at 15.17.10.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!

All responses (2)

Answers (1)

Verified answer

vesdinu 9 on 26 Mar 2024 at 09:38:16

Like (0)

Report

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).
Then, I added a "Filter array" step and filtered the incoming array for empty values, in order to get only the non-null values.

In the end, in the "Create item" step, I passed in the first element of the incoming filtered array.
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.
Data is coming nicely in my list (ignore the empty title, I simply didn't put anything to populate it):
creativeopinion 10,419 Super User 2025 Season 1 on 21 Mar 2024 at 14:53:02

Like (0)

Report
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