Date Picker issue patching and resetting gallery

[Alderney]

Hello

I have two screens, one is where you start to type in a name and suggestions are populated in the drop down box.  After choosing the one you want, "Go" navigates to the second screen with the details in a gallery of the information for the name chosen.

As shown here in screen shot

This is all working how I want it to.  However, when I go to the second screen and use the date picker, firstly it doesn't patch to my sharepoint list, though the tick box does and when you change the date, the information and name changes on the gallery, and I get a "title required" error code when I go out of the trial using the play button.  If I put a space in the coding and then remove it the error goes away?! (not in original when I add the coding either, only after I have trialled the app)

As per screenshot

I have used the date picker function on another app without any problems, and this one has the same coding.  I added a save button to see if any different, same result.

Anyone have any ideas what's happening and why?

Thanks

[WarrenBelz]

@AsanKani ,

A bit more delving - I have never done it before, but in the "classic experience" in SharePoint apps, you can create a Contacts App and synchronise this with Outlook, however I created one and two things happened - I had a Title column, but the list was not visible to Power Apps, either Canvas or Integrated (the latter did not have an option to create). Like a few other "legacy" SharePoint facilities, it was around a long time before Power Apps and did not make the integration roadmap . . .

[AJ_Z]

Just checking have you already tried:

Patch('NZ Schools Contacts', Defaults('NZ Schools Contacts'),{Title:"","Date Visited":DatePicker1.SelectedDate})

[Alderney]

@AsanKaniand @WarrenBelz 

I changed the last name column to Title which enabled me to patch the date, however on selection of the date it patches a new list item not patched to the list item in sharepoint already. It also still resets itself to the first named details on the drop down box.  I have set a search box which you start typing in the name and the names appear in alphabetical order in the dropdown box, selection is then made which opens up the details.  On this screen the date picker is.  Rather annoying issue, as you would have to go back to the original screen to go back into the one you're wanting with all the information.

so...one issue fixed hooray...

[WarrenBelz]

@Alderney ,

Is that a drop-down or combo box? The latter has the nasty habit of resetting to its DefaultSelectedItems when the screen is loaded, which may explain your issue. 

The SharePoint format depends on your site Regional Settings - I am surprised dd/mm/yyyy" - is not the Default . .

What are the Items of the combo box ? There is a method of displaying text with a date in a second column not displayed, but then choosing the date selected.

[Alderney]

Hi Warren

I managed to change the regional settings so I could change the date.  It is a dropdown box not a combo one. So I am able to patch now but it creates a new list item not adding to the one selected, and still resetting. (Would the dropdown box in this instance perhaps the same issue as the combo?  in which case how do I change that setting?)

Screenshot of the dropdown settings

[WarrenBelz]

HI @Alderney ,

Firstly, if it is resetting, then set a Variable to the item chosen OnChange of the drop-down, then make the Default this Variable.

As well you code Defaults(ListName) will create a new record - I assume that is what you wanted to do. If you want to update an existing record, you need the ID of that record - in the example below, it is selected from a gallery (if you have done this)

Patch(
   'NZ Schools Contacts', 
   {ID: YourGalleryName.Selected.ID},
   {'Date Visited': DatePicker1.SelectedDate}
)

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.

Visit my blog Practical Power Apps

[Alderney]

@WarrenBelzI'm wanting to update an existing record.  when I add the Id, it still asks for title, and it won't patch. when I add title part, it won't patch either, so seems only to patch new record at this point, with only the title part.

I'm not too familiar with variables, i'm not sure what i would put as default

[WarrenBelz]

@Alderney ,

I think we need to take a step back now I understand your relative experience with some of the concepts here. Firstly, how do you identify the record you want to Patch? I was assuming you selected it from a Gallery, but I do not see one in your screen shot of the tree. Also I did not know where you were with the Title field (you can make it non-compulsory so you do not have to Patch it). ID was two capital letters, so, does this work ?

Patch(
   'NZ Schools Contacts', 
   {ID: YourGalleryName.Selected.ID},
   {
      Title: " ",
      'Date Visited': DatePicker1.SelectedDate
   }
)

As for the Variable - what is the Items of the drop-down ?

[Alderney]

@WarrenBelzI used your recommended patch and got the following error message

I agree I need to tell it where to patch to, my thoughts would be to the Full Name as given in the SP column that matches one of the populated input boxes as well as the drop down selection.  I tried that, pointing to an input box in the gallery, however, it would only patch a new record in the SP list, not to the existing SP record in the SP list, (if that makes sense). If I point it to the dropdown selection I get an error. would I need to use In function to get what I want?

The items of my dropdown are:

Thanks for your help Warren it is much appreciated

[WarrenBelz]

@Alderney ,

What is the Items of the gallery ? It needs to contain the ID for this to work that way. Otherwise, you could go down the track of this assuming 'Full Name' is a unique field.

UpdateIf(
   'NZ Schools Contacts', 
   'Full Name' = YourNameControlOutput,
   {
      Title: " ",
      'Date Visited': DatePicker1.SelectedDate
   }
)

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.

Visit my blog Practical Power Apps