Hi All ,
I have used a blank gallery with some inputs , whose values are stored in a collection. I want to create multiple records to add so i' using patch and collect but the drop down values are getting reflected back to 100 , i'd Like it to be set to blank.
Here are some screenshots to better understand my issue , please check the below ones to check the formula's i've used.
The dropdown contains items from a sharepoint column , the text fields are just lookup values and the other 2 are textinput fields.
Everytime i hit the "save" button , i want it to create a row(record in the collection) which is working , but the values are repeating and i'd want it to be blank or with no selection so the user can select it. Also , everytime i try to add a record using the save button , the existing values get changed to 100.
Case Scenario : I select "759" in the dropdown , and hit Save. But the gallery adds a new record while resetting both dropdown to "100".
I think the issue is in the dependencies part , check the 2nd image. I'm not sure how to solve this , gladly appreciate any help! Thanks!



