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:
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?
Basically, for each of the questions (country and city), I have multiple possible answers, depending on the initial continent chosen.
Thanks!
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):
@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
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional