Microsoft Power Automate Insert row

Shahara Anderson

Hello, I am having an issue inserting a new in SMARTSHEET when a new form is created. I receive the following error. I was able to correct the other errors, but I at a loss on this particular error. Any help is definitely appreciated.

Thanks,

Shahara

Andrée Starå

@Shahara Anderson

Not sure, but it seems like there isn' multi-select support either in Smartsheet or in Microsoft Power Automate.

Try changing the multi-select columns in Smartsheet to Text/Number to see if the values come over. If they do, we can probably use so-called helper columns to convert it back to a multi-select column.

Make sense? Did it work?

Andrée Starå

Hi @Shahara Anderson

What is the value you're trying to add, and what is the column type?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots of the sheet? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shahara Anderson

Hi @Andrée Starå .. Thank you for the reply. I want to use MSFT Forms to add new line to my sheet. I have includeded screenshots of both my form and flow.

Thanks,

Shahara

Andrée Starå

@Shahara Anderson

Happy to help!

Do you know which column the error message is referring to?

Shahara Anderson

@Andrée Starå

I believe it is referring to " Body Part Affected" and "Contributing Factors", both columns are set as Drop Down (Multi Select). My form also had multi select as an option. Once I removed multi select from both columns the flow worked. Is it possible to use multi select or a formula that will enable the sheet to accept the data from FORMS?

Thank you again for your help and time.

Shahara

Andrée Starå

@Shahara Anderson

Not sure, but it seems like there isn' multi-select support either in Smartsheet or in Microsoft Power Automate.

Try changing the multi-select columns in Smartsheet to Text/Number to see if the values come over. If they do, we can probably use so-called helper columns to convert it back to a multi-select column.

Make sense? Did it work?

Shahara Anderson

@Andrée Starå

Thank you so much for your help, your solution worked. I appreciate your help on this issue!

Best,

Shahara

Andrée Starå

@Shahara Anderson

Excellent!

You're more than welcome!

Alex Herrity

@Andrée Starå

You mentioned above using 'helper columns' to convert the values from a Text/Number column into Dropdown (Multi Select) column.

I have a similar issue to the OP where I am bringing across multiple answers to a question from an MS form and creating a new row in Smartsheet. Unfortunately it looks like Smartsheet (or MS Forms) does not support the transition of the multiple answers into a Dropdown (Multi Select) column.

It's no problem to bring them across into a Text/Number column but I'd really like the values to be replicated in a Dropdown (Multi-Select) column as this will be better for my reporting/dashboard later down the line.

Thanks,

Alex

realexample

Why not just have the users submit their values using a form with a lookup list (e.g. email addresses, this way the email addresses submit will always be correct). This is better than allowing them to type an incorrect email address by accident (e.g. janee_doe@any.com; jane_doe@any.com).

There are 2 columns in the contact list: Name and Email address. I wonder if you have to include both columns?

Hopefully, Smartsheet would find away to allow your entries to be checked against a list, if not exists just add them to the list

John Sauber

Supply multi-select values by comma-separating what you want in the multi-select column. This works with Power Automate, but the steps previous to adding the row need to ensure the values are passed already comma-separated. What little documentation there is on this powerful feature does not explain this.