I am quite new in using PowerApps, I am struggling to create simple Lookup function to search Travel Destination picked by user in Dropdown and then look it up in my table and return appropriate value to it. Values in Dropdowns are inputted from Excel Table.
This is what I have in DropDown value 'TravelValue' - Source is the table, 'Travel_to' column in the table with values for dropdown.
This is the lookup that I have in text input box where I want the value to appear - TravelValue is the value from DropDown, 'Less Than 3 Days' is the columns with the value I would like to return.
If possible, I would like to create Key from above field combining with another, however I am getting an error using second 'OriginValue'