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!
