web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Date format

(0) ShareShare
ReportReport
Posted on by
How do I format the date from a from survey123 when using power automate to create or update an excel file in one drive
Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,504 Moderator on at
    @PW-14011855-0 To format a date—you'll need to use an expression and the formatDateTime() function. It's hard to offer any recommendations without seeing your full flow and the logic behind it. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.
     
    In the meantime, you might be interested in this YT Tutorial:
     
     
    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.
     
    Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.
     
    IN THIS VIDEO:
    ✓ 4 Date Functions You Need to Know
    ✓ How to use the Convert Time Zone Action
    ✓ How to Get a Future Date
    ✓ How to Get a Past Date
    ✓ How to Return SharePoint Items Due in a Number of Days
    ✓ How to Return SharePoint Items Due within a Date Range
    ✓ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
    ✓ How to Calculate the Number of Days between Two Dates
    ✓ How to Check for a Birthdate and Anniversary Date
    ✓ How to work with Dates and Times in Excel
    ✓ How to use a Manual Trigger with Date Input
    ✓ How to Output Dynamic Text with an Expression
    ✓ How to Check if a Date Falls on a Weekend
     
     
    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 173 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 95 Super User 2026 Season 1

Last 30 days Overall leaderboard