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


Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!


Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,980)