Thanks so much, we have a couple of reports where ‚D‘ opens up new possibilities. So far, we have exported to Excel for distinct count.

thanks for posting your solution! What's the role of the 'D' in DCNT?

Thank you! Looks like painful trail-and-error but very nice approach!

Are you overall satisfied with the solution?

@Anthony Imgrund‚ : cool stuff! I'm exited to give it a try!Have you found a tutorial/reference on what is possible with HTTP calls or do I need to go purely trial-and-error?

Would be great if you could share some information about how to get started and perhaps some "dos and don't" from your experience

@Sarah Nau‚: wow, nice! Is Power Automate directly connected to your Workfront's API or did you involve any 3rd party app in between?

Thinking about the 2nd option, a Fusion Workfront to Workfront connection with some logic could eventually get close to that functionality? Something like "when logging an hour to a project, update the custom fields with hours per year"? Disadvantage is for sure the associated costs (Fusion is about...

Someone in the Power Automate Community has requested a connector, but obviously hasn't received support yet. Please keep us posted on a potential solution - I'd love to see your idea realized!

Unfortunately not. We have tried to tackle similar management requirements but Workfront's object-based data model prevents a solution.The workaround shown above is clever, even though a bit sad that implementing dummy hours is necessary. We also considered connecting a BI tool like Tableau via Fusi...