web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy Smartsheet to Excel
Power Automate
Unanswered

Copy Smartsheet to Excel

(0) ShareShare
ReportReport
Posted on by 15

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!

 

TimmonsNG_0-1678723615352.png

 

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!

Categories:
I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at

    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

     

     

     

     

  • Timmons-NG Profile Picture
    15 on at

    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"
     }
    }
  • Unknown geen idee Profile Picture
    1,757 on at

    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

  • Timmons-NG Profile Picture
    15 on at

    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...

     

    {
     "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"
    }

     

  • Unknown geen idee Profile Picture
    1,757 on at

    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

  • Timmons-NG Profile Picture
    15 on at

    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...

  • Unknown geen idee Profile Picture
    1,757 on at

    Happy flowing

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard