cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smangerino
Level: Power Up

Trouble Connecting PowerApps to Asana

Hi,

 

I'm attempting to connect PowerApps to Asana to bring the information into a data table. I've been successful in connecting to Sharepoint and an excel table saved locally. When I attempt to connect to Asana, I put in my credentials and I get to this view... (see below) but I can't get past it. Clicking the Asana tile does nothing and it's not listed as a selectable option in the Items drop down menu. As a disclaimer, I'm new to PowerApps but I haven't found any information online of other users attempting to connect to Asana.

 

The same thing happens when I try to connect within Power BI. I'm able to log into Asana through PowerBI, but none of the data pulls through.

 

If anyone can point me down the right path, I'd be very thankful.

 

PowerApps and Asana Hiccup.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Trouble Connecting PowerApps to Asana

Hi @smangerino ,

Do you want to connect your Data Table to Asana connector within your app?

Based on the issue that you mentioned, I think you have something misunderstand on the data source type within PowerApps.

There are two types of data source within PowerApps -- Action datasource and Tabular datasource. More details about the types of data source within PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list

 

Currently, within PowerApps, the Data Table control is only supported to connect to Tabular data source (e.g. SP list, SQL Table, Excel table, etc) rather than Action datasource (e.g. Office 365 Users, Office 365 Outlook, Azure AD, etc).

The Asana connector is a Action datasource within PowerApps, you could not use it as a data source directly within Data Table control.

On your side, you need to type corresponding functions the Asana connector supports as data source within the Data Table control. I have made a test on my side, please take a try with the following workaround:

E.G. If you want to list all members of a workspace in your Asana within the Data Table control, please take a try with the following workaround:7.JPG

Set the Items property of the Data Table control to following:

Asana.ListUsers("1110974203451056").data

On your side, you should type:

Asana.ListUsers("Your Workspace ID").data

More details about get workspace ID in Asana, please go to https://app.asana.com/api/1.0/workspaces (ensure you are logged into Asana when viewing this page).

 

More details about available functions supported within Asana connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/asana/8.JPG

 

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Trouble Connecting PowerApps to Asana

Hi @smangerino ,

Do you want to connect your Data Table to Asana connector within your app?

Based on the issue that you mentioned, I think you have something misunderstand on the data source type within PowerApps.

There are two types of data source within PowerApps -- Action datasource and Tabular datasource. More details about the types of data source within PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list

 

Currently, within PowerApps, the Data Table control is only supported to connect to Tabular data source (e.g. SP list, SQL Table, Excel table, etc) rather than Action datasource (e.g. Office 365 Users, Office 365 Outlook, Azure AD, etc).

The Asana connector is a Action datasource within PowerApps, you could not use it as a data source directly within Data Table control.

On your side, you need to type corresponding functions the Asana connector supports as data source within the Data Table control. I have made a test on my side, please take a try with the following workaround:

E.G. If you want to list all members of a workspace in your Asana within the Data Table control, please take a try with the following workaround:7.JPG

Set the Items property of the Data Table control to following:

Asana.ListUsers("1110974203451056").data

On your side, you should type:

Asana.ListUsers("Your Workspace ID").data

More details about get workspace ID in Asana, please go to https://app.asana.com/api/1.0/workspaces (ensure you are logged into Asana when viewing this page).

 

More details about available functions supported within Asana connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/asana/8.JPG

 

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

smangerino
Level: Power Up

Re: Trouble Connecting PowerApps to Asana

This is amazing! Thank you so much for the guidance!!!!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,858)