
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.
@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?