I'm looking to automate the process of moving daily Excel file attachments into Smartsheet. My ideal solution would append all these files to a single table, although uploading them as individual row attachments would also be acceptable.

So far, I've set up a Power Automate flow that filters for Excel files when a new email arrives. However, I'm encountering an issue with the HTTP request action—the URI keeps returning an error stating "Enter valid URI." Despite verifying the URI configuration, the error persists.

I've also tried parsing the data as a JSON, but that doesn't work either

Can anyone provide guidance on how to properly move these attachments into Smartsheet using Power Automate?

I'm looking to automate the process of moving daily Excel file attachments into Smartsheet. My ideal solution would append all these files to a single table, although uploading them as individual row attachments would also be acceptable.

So far, I've set up a Power Automate flow that filters for Excel files when a new email arrives. However, I'm encountering an issue with the HTTP request action—the URI keeps returning an error stating "Enter valid URI." Despite verifying the URI configuration, the error persists.

I've also tried parsing the data as a JSON, but that doesn't work either

Can anyone provide guidance on how to properly move these attachments into Smartsheet using Power Automate?

• outlook
• power-automate
• smartsheet-api
• smartsheet-api-2.0

1 Answer 1

[sheetid] and [rowid] are expected to be populated with the ID's of the relevant objects. They are nothing more than placeholders.

https://smartsheet.redoc.ly/tag/attachmentsDescription#section/Post-an-Attachment

You need to get the sheet ID and the row ID and then replace them in the URL.

Think about it, how does it know which sheet and which row you want to upload the attachment to? It doesn't know unless you provide it with the relevant ID's.