cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mikecopp
Level: Powered On

Submit date as text string to excel table?

Does anyone know how i can submit the current now() time to an excel table as string of text from a form? I am having an issue in my app when doing a lookup against the values selected from a dropdown which are text. I am getting an error that states left is date and right is text. Basically i have one app that a user clicks a button which submits their logged in name, gps coord's and the now() time, all which are labels.  I have another app with a map that displays their location based on the dropdown selection of their name and the checked in dates. The name drop down filters all records with the users name which populates the date dropdown with the checked in dates. Once the date is selected, it will lookup that record and then gps coords from that record will display a pin on the map.   

 

I tried formating the now() label in the check in app using Text( Now(), "[$-en-US]mm/dd/yyyy hh:mm:ss" ) which seems to only format it in the app and not the update of the record in the excel table.  If i set the date column in the excel table to "General"  it gives me a number value for the date instead.  Hopefully that makes sense? 

1 ACCEPTED SOLUTION

Accepted Solutions
mikecopp
Level: Powered On

Re: Submit date as text string to excel table?

I figured it out by setting the left side of my date lookup to:  text(columname)=dropdown1.selected.value so that it was comparing text to text.   

4 REPLIES 4
Community Support Team
Community Support Team

Re: Submit date as text string to excel table?

Hi @mikecopp,

 

I think your requirement cannot be achieved so far. No matter how you format the Now() to Excel table, as long as the column in excel table is data type, it will always be date format in excel. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mikecopp
Level: Powered On

Re: Submit date as text string to excel table?

Ok thanks for the reply. I will try to think of another way that i can lookup the specific record by the date. I do have it working by making the excel column a date format mm/dd/yyyy hh:mm but then it formats the drop down like this 2017-11-27T07:24:00Z and it works when it is like that. The dropdown then randomly switches itself back to a mm/dd/yyyy hh:mm:ss format and breaks the app. 

mikecopp
Level: Powered On

Re: Submit date as text string to excel table?

Do you know of a way to format the data items pulled into a dropdown box as date format? 

mikecopp
Level: Powered On

Re: Submit date as text string to excel table?

I figured it out by setting the left side of my date lookup to:  text(columname)=dropdown1.selected.value so that it was comparing text to text.   

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 55 members 4,289 guests
Please welcome our newest community members: