cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JamesM
Level 8

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
Level 10

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
Level 8

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
Level 8

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

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

GregNixon
Level: Powered On

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
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
Users Online
Currently online: 232 members 5,485 guests
Please welcome our newest community members: