Showing results for 
Search instead for 
Did you mean: 
New Member

Connecting to Smartsheet



I am new to PowerApps so forgive me if it's a stupid question. I want to be able to connect to Smartsheet as a data source and be able to change the data in Smartsheet using PowerApps. Is this possible?

Community Support
Community Support

Re: Connecting to Smartsheet

Hi @Krcmjaster ,


Yes, PowerApps supports the connection with SmartSheet. It can be searched in Connection tab. Just go to connect it as your datasource.

All actions you can work with SmartSheet are list below, please take for reference.

Add a comment to a discussion

Add a comment to an existing discussion.

Add a discussion to a row

Add a discussion to a specific row in a sheet.

Add a discussion to a sheet

Add a discussion to a sheet

Get a discussion

Get a specific discussion.

Get a sheet

Get a specific sheet.

Get discussions for a sheet

Get the discussions for a specific sheet.

Get subfolders of a folder

Get subfolders of a specific folder.

Get the columns of a sheet

Get the columns of a specific sheet.

Get the columns of a sheet (dynamic schema)

Get the columns of a specific sheet in dynamic schema format.

Insert row

Insert a row into a specific sheet.

List the sheets

Get a list of the sheets.

Annotation 2019-09-25 114127.png

Best regards,


New Member

Re: Connecting to Smartsheet

@v-siky-msft Thanks. And how can I visualize it? when get the sheet I get only empty columns with unnecessery  columns like in attached screenshot.  

Advocate II
Advocate II

Re: Connecting to Smartsheet



Dd you ever get a response on this?

I'm just starting to now to use smartsheet as a datasource and i've found no good examples of how to acheive this.

Helpful resources


Microsoft Ignite

This will be a conference that you do not want to miss!


New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,744)