Answered

Defaults() for SharePoint list does not return anything for DateTime field if it is set to "Today's date"

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I hope this is the right place to report bugs, if not, let me know where to go, but as the title says, Defaults() is broken.

As this other topic also shows, it's broken in more than one way, but it is acutely broken when referencing a "Date and time" type field where the default value is set to "Today's date" - it is simply not returned whatsoever. Put a "Date and time" field in a SharePoint list, set it to a Default value of "Today's date", and it will not show up even if it's explicitly referenced by Defaults('List').Field. It does work with a fixed date.

I suspect, but I am not willing to test, that this will probably affect default values which are similarly dynamic, i.e. calculated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

When saying Defaults() not return anything for DateTime, where did you put todays date? is it Date Picker

Please explain more how do you save the data etc. screenshot will be helpful

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please refer to below doc:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-defaults

Note: Data sources vary in how much default information they provide, including not providing any at all. When you work with a collection or another data source that doesn't support default values, the Defaults function will return an empty record.

Apparently Date and time column default value is not supported to be retrieved into PowerApps. But I'm more wondering why you want to get the default value that in a SP list? In the doc you could see Defaults() basically use along with Patch function.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No