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
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue when collecting ...
Power Apps
Answered

Issue when collecting dates from an excel datasource

(1) ShareShare
ReportReport
Posted on by cfoenki 100

Hi all,

 

I'm struggling with an issue with my collections.

I have 2 collections I would like to merge (1 collection data after the other).

I found the correct code to do this but there is an issue with my dates columns. Somehow, the collection of the 2 excel tables does not retrieve the same date/time format which makes the merged collection impossible.

 

In the collection 1 the date/time format is: YYYY-MM-DDTHH:MM:SSZ

In the collection 2 the date/time format is: DD/MM/YYYY HH:MM

 

I don't know why it is different as in my excel source file the 2 tables columns have the same data type.

How could I fix this?

Is it possible to set a date/time format when collecting data?

I don't really need the time here, is there any way to collect only the date?

 

Thank you so much for your help.

 

 

 

2020-12-22_10h55_28.png
2020-12-22_10h56_38.png
Categories:
Building Power Apps
I have the same question (0)
  • poweractivate Profile Picture
    poweractivate 11,078 Most Valuable Professional on at

    @cfoenki 

     

    Check if similar thread here works for you to adapt to your case:

     

    How do I get my dataform to display dates in DD/MM/YYYY format?

     

    To be more exact, from a Formula in the Power Apps Canvas App, you can use a Text function and a Format argument like this:

     

     https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times

     

    and 

     

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

     

    The Text function formats a number or a date/time value based on one of these types of arguments:

    • A predefined date/time format, which you specify by using the DateTimeFormat enumeration. For dates and times, this approach is preferred as it automatically adjusts to each user's language and region.
    • A custom format, which comprises a string of placeholders that define, for example, whether numbers show a decimal separator and dates show the full name of the month, the month as an abbreviation, or the month as a number. Power Apps supports a subset of the placeholders that Microsoft Excel does. In this string, the language placeholder specifies the language in which to interpret the other placeholders. If the custom format includes a period, for example, the language-format placeholder specifies whether the period is a decimal separator (ja-JP) or a thousands separator (es-ES).
    ...

    Text( NumberOrDateTime, DateTimeFormatEnum [, ResultLanguageTag ] )

    • NumberOrDateTime - Required. The number or the date/time value to format.
    • DateTimeFormat - Required. A member of the DateTimeFormat enumeration.
    • ResultLanguageTag - Optional. The language tag to use for the result text. By default, the language of the current user is used.

    or

     

    Text( NumberOrDateTime, CustomFormat [, ResultLanguageTag ] )

    • Number - Required. The number or the date/time value to format.
    • CustomFormat - Required. One or more placeholders enclosed in double quotation marks.
    • ResultLanguageTag - Optional. The language tag to use for the result text. By default, the language of the current user is used.

     

     

     

    Check if above helps @cfoenki 

  • cfoenki Profile Picture
    cfoenki 100 on at

    Thank you for the quick answer.

    I'm not sure how I can use the Text function inside the collect function.

    Can you help?

     

    Here is my collection code (simplified):

    ClearCollect(CAPA_Collection4;
 ShowColumns(CAPA_Collection; "Deviation_Reference";"CAPA_Plan_Reference";"CAPA_Plan_Creation_Date";
 ShowColumns(CAPA_Collection2; "Deviation_Reference";"CAPA_Plan_Reference";"CAPA_Plan_Creation_Date")
)
  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 155,585 Most Valuable Professional on at

    Hi @cfoenki ,

    I cannot test this and you will need to duplicate this for the other collection, but this may allow both date/time fields to present identically. Note that the field name will be changed.

    ClearCollect(
 CAPA_Collection;
 DropColumns(
 ShowColumns(
 AddColumns(
 YourFirstTableName;
 "CAPAPlanCreationDate"
 DateTimeValue(
 Text(
 CAPA_Plan_Creation_Date;
 ShortDateTime
 )
 )
 ); 
 "Deviation_Reference";
 "CAPA_Plan_Reference";
 "CAPAPlanCreationDate"
 );
 CAPA_Plan_Creation_Date
 )
)

     

    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.

  • WarrenBelz Profile Picture
    WarrenBelz 155,585 Most Valuable Professional on at

    Hi @cfoenki ,

    Just checking if you got the result you were looking for on this thread. Happy to help further if not.

    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.

  • funkyfoenky Profile Picture
    funkyfoenky 16 on at

    @WarrenBelz 

    Sorry, with christmas celebrations I didn't have time to test your solution. I will check on Monday and let you know.

    Thanks!

    Note: it's cfoenki, don't know why my login changed ^^

  • WarrenBelz Profile Picture
    WarrenBelz 155,585 Most Valuable Professional on at

    OK @funkyfoenky or @cfoenki ,

    I will respond to either on this thread if required.

  • cfoenki Profile Picture
    cfoenki 100 on at

    @WarrenBelz  Sorry for the late reply.

    I just tested your solution and it works, thank you so much! 🙂

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
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 404

#2
timl Profile Picture

timl 344 Super User 2026 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

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