MSFT Power Automate (Formerly Flow) Connector
I have been testing out the connector that SmartSheet has built for Power Automate (formerly Flow): https://docs.microsoft.com/en-us/connectors/smartsheet/. I am using it to insert a new row into a sheet, triggered when an email is received that meets certain criteria. I am adding information from the email into the new row.
However, the Insert Row action does not support adding attachments to the row. I would like to take the entire email and save the eml file as an attachment to the new row. (Getting the email file is now possible using the Outlook connector: https://flow.microsoft.com/en-us/blog/outlook-connector-more/.) Can you consider enhancing your connector include support for adding an attachment to a row?
I have built Flow connectors in the past for another company. It only requires that a corresponding API call exists, which it does in this case: https://smartsheet-platform.github.io/api-docs/#attach-file-to-row. However, that is separate from the Add Row REST call, so it may make sense to make a separate Attach File to Row flow action which will be called after the row has been created, taking the SheetID and RowID returned by the Insert Row action.
Also, one of the columns in my sheet is Created By. When I configure the Insert Row action, it shows automated columns, but you cannot set the value of those columns. When I tried, my flow failed. You should modify the Insert Row action to exclude any automated columns from appearing.
Answers
-
Hi @Mark Salamon,
When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have these functionalities in Smartsheet.
-
Thanks. I have done that.
-
As a workaround to shortcomings in the Smartsheet Power Automate connector, I have been making direct REST API calls from my flows using the Power Automate HTTP step, such as inserting a row. This works well, but I need to build each call manually and handle authentication.
For a different sheet I was hoping that the built-in Insert Row action in the Connector would work. I took the same message body I was using for the HTTP step and simply made that the Row variable for the Insert Row action. But I received a 400 parsing error instead.
I suspect the issue is that the Smartsheet Connector uses the deprecated v1.1 of the API (https://stackoverflow.com/questions/33684125/error-adding-rows-with-smartsheet-api) and not v2.0. Smartsheet, can you please upgrade the Connector to v2.0 AND also add support for more REST API calls.
