web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How do I get a date fi...
Power Apps
Answered

How do I get a date field from a sharepoint list into a gallery?

(0) ShareShare
ReportReport
Posted on by 14

Hello,

I'm working with a Sharepoint list in which there are colums in which a date is stored. Now I want to create a PDF in my PowerApp for each project that is saved in Sharepoint. To do this, I use the collect() function to save the data in a table and then save it in a gallery. For text field, I can just use 'DataCardValue.Text'; for dropdowns I use 'DataCardValue.Selected.Value'. But I can't get the date into the table. How can I do that?

Categories:
I have the same question (0)
  • Verified answer
    AndrewR1 Profile Picture
    1,572 Moderator on at

    Hi @stine2308 to get the selected date out of the data card value you would use this: 

    DataCardValue.SelectedDate

    Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

    If the content was useful in other ways, please consider giving it Thumbs Up. 👍

    Thanks
    Andrew

  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @stine2308 It should be ControlName.SelectedDate

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution 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 Thumbs up.👍

    Thanks,
    ANB


  • stine2308 Profile Picture
    14 on at

    Collect(Tabelle;{name: "Order date target"; name2:DataCardValue39_1.SelectedDate})

     

    If I do it like this, it underlines the line in red and says: incompatible type. The collection cannot contain values of this type

  • AndrewR1 Profile Picture
    1,572 Moderator on at

    @stine2308 Are you setting the values anywhere else try renaming this field as it seems like you are trying to put a date datatype in a field that has already got a set datatype?  

     

    Thanks 

    Andrew

  • stine2308 Profile Picture
    14 on at

    @AndrewR1 I'm using a form that displays the current project. I don't do anything with the data that comes from Sharepoint, I just want to insert it into a gallery so that I can create a PDF from it.

     

  • AndrewR1 Profile Picture
    1,572 Moderator on at

    @stine2308 

    Here is my working example: 

    AndrewR1_0-1698147516773.png

    I used a form with a Item of the current Movie and then have a button doing this on select I'm not sure what else I can help you with as I cannot replicate this issue! 

     

    Thanks 

    Andrew

  • stine2308 Profile Picture
    14 on at

    The Problem was another one: I wanted to save the Date in the same column as text

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#2
11manish Profile Picture

11manish 192

#3
Valantis Profile Picture

Valantis 128

Last 30 days Overall leaderboard