Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Flows to Smartsheet not running with Admin authorization

Hi friends,

I am building a flow that puts Microsoft Forms input into a Smartsheet. When I try to add content like a free form "Other ____" from a multiple choice, into a dropdown column, I get the error:

"The value for cell in column (column number), (cell value), did not conform to the strict requirements for type PICKLIST."


I have "Restrict to dropdown values" unchecked in Smartsheet. Why doesn't the flow run as an admin or with my admin credentials? I can put free form text in dropdown columns when I edit, but apparently the flow running with my same credentials cannot?


Does anyone know how to work around this? Is there a way to add automatic admin or API authorization to a flow?


Thank you A MILLION!




Helpful resources


Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.


Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,725)