cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ricky_12eptembe
Frequent Visitor

Devops to Google Calendar

Hey team, Trying to build a flow which will create an event in g calendar from devops based on the target date. I just want to have the event based on Target date. Tried to do with start date and target date to be the same and it does not work. I am thinking to to do Start Date = Target date -1 but can't seem to get the expression to work. Any help will be appreciated.

PowerAutomate.PNG

12 REPLIES 12
vikulkar
Community Support
Community Support

Hello @ricky_12eptembe ,

 

It looks like the date format is missing in your expression.

The addDays expression should be used in the below format:

addDays(timestamp: string, days: integer, format?: string)
 
For Eg to return yesterday's date we use: addDays(utcNow(),-1,'MM/dd/yyyy')
 
Thanks and Regards,
       Vikas K
 

I want to use the Target date in the PBI instead of UTCNow - can I do that?

I was trying to do that but could not get Target date in there. Any help will be appreciated.

Yes, in your case you will have to pass the target Date that you obtain from the previous action.

 

Can I not do both at the same time.

In your case the target date expression should look like:
triggerOutputs()?['TargetDate'] (ensure that you pass the correct column name)
 
so the expression should look something like:
addDays(triggerOutputs()?['Target Date'],-1,'MM/dd/yyyy')

Get the below error

 

Capture22.PNG

anyupdate on this.

@ricky_12eptembe 

 

Based on the error message, it looks like the first parameter in the addDays function is getting a null value.

Please do open a Service Request and we can assist you further.

can you please advise, how to open a service request?

Screenshot.PNG

Don't have Help+ on my dashboard. Is there any other way to create this request?

any update on this

Helpful resources

Announcements
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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,400)