cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Data not transferring to excel

Everything is transfering exept for the date.  The excel cell is simply blank.

 

If make the DataField into "Activation_Date" instead of Activation_Date, then I get the error in the red bar.

 

How can I fix this?

 

error.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi @Anonymous

 

I suppose you are not using Submit(Form), otherwise it will not have such problems as Submit (Form) is built-in function.

But if you are using Patch(), so as @AndyPennell mentioned, use Text to convert into a string.

 

Text(DatePicker.SelectedDate, "dd mmm, yyyy") will do.

 

This tutorial helps.

https://powerapps.microsoft.com/en-us/tutorials/function-text/

 

Hope this helps.

TQ

hpkeong

View solution in original post

7 REPLIES 7
Highlighted
Power Apps
Power Apps

The error says it is expecting a string, so I would use the Text function to convert the date into a string before pushing to Excel.

Highlighted
Anonymous
Not applicable

Where would the Text function be inserted?  Into the Update field?

Highlighted

Hi @Anonymous

 

I suppose you are not using Submit(Form), otherwise it will not have such problems as Submit (Form) is built-in function.

But if you are using Patch(), so as @AndyPennell mentioned, use Text to convert into a string.

 

Text(DatePicker.SelectedDate, "dd mmm, yyyy") will do.

 

This tutorial helps.

https://powerapps.microsoft.com/en-us/tutorials/function-text/

 

Hope this helps.

TQ

hpkeong

View solution in original post

Highlighted
Anonymous
Not applicable

I was using the Sumbit(form).  Oddly, the form had two tiles titled the same so I just turned on the second one for the date and it works.

Helper I
Helper I

I have tried this posted solution, but my data is still not writing to Excel.  The posted solution is not clear exactly which property this solution is supposed to be added.

 

Is the Text(DatePicker.SelectedDate, "dd mmm, yyyy" solution supposed to be added to the DatePicker, to the Gallery, to the OnSelect property or something else?  If it's to be to the DatePicker, there is no "Text" property to the DatePicker.

 

I am using the Patch function on a custom gallery to get my data to write to Excel.

 

Please help!  I have tried so many things and nothing is helping.  I get the same error message as this user.

 

 

 

 

Highlighted
Anonymous
Not applicable

Here's what I did.

 

1.) Make sure there's only 1 field active. (My for some reason has two "Activation" showing)  

2.) Activate the field card and delete the input field in it

3.) With the card selected, click Insert > Controls > Date Picker

4.) Change the "Update" field of the card to DatePicker#.SelectedDate

 

 

This works for me and is now putting in the Date into my Excel file. 

Highlighted

I tried your suggestion. It is still not writing to Excel.  The example of the pic posted is not from me.  It's from another user, but I am having the same problem.

 

Update:  This actually worked!  I put the coding in the wrong area.  I tried it this morning, and it worked.  Happy days!

 

Thank you.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,733)