Powerapps - Change gallery source and patch destination

0
votes

I'm about to go mad about an issue in Powerapp.

I'm making an app, which will be used to count inventory in different locations.

I'm using a gallery to show the data from my Excel spreadsheet, and it works fine, if I choose the locations in the gallery settings menu.

However, I would like the text input field in the gallery to show the current value, from the location which I enter in the top text input field. I would also like to have the correct column PATCH when I press the arrow.

Does anybody know how I can make it happen?

Thanks in advance!

enter image description here

enter image description here

enter image description here

1
gallerypatchpowerappspowerapps-formula

1 Answers

0
votes

To display the column based on the input box text, set the 'Default' formula of the gallery input boxes to be: 

If(TextInput.Text = "Loc21", Loc21, TextInput.Text = "Loc22", Loc22, TextInput.Text = "Loc23", Loc23, TextInput.Text = "Loc24", Loc24, TextInput.Text = "Loc25", Loc25, TextInput.Text = "Loc26", Loc26)