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?
Share Improve this question asked Mar 8 at 0:14 dhk02dhk02 114 bronze badges1 Answer
Reset to default 0[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.
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1744906669a4600300.html
评论列表（0条）