Power Platform Community Forum Thread Details

I have a gallery that is connected to my sharepoint list "List1". In this gallery I would like to make a lookup formula in a label that displays the value of my "End" column of my sharepoint list "List2" if the value indicated in the "Month" column of the list "List1" is the same as in the "Title" column of the list "List2"

I tried this but "Title" is not recognize :

LookUp('List2'; Text(Title) = Text(ThisItem.Month); 'End')

Categories:

Building Power Apps

We need to see your list for list 2. also, please share a screenshot of the error as well as a screen shot of all the columns in List2

If your error is title is not recognized, then it doesn't think its a column in List2.

So please share pictures.

Note, since Title is a Text field you don't need to use Text around it unless of course it got deleted. Also last note. The label of a Column isn't the same as its name.

so you may have a column Labelled Title, which is usually the default for any list, but the name my NOT be title.

1) Go to the list

2) Select the Gear Icon (top right corner)

3) go to List Details

4) scroll down to the Columns it lists

5) click on the one labelled Title

6) IF its even there, once you click and it opens the next page, look at the URL, at the END of it will be the actual internal NAME of the column..

use that.