Answered

Formatting date retrieved from google calendar

(0) Share

Report

Posted on by Amf

I was succesful in connecting my apps to my google calendar API but currently stuck on how to format the date into a more representative format. I had tried using several options but yet to solve this issue of mine

The formula that I had tried was Text(start,"[$-en-US]mm-dd-yyyy") which I learned from a webinar. It did not show any error in the formula but did not change the date format either. Hopefully someone could enlightened me with a sollution

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

AndyPennell Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The first thing to check is the actual type of the variable start: if it is in fact a string then you will need to turn it into a DateTime (using the DateValue) first, then you can reformat it using Text in the manner you listed. If problems persist please share the value you are seeing for start.

Was this reply helpful? Yes No
Amf 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Good day Mr Andy,

Thank you for your reply. I'm not sure on the format of the date in google calendar and how to go about searching for it. However just to better describe my current stumbling block. Here is a screenshot of what I'm currently testing out.

Hopefully this better describe my situation. I'm currently exploring other connections to understand what powerapps can achieve. Thank you sir and have a wonderful day ahead

Was this reply helpful? Yes No
Verified answer

AndyPennell Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hard to be sure from your screenshot, but I think dates are arriving as utc format strings. If true, then try this formula:
Text(DateValue(start), "[$-en-US]yyyy-mmm-dd")
This takes the Google string, parses it with DateValue to turn it into a DateTime type, then uses Text to format that DateTime as desired.

Was this reply helpful? Yes No
Amf 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much Mr Andy, it worked perfectly! Learned I new thing today. You have a great day ahead.

Was this reply helpful? Yes No