when trying to gather a collection inside a gallery each additional row is keeping hidden data from the previous

[scottmcnitt]

I have some Fill validations on text fields that if blank the fill is yellow, when i fill out the first row inside the gallery and hit the plus to get the next row the fields are blank but the fill is not working.  i have toggled the clear option and can go into the new row and type and clear it then it turns yellow.  what is causing this inside the gallery?

[subsguts]

Your Fill property needs to be changed from : If(IsBlank(TextInputPurchase.Text), Yellow, RGBA(255,255,255,1))

 to: If(IsBlank(ThisItem.Title), Yellow, RGBA(255,255,255,1))

[scottmcnitt]

OMG finally that did it!!!!!!  Thank you ending this nightmare.  

[subsguts]

Glad to help.

Don't forget though, you need more than just TItle in that collection.  Every field in that Gallery needs to be represented this same way.  The only exception of course is your ID, or any information the user is not going to enter, but you want to store with the data to make that 1 to many connection between the data at the top of your app and the multiple lines of data that can be added into your gallery.

That way when you are ready to Patch what is entered in the Gallery back to the data source you'll be able to use the collection to do that.  If you have problems with getting that to work please post a new question here and I'm sure myself or someone else will be glad to assist.

I'm glad this nightmare is over 🙂

[scottmcnitt]

This one is going to be tricky... I have a dropdown for vendor and one of the entries on the dropdown is "Add New Vendor" which makes visible a textbox to add a new vendor.  And if one of the vendors is selected instead then that is used for the hidden vendor field.  The hidden vendor field is the one i want to use in the patch.  so how can i do ThisItem.Vendor for the Default.  This is currently what the default is:

If(DropdownVendor.Selected.Value = "Add New Vendor",
"",
DropdownVendor.Selected.Value
)

[scottmcnitt]

Nightmare has returned.  With all of this i just noticed that the items are staying yellow after i put text in the field.  so now a reverse effect.

[subsguts]

As long as "Add New Vendor" is the first item in your dropdown you can set the Default property of the dropdown to be Text(ThisItem.Vendor), so that it will select whatever is loaded into the Vendor field in the collection.  If ThisItem.Vendor has a value the user entered (it will not be in the dropdown), it will default to the first item in the dropdown and display the hidden text box, whose default should be set to ThisItem.Vendor.

If the user choses an existing vendor, you'll want to still store this into the hidden textbox so that it gets stored with the Patch.

There may be a more elegant way to do this.  It would be best to open each issue as a separate one in the community because then others, smarter than me, can assist as well.  Since we are already involved in this they won't just in because they see this as already in progres.  Hope this makes sense.

So hope this helps on the dropdown issue, but I would repost if not and explain this specific issue in great detail about a dropdown in a gallery, where it has a hidden field, etc.

There are other ways to do this including potentially having 2 fields in the collection, one for the value selected from the combo and another for the entry of the user.  This may be simpler, but you'll need to store both in your collection and data source.  The above is trying to make it work with only one field.

[subsguts]

I'm afraid the problem is that ThisItem.<field> is going to have what is in collection (aka the datasource).  Therefore, I can only imagine the way to affect the color change you are looking for is to Patch the collection within the OnChange event of each field.  This is sort of a pain, but it's really the only way I can think of making this work.  I've researched this to and not found anything else.

Remember when you are using a gallery, it has to have a way of knowing which row you are on.  That's why ThisItem works and referening the TextBox doesn't because the Gallery doesn't know which text box you are referring to.

However, if you want to explore a way to do this without Patching in the OnChange, again, I think this is an excellent topic to let others consider.  Just post it as "How to dynamically change the color of items in a Gallery", then explain what you want to do and see if someone comes up with something different from the Patch in the OnChange property.  

Make sure you indicate you are "Loading information into a Gallery from a collection and that you want to change the colors of the items in each row of the gallery if the user changes the value of it" or something like that.

I'm hopeful, someone else has a different solution, but I think patching the collection during the OnChange event is going to be the only way. 

Hope this helps.