How to change the date format when patching SP

[PerKou]

Hi all!

I want to patch a "date & time" column on SharePoint and Date: Now() is working OK on the app, pathing SharePoint with the value eg: 09/24/2021

Patch(Transactions,

Defaults(Transactions),

{

Title: Gallery1.Selected.Title,

Date: Now()

}

)

but what if I want to change the format of the date on how it is patched on SP? If I use Text( Now(),"[$-en-US]dd/mm/yyyy hh:mm"), it gives me an error that this is text while SP waits for date type.

Ideally I would want to store it on SP like DD/MM/YYY hh:mm

Any idea? 

Thank you! 

[C-Papa]

Hi , nothing you do it PowerApps will fix this, its the way your SharePoint site is configured. have a look at the below article which should help you out

How to change date format in SharePoint - SharePoint Maven

[v-qiaqi-msft · Accepted solution]

Hi @PerKou,

Have you solved you problem?

Do you want to format your date time as "DD/MM/YYY hh:mm" and save it to your "date & time" column on SharePoint?

Could you please tell me that if your date and time column allows time?

1). Make sure that your Date and time column includes time:

2). Modify your formula as below:

Patch(Transactions,
Defaults(Transactions),
{
Title: Gallery1.Selected.Title,
Date: Now()
}
)

Check if this could help you at some degree.

[PerKou]

it helped a lot thanks!