Unanswered

Use an item in a gallery to find a value from a collection dynamically

(0) Share

Report

Posted on by GuMean

Hi all.
I would like to use an item in a gallery to find a value from a collection dynamically. I have a lookup that works:
LookUp(colTest, ID = varID).'Name'
But I would like to use an item from the gallery to determine the name of the column to use in colTest, for example:
LookUp(colTest, ID = varID).'ThisItem.Name'
I am receiving the error message 'ThisItem.Name' is not recognised, as it is not a column name in colTest.
Is there any workaround?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report

HI @GuMean ,

You would have to hard-code all of that as you cannot refer to column names dynamically.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
GuMean 77 on at

Like (0)

Report

Thanks. I have saw previous answers saying that hardcoding was the only option...I was hoping that there would be a workaround now.

Was this reply helpful? Yes No