Going crazy! Getting an odd error when updating a collection item from a gallery.

[AndrewValenzuel]

To learn how to edit an item in a collection that is stored in a gallery I followed this video:  https://www.youtube.com/watch?v=yS6mTRlmuls

On a simple collection/gallery that I've created from new I was able to get this demo to work, easy.

On my own collection with 7 columns I am unable to get this to work.  I've even tried to just update a single column, the title.  But I keep getting an odd error:  The specified Column "NextArrow2" does not exist.  

To clarify "NextArrow2" is not a column name in the collection, it is however the name of the pencil icon in the attached photo.  And the error message changes each time I remove an icon or label.  For instance it will say "The column Label2_1 does not exist."  

The code for the button is:  Patch(TicketsCollection, BrowseGallery2.Selected, {Column Name 1: TextInput1.Text, Column Name 2: TextInput2.Text,....

Does anyone know what is going on here?

[v-xida-msft · Accepted solution]

Hi @AndrewValenzuel ,

Based on the issue that you mentioned, I think this issue is related to the BrowseGallery2.Selected formula. The result the BrowseGallery2.Selected returned is not just the record in your TicketsCollection, but also the "Remove" Icon and "Pencil" Icon properties.

As an alternative solution, please consider modify your Patch formula as below:

Patch(
       TicketsCollection, 
       LookUp(TicketsCollection, PrimaryColumn = BrowseGallery2.Selected.PrimaryColumn), 
       {
         Title: NewTitle1.Text
       }
)

Note: You could consider add a Row Index column (e.g. 1, 2, 3, 4, ...) in your TicketsCollection.

or

UpdateIf(
       TicketsCollection, 
       PrimaryColumn = BrowseGallery2.Selected.PrimaryColumn, 
       {
         Title: NewTitle1.Text
       }
)

Note: The PrimaryColumn represents the column in your TicketsCollection, which could identify one record uniquely.

Best regards,

[AndrewValenzuel]

I'll give it a shot, thank you.

[v-xida-msft]

Hi @AndrewValenzuel ,

Have you solved your problem?

Is the solution I provided above helpful in your scenario?

If the solution I provided above is helpful, and you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

[v-xida-msft]

Hi @AndrewValenzuel ,

Have you solved your problem?

If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread as Solved.

Best regards,