Form controle isn't showing data from Sharepoint List

(0) Share

Report

Posted on by RvdHeijden

602

Hey Guys,

I have a SP list with a DateTime column and a few Dropdown columns

But in my form it does show the date but not the time (hrs/minutes)

Edit: I solved it by deleting the fields and adding them again and giving them as Default property the formula

Text(Hour(varCurrentEvent.StartDateTime);"00") and Text(Minute(varCurrentEvent.StartDateTime);"00")

and the dropdownmenu's aren't showing any data.

When I click on them they are showing the choices but not the choices for that specific record

Propterties for the Choice columns

Default = empty

Items Category = Choices([@'Planning 2025 S&B'].Categorie)

Items Ploeg = Choices([@'Planning 2025 S&B'].Ploeg)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Giraldoj 793 Super User 2025 Season 2 on at

Like (0)

Report

Hi there,

What is you datasource it looks like a format problem because by default Forms can deal with DateTime columns, look at this example i have created a sharepoint site with a datetime column and i dont have to do anything fancy to get the time

you will need to provide more detaill about your table or data sources to give you a hand on how to display the times properly.

Regards.

Was this reply helpful? Yes No
Verified answer

Gabriel G. 831 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

When you use a form, the 'Default' property of DataCardValue on each field refer to the value of the current record. So, you need to use probably 'Parent.Default' on 'Value' of your choices control. And you need to make sure you have the correct field in 'Default' property of DataCard (ThisItem.Ploeg and ThisItem.Categorie in your case) of each of your fields inside the Form.

For your date fields, it seems you need to make sure you have the same format in your list and in your form ("dd-mm-yyyy HH:mm"). If you have it, verify your time controls in your form to make sure you get the right value.

I hope it helps!

____________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No