Automate current date import using Power Automate
As you all know, Anaplan cannot display the current time from a function, so it needs to be imported into a module by an import action. As described here it can be done via Python: Import and automate current date import to Anaplan. I would like to to show you an easier way of doing it when your organization has access to Microsoft Power Automate.
For starters, create a module in Anaplan for loading the current time. In this case it is a module with only one line item formatted as text:
Now you can setup a Power Automate flow. If you choose a scheduled power flow the first step is already added (Run flows on a schedule in Power Automate - Power Automate | Microsoft Docs). The next step is getting the current date and time. You can use the variable step in Power Automate:
The next step is getting the authorization token. You can use the HTTP action for this (this is a premium action, so you can only use it when you have premium): How to get started with HTTP requests in Power Automate - Microsoft Tech Community
Now you only need to get the token from the response in a Parse JSON action and use the token in the API call for writing the data to your module:
And there you go:
Thanks for reading, and please contact me if you have any further questions.