Hello
I have a list in Sharepoint with some colunms. The Colunm with value 1 is in a dropdown and I want to bring the information from Colunm with value 2 in a label. This will be a clickable link. Im using this formula in OnChange of Dropdown to try set my var HTML with the value 2.
Set(HTML,First(Lookup(TeamPath, IDWEB_Path = ADO_Dropdown.SelectedText.Value)))
it is bringing me an error: WE can't evaluate your formula because the values being compared in the formula aren't the same. And I dont understand if the problem is with the comparation or with the formula itself.
Appreciate any help
Found the solution. in Dropdown on change I used lookup correctly and in the Label I post in properties the VAR.
@lupompei wrote:Hello
I have a list in Sharepoint with some colunms. The Colunm with value 1 is in a dropdown and I want to bring the information from Colunm with value 2 in a label. This will be a clickable link. Im using this formula in OnChange of Dropdown to try set my var HTML with the value 2.
Set(HTML,First(Lookup(TeamPath, IDWEB_Path = ADO_Dropdown.SelectedText.Value)))
it is bringing me an error: WE can't evaluate your formula because the values being compared in the formula aren't the same. And I dont understand if the problem is with the comparation or with the formula itself.
Appreciate any help
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional