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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Collection Date field ...
Power Apps
Answered

Collection Date field to Text

(0) ShareShare
ReportReport
Posted on by Charl 28

Hi

 

Hope you all doing well. I just can't seem to find a solution for the following:

 

I have a collection of a SharePoint list that returns two dates..From and To

I want to display this is a LABEL control as follows: 

Charl_0-1716817522988.png

 

So I build the collection as follows - App OnStart

Charl_1-1716817669355.png

Then I set the variables in the OnVisible method of the form.

 

Charl_2-1716817821739.png

 

So now my thinking is I can use the context variable were I want in a label or ext...

 

Charl_3-1716817959235.png

 

I am missnig something here ... Your help will be much appreciated.

 

Regards

Charl

 

 

 

Categories:
Building Power Apps
I have the same question (0)
  • mmbr1606 Profile Picture
    mmbr1606 14,629 Super User 2026 Season 1 on at

    hey @Charl 

     

    please copy paste your code here so we do not need to retype, thanks

  • Verified answer
    Prabhakar_S Profile Picture
    Prabhakar_S 735 Moderator on at

    Hi @Charl ,

     

    In your case, While assigning a Variable colMonthlyDates.From to the vcolfrom this would refer to the entire collection, not a specific record's From field, Instead if you use First(colMonthlyDates).From it refers to the From field of the first record in the collection.

    Try this,

     

    Set(
        vcolfrom,
        First(colMonthlyDates).From
    );
    Set(
        vcolto,
        First(colMonthlyDates).To
    );

     

    then you can use variable on a label with the same,

     

    Text(vcolfrom & "-" & vcolto)

     

    Thanks!!!

     

    Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

  • Charl Profile Picture
    Charl 28 on at

    Thanks much appreciated.

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

News and Announcements

Welcome to the Power Platform Communities

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 324 Most Valuable Professional

#2
11manish Profile Picture

11manish 193

#3
Valantis Profile Picture

Valantis 138

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans