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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Date format

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Situation :-

In my environment we have a web excel sheet where we are putting data(manually entering) and after that a power automate flow will trigger and it will fetch the data from excel(web) and put that data into share point.

 

Issue :- we have fixed date format like it is English India date(DD/MM/YYYY), before or till date 12 whenever we are putting data in excel after triggering flow, in share point it is taking DD/MM/YYYY and 00:00:00 even though i have fixed the date format in share point also(only date not include time) , after 12 there is no issue in excel or share point like it is taking only date not the 00:00:00. 2023-06-20 11_50_33-BBT_data_drop.xlsx.png2023-06-20 09_15_16-Bibliotheca Alerts_Hub - List_New_Relic - All Items.png

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Anonymous  what is the data type of column in SharePoint, is it a Date column or Text Column, if its date column does it include time?

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 481

#2
11manish Profile Picture

11manish 278

#3
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

Last 30 days Overall leaderboard