Data not transferring to excel

[Anonymous]

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?

[AndyPennell]

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.

[Anonymous]

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

[hpkeong · Accepted solution]

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

[Anonymous]

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.

[valuehr]

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.

[Anonymous]

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. 

[valuehr]

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.