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.
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?
Workflow Consultant / CEO @ WORK BOLD
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, [email protected])
I hope that helps!
Be safe and have a fantastic week!
✅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!
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.
Happy to help!
Do you know which column the error message is referring to?
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.
Thank you so much for your help, your solution worked. I appreciate your help on this issue!
You're more than welcome!