Date Field in Canvas App will not show Correct Value on Edit Screen

[melissahillGS]

New user here, be gentle 🙂

I'm collecting data in an external Form, which I pass to a Sharepoint List via Power Automate.

I have a field called Birthdate which is populating my list with M/D/YYYY values.  

In PowerApps, I have a gallery on one side of the canvas, and an Edit Screen on the other.  Although I can get the correct Birthdate to show in the gallery, the Edit Screen will only show the default date.  

What can I do to bring in the Birthdate value from the Selected Item?

[WarrenBelz · Accepted solution]

Hi @melissahillGS ,

I have it now - I have done a small test app and a test MS Form with a date in it and now know what the issue is (and have struck this before). All output from Forms other than the submission date is Text - I had the same issue with Yes/No fields.

When I tried to point the MS Forms output at the SharePoint date field, the only item it gave me was the submission date.

So what you have now is some text output that has to go into SharePoint in a Text field. Once you have it there, you can use DateValue (have a read of this article) to get it into a date. Probably the easiest way would be to make the default of the date picker DateValue(<TextDateField>) then reset it to populate for further editing in PowerApps/SharePoint. Your could also do something in the Flow.

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[eka24]

Put this in the DateofBirth

If(Form1.Mode=FormMode.Edit,Parent.Default)

or

If(Bank_frm.Mode=FormMode.Edit,Parent.Default,Now())

[melissahillGS]

@WarrenBelz   This is it!   Thank you so much, it's working now.  

[heres2u]

I know that if you create an inventory app from a list which has a date... the edit form date-picker field will have a default setting (under: Advanced > InputTextPlaceholder) such as:

  
If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))

With that code, if you want to edit an existing date, the edit form will display the default date (12/31/2001).   So what I do is edit the update form field for date-picker (under: Advanced > InputTextPlaceholder) to be:

If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language),(Parent.Default))

Note : I add ",(Parent.Default)" before the closing parenthesis.   

In natural language that would read something like: "If the date field is blank in the Sharepoint list, display the default text of 12/21/2001 for the date-picker field,  else if there is data in the Sharepoint list for the date field, display that date instead.