cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Super User
Super User

CONNECTION ON PROJECT BY FLOW TO POWERAPPS - PROJECTS AND TASKS

Hey guys, I want to connect all projects and tasks in PowerApps, but I'm trying to connect via formula and / or via flow (API).

 

 

Here are three flows that I have in my environment for testing:

 

The first one takes all the tasks of the project:

 

PROJECTOTASKS.png

 

The second to a specific project:

 

projecttospecifictask.png

 

The third all projects:

 

projecttoalldata.png

 

So, as the @v-bofeng-msft , told me in my other post, if I don't know the project ID I use this formula:

ProjectOnline.ListProjects("https://sampletenant.sharepoint.com/teams/pwa").value

 

And it works on PowerApps!

 

And also posted two useful links:

 

https://docs.microsoft.com/en-us/connectors/projectonline/#list-projects

https://www.youtube.com/watch?v=V4iNhW4p4dg

 

You'll see this in this post:

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/CONNECTION-ON-PROJECT/m-p/626838#M198619

 

So, what I want to know is how to connect the project tasks in PowerApps, and then show the tasks for that selected project on a second screen.

 

 

And also if it would be possible to show all tasks in PowerApps, or some way of doing that within PowerApps.

 

_______________________________________________________________________________________________________________________________________

I did this, using the formula of the  @v-bofeng-msft:

 

projectonpowerapps.png

 

I selected the project I created and on the second screen I put some labels to see what was coming and got some data:

 

showthedetailsofproject.png

_______________________________________________________________________________________________________________________________________

 

And for notes only this is the project created as a test with only one task:

 

project name and task.png

 

_______________________________________________________________________________________________________________________________________

 

If you've read this far, thank you! And whoever can help me, I will be forever grateful!

 

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,908)