date and time for google calendar

[edukardo]

Sorry for my basic question, but couldn't find the solution into the community

I'm trying to query google calendar for today's appointments, but can't find the expression for query it from the start of today untill the end of today.

Thanks for your patience

[v-xida-msft]

Hi @edukardo,

Could you please share a screenshot of your flow's configuration?

If you want to query today's appointments based on the start of today and the end of today, please take a try with the following workaround:

Within Min Time field of "List the events on a calendar" action, type the following formula:

startOfDay(utcNow())

Within Max Time field of "List the events on a calendar" action, type the following formula:

startOfDay(addDays(utcNow(),1))

The flow works successfully as below:

More details about using expression in flow actions, please check the following article:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

Best regards,

Kris

[edukardo]

¡YES!! Worked perfectly.

Many thanks to you

Eduardo K

[v-xida-msft]

Hi @edukardo,

Do you have any questions about your scenario?

Or do you have any other questions about Microsoft Flow?

If you have any questions about Microsoft Flow, please feel free to reply here, we would provide a proper solution for you.

Best regards,

Kris

[edukardo · Accepted solution]

Thanks. I'm pretty satisfied