Lookup table in AddColumns

(0) Share

Report

Posted on by WebPortal

2,297

This is my "Tab" collection:

It was built with a ClearCollect (... AddColumns(....)) expression.

Now, I want to Lookup the "ID_Evento" column in another table. Is this possible to do within the same expression within the AddColumns, or do I have to create another expression?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@WebPortal

Sure, in your AddColumn formula, just do the Lookup there.

AddColumns( your existing formmula, "yourLookup", LookUp(otherTable, criteria) )

I hope this is helpful for you.

Was this reply helpful? Yes No
WebPortal 2,297 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

This is the entire formula:
ClearCollect(
Tabs,
AddColumns(
GroupBy(
Eventos,
"ID_Evento",
"Tab"
),
"DataIni",
Text(
Min(
Tab,
'Data de Início'
),
"[$-en-US]dd/mm/yyyy"
),
"IDCurso",
Max(
Tab,
ID_Curso
),
"IDFormador",
Max(
Tab,
ID_Formador
),
"Valor",
Sum(
Tab,
Valor
),
"Local",
First(
Sort(
Tab,
'Local de realização',
Ascending
)
).'Local de realização',
"Tipologia",
First(
Sort(
Tab,
Tipologia,
Ascending
)
).Tipologia,
"Modalidade",
First(
Sort(
Tab,
Modalidade,
Ascending
)
).Modalidade,
"Estado",
First(
Sort(
Tab,
'Estado',
Ascending
)
).'Estado',
"TituloCurso",LookUp(Cursos, ID_Curso = IDCurso).Designação
)
)

The last part in the LookUp I'm getting an error:

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@WebPortal

Yes, that name does not exist in the scope of your AddColumns. If you were to do another AddColumns outside of the AddColumns, then it would exist.

But the simpler answer is the following:

ClearCollect( Tabs, AddColumns( GroupBy(Eventos, "ID_Evento", "Tab" ), "DataIni", Text(Min(Tab,'Data de Início'), "[$-en-US]dd/mm/yyyy"), // NOTE: Min is not reliable on Dates "IDCurso", Max(Tab, ID_Curso), "IDFormador", Max(Tab, ID_Formador), "Valor", Sum(Tab, Valor), "Local", First(Sort(Tab,'Local de realização',Ascending)).'Local de realização', "Tipologia", First(Sort(Tab,Tipologia,Ascending)).Tipologia, "Modalidade", First(Sort(Tab,Modalidade,Ascending)).Modalidade, "Estado", First(Sort(Tab,'Estado',Ascending)).'Estado', "TituloCurso", LookUp(Cursos, ID_Curso = Max(Tab, ID_Curso)).Designação ) )

Was this reply helpful? Yes No
WebPortal 2,297 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes
Ok, that makes sense, thanks for helping!

Was this reply helpful? Yes No