cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesM Helper V
Helper V

Unable to get Project List from Project Online / SharePoint

Hi all, 


I've been wanting to test / play around with connecting a Power App to our company Project Online site, in one instance so that I can show a list of projects in the Power App itself. 

 

I have added the Project Online data source and created a new screen with a new vertical text only Gallery. I want to 'bind' the gallery to the list of projects in Project Online.  I am attempting to use ProjectsOnline.ListProjects(siteURL): 

 

2017-03-16 15_21_52-Store Applications DashBoard ‎- PowerApps.png

 

I am unsure what URL to put here, and whether the URL needs to be enclosed within double qoutation marks like a normal string, e.g. "siteURL" 

 

In the browser, navigating to https://api.sharepoint.com/sites/pwa/Projects.aspx provides me with a list of all current projects. If I try to use that URL I get the following warning (and no content) 

 

2017-03-16 15_24_46-Store Applications DashBoard ‎- PowerApps.png

 

If I try with quotation marks I get this error: 

 

2017-03-16 15_25_07-Store Applications DashBoard ‎- PowerApps.png

 

I am surely doing somethign fundamentally wrong here, but can anyone assist? 

 

5 REPLIES 5
Meneghino Community Champion
Community Champion

Re: Unable to get Project List from Project Online / SharePoint

Hi @JamesM

Let me try some educated guesses since no-one else has helped so far.

From the returned errors and some experience of PowerApps, I would say that definitely the URL needs to be a string in double quotations.

I think the problem is that you are providing the URL to a SharePoint page and not to the root site, please notice the format of the required URL in your first screenshot.

Please try this:

ProjectOnline.ListProjects("https://api.sharepoint.com/sites/pwa")

PS This is assuming that your tenant is api

JamesM Helper V
Helper V

Re: Unable to get Project List from Project Online / SharePoint

Thanks for the suggestion, unfortunately I still get this: 

 

2017-03-20 14_29_31-Store Applications DashBoard ‎- PowerApps.png

 

 

Anonymous
Not applicable

Re: Unable to get Project List from Project Online / SharePoint

I have the same problem

JamesM Helper V
Helper V

Re: Unable to get Project List from Project Online / SharePoint

Can you let me know if you figure out a solution? 🙂

GregNixon
New Member

Re: Unable to get Project List from Project Online / SharePoint

I had the same problem, but tried the following, which is now working:

 

   ProjectOnline.ListProjects("https://XXXXXX.sharepoint.com/sites/pwa/").value

 

The .value at the end seems to convert the data format into something that Gallery can accept.  Hope that helps (or that you found another solution).  Regards,

 

Greg.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

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