Microsoft Power Automate Insert row
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
Best Answer
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you so much for your help, your solution worked. I appreciate your help on this issue!
Best,
Shahara
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives