Forum Discussion
How to automatically sync availability with Project Professional?
Hello everyone, I am quite new to MS Project Professional and I have assigned resources to different tasks. Now, instead of entering vacation times etc. manually per resource, I would like to sync t...
Thank you for the clarification.
Do you know if Project has some kind of API that would maybe allow for PowerAutomate to enter the data into the Project file for me?
I admit that I am not a fan of PowerAutomate as it seems to be quite rudimentary in what it can do (especially compared to other flow based automations like Node-RED) but I might be willing to spend an hour or two on it if it saves me the manual labor 😉
AleXSR700 --
No, I do not believe that Power Automate would work in this case. You would need to create a macro in Microsoft VBA, but I doubt you would have access to the Outlook calendars of the people on your team. But if you did have access to their Outlook calendars, you could write a macro that combines Project VBA with Outlook VBA to extract the data desired from their calendars. Just a thought. Hope this helps.
No, I do not believe that Power Automate would work in this case. You would need to create a macro in Microsoft VBA, but I doubt you would have access to the Outlook calendars of the people on your team. But if you did have access to their Outlook calendars, you could write a macro that combines Project VBA with Outlook VBA to extract the data desired from their calendars. Just a thought. Hope this helps.
