Display Two Tables in one Gallery

(0) Share

Report

Posted on by lonsdaleit

I have two Dataverse tables: "Database" and "Agenda".

I want to display in Powerapps Gallery 2 columns from the table "Database" : "D1" and "D2".

I want to add to the gallery from the table "Agenda" one additional column "A2" for each record for which the value of column "D1" of the table "Datbase" matches the value of column "A1" from table "Agenda".

I tried to change Item property of the Gallery as follows, but it does not work...

AddColumns(
 Database,
 A2,
 LookUp(
 Agenda,
 A1 = D1,
 A2
 )
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

lonsdaleit 7 on at

Like (0)

Report
In the Text property of the gallery textinput control I inserted:
LookUp( colAgenda, A1 = ThisItem.D1 ).A2

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @lonsdaleit

What is the cardinality between the tables? Could there be multiple rows in Agenda that match the Database record you are looking at? If that is the case the Lookup would match to multiple records. If this is the case you might want to switch the Lookup around and show the Agenda data and then join in the Database fields and see if that solves the problem.

Was this reply helpful? Yes No
lonsdaleit 7 on at

Like (0)

Report

Hi @dpoggemann

In table Agenda the column A1 is based as a lookup with reference to table Database D1. A1 is a unique list of project names. D1 contains the same unique list of project names (each name exist only on in each table).

My lookup does not work. I'm slowly getting crazy...

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Hi @lonsdaleit

So to be clear, you have a lookup field in the Agenda Dataverse table that is to the Database table, effectively creating a 1:N relationship from the Database to the Agenda table. If this is the case, you could have 2 agenda rows that both have the same lookup to the Database table and the Lookup function in your Canvas app wouldn't know which record to pull back in the results as there could be multiple matches.

You could do something like

AddColumns(Agenda, "MyDatabaseField", A1.MyDatabaseField)

The A1 is your Lookup Field and you should be able to pull any field from the Database table with this type of syntax.

Sorry if I am off base here...

Was this reply helpful? Yes No
satbhas1 4 on at

Like (0)

Report
Hi @lonsdaleit,

I see you'd mentioned the below. Does that mean the issue was resolved (as this is the type of expression I used...and it worked)?

************************************

In the Text property of the gallery textinput control I inserted:

LookUp( colAgenda, A1 = ThisItem.D1 ).A2

************************************

Was this reply helpful? Yes No