cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok
Memorable Member
Memorable Member

Can I change "Created at" date format of Twitter Connector to the format handled by Power BI/Excel ?

I want to use "Created at" field of Twitter Connector by Power BI/Excel.

 

Current "Created at" is like "Sat Apr 30 05:59:32 +0000 2016".

and I convert this string to "Apr 30 2016 05:59:32 +0000" by Power BI's query,
and I convert data type from string to date/time/zone,

and I creat the reports.

 

Can I change "Created at" format to "MMM dd yy hh:mm:ss +0000" format at Twitter Connector ?

 

Regards,
Yoshihiro Kawabata

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Stephen
Power Automate
Power Automate

Today we don't have any functions that allow you to easily change the format of a timestamp. I have asked the team to follow up on why the Twitter connector uses a differnt style of timestamp -- ideally it would just used the standard ISO datetime format.

View solution in original post

2 REPLIES 2
Stephen
Power Automate
Power Automate

Today we don't have any functions that allow you to easily change the format of a timestamp. I have asked the team to follow up on why the Twitter connector uses a differnt style of timestamp -- ideally it would just used the standard ISO datetime format.

View solution in original post

Thank you, Stephen for your reply, and asking the team.

 

Yes, I want the standard ISO datetime format.

 

Regards,
Yoshihiro Kawabata

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,271)