I created a power app for project management. I am able to connected a Planner (premium) plan to my project and to get the data for standard fields (due date, title, etc.) for the tasks. But how can I find out whether a task is a milestone? The is no option milestone yes/no. In Planner, a milestone is indicated by the duration of 0 days, but unfortunately there is no field for the duration in the connector. I can't calculate it either, because when calculating (due date - start date) for tasks with a length of both 0 and 1 day, the result is 0!
I do not know what the issue is where you say 0 and 1 is 0, so please repro that issue. Please then share the expression / code you have as well as the dates themselves marked correctly so we can also just verify it on our side(s).
As for the other milestone question let me see if I can see it. Also, you can try the Graph API explorer to see if, for you, if after querying your tasks, you can see the property you need. It will matter 1) if you have permission in your org to use it 2) if the additional properties are there.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.