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!
Solved! Go to 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.
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
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.
it helped a lot thanks!
User | Count |
---|---|
262 | |
110 | |
98 | |
54 | |
39 |