You’re offline. This is a read only version of the page.
I'm trying to get a Cloud Flow setup whenever a row is added to a Smartsheet that it will copy to Excel as well. I've tried dozens of variations of the following, but can't seem to figure out what I'm doing wrong!
I've read several posts here talking about a potential bug from 2017, and a workaround, but I can't seem to figure it out. Can someone PLEASE help? I've been at it for DAYS!
I'm willing to give it a shot! At the moment, I'll take anything, because I'm about to give up on Power Automate...
Dear Timmons,
Sorry, then my ideas/knowledge also stop. As said, since I do not have an active setup for Smartsheet I cannot test myself. Maybe you can reach out to Smartsheet/owner of the connector?
Alternatively, you could change the trigger to 'when sheet is updated'? Then I have a flow which can help you out.
Happy flowing,
Koen
Yes, those are the raw outputs from both the trigger and action. I just keep getting error "A value must be provided for item." consistently no matter what I try...
Share
Report
All responses (
Answers (
{
"status": 400,
"message": "A value must be provided for item.\r\nclientRequestId: ###",
"error": {
"message": "A value must be provided for item."
},
"source": "excelonline-eus2.azconn-eus2.p.azurewebsites.net"
}
Dear Timmons,
Unfortunately I cannot test this myself at the moment (no active Smartsheet setup).
Is this the output that you get from the trigger? I would expect that somewhere we could identify the actual 'data' we are trying to capture ... the output would then give us an idea how the data is structured and why probably we cannot parse these into Excel at one go.
(I assume the above based on the experiences with the trigger 'when sheet is upedated').
Happy flowing,
Koen
Thanks for the response. The input seems to be working fine, however I just realized that it only works when "inserting a new row" instead of "updating a row". Here's the raw input from the trigger anyways.
{
"method": "get",
"queries": {
"columns": "Hire Date,First Name,Last Name,Full Name,Billing Rate"
},
"path": "/row_created_trigger/sheets/###",
"host": {
"api": {
"runtimeUrl": "https://flow-apim-msmanaged-na-westus.azure-apim.net/apim/smartsheet"
},
"connection": {
"name": "/providers/Microsoft.PowerApps/apis/shared_smartsheet/connections/shared-smartsheet-###"
}
},
"authentication": {
"scheme": "Key",
"parameter": "*sanitized*",
"type": "Raw"
}
}
The action is where it fails
{
"method": "post",
"queries": {
"source": "groups/###"
},
"path": "/codeless/v1.0/drives/###/items/###/workbook/tables/Table1/rows",
"host": {
"api": {
"runtimeUrl": "https://flow-apim-msmanaged-na-centralus.azure-apim.net/apim/excelonlinebusiness"
},
"connection": {
"name": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness/connections/shared-excelonlinebu-###"
}
},
"authentication": {
"scheme": "Key",
"parameter": "*sanitized*",
"type": "Raw"
}
}Dear Timmons,
Could you provide the raw output of the trigger?
In a similar case but based on a different trigger (Smartsheet updated), we also attempted to transfer the data into an excel. In the end, we decided to take the HTML-table output, convert this via various 'Compose' actions to an array and finally move this to excel.
If you want to take this route, suggest you check out the video of Paulie M: https://www.youtube.com/watch?v=qsPdGjgI1oE.
I could also share the conversion flow from 'HTML to Array' with you.
Happy flowing,
Koen
#1
stampcoin
61
#2
Michael E. Gernaey
47
Super User 2025 Season 1
#3
rzaneti
31
Super User 2025 Season 1
