cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Cross reference to gallery text box from data table

@david9068

 

Just to confirm that I understood correct-

You want the user to search from a list of part numbers. For example, if the the user enters ST1 as the input, a list of part numbers that have "ST1" in it should be displayed as a list and then the user can select from this.

 

If the above is correct, you will need a combo box control instead of a text-input.

 

If you can confirm , I can then test it out and help you in setting it up.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

david9068
Level: Powered On

Re: Cross reference to gallery text box from data table

@ThatAPIGuy 

 

Yes correct. After the user searches a part number it queries another table and returns the details of that part number and equivalent part number. I want the equivalent part number to then query the second gallery the same as the first search box does. 

 

I just had a look at the combo box there and it seems to be what i want. I assume its just the same search function but instead of pointing to the textbox its the combo box. 

 

Just to clarify there are two galleries in this app. 

 

combo box.png

Super User
Super User

Re: Cross reference to gallery text box from data table

@david9068

 

i tested it out like this -

 

I created a label with the part numbers separated by ", " . (similar to your equivalent part)

I then added a combo-box and set its Items property to Split(Label3.Text,", ")

2018-02-22 09_32_23-PowerApps.png2018-02-22 09_33_02-PTS DCS test - Saved (Unpublished) - PowerApps.png

 2018-02-22 09_33_17-PTS DCS test - Saved (Unpublished) - PowerApps.png2018-02-22 09_33_39-PTS DCS test - Saved (Unpublished) - PowerApps.png

 

In your case, you can then set your gallery 2 Items property to Filter(DataSource, PartNumber = Combobox1.Selected.Result)

 

Hope this helps!

Note: Set the combo box "Allow multiple selections" to Off


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

david9068
Level: Powered On

Re: Cross reference to gallery text box from data table

@ThatAPIGuy

 

Thanks for all your help. That is now working for me.

 

Regards,

David

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,773)