Gallery to show multiple tables

(0) Share

Report

Posted on by jesenavaranjan

227

Is it possible to have your main gallery show multiple linked fields from 3 tables

EG - show field 1 from another tabled based on unique key?

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (2)

h-nagao 392 on at

Like (1)

Report
Copy link

Link copied!

Hi,
It is possible to display fields from another tables, if there exists unique key.

1. Define 2 tables (ex: table1 , table2)
2. Set Items property of Gallery as table1
(assuming “unique key” is unique in table1)
3. Add label to Gallery and set text property as
LookUp(table2, <unique key field in table2>= ThisItem.<unique key name>, <return field name in table2>)

Thanks,

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like (0)

Report
Copy link

Link copied!

Thank you! This is great, however I can't get it to work:
Is my syntax okay below?
This is for the Text property of the label (tbDeliveryInfo is the table 2)
LookUp('[dbo].[tbDeliveryInfo]',<ID>=ThisItem.<ID>,<DeliveryInfoID>)
I am getting the error 'Expected Operator'

Jese

Was this reply helpful? Yes No
h-nagao 392 on at

Like (0)

Report
Copy link

Link copied!

Hi Jese,
I think syntax is okay...
To figure out cause of error, could you attach screenshot of error and give a bit detail of your table?

Thanks,

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like (0)

Report
Copy link

Link copied!

Heres a screeshot

Table1 has 'MilestoneID'
Table 2 had additional info on 'MilestoneID'

Thank you

Was this reply helpful? Yes No
h-nagao 392 on at

Like (0)

Report
Copy link

Link copied!

Hi Jese, Thank you sharing detail, and I'm sorry my expression is a bit misleading. Please remove <>'s from field name, i.e., Just set Text property as LookUp('[dbo].[tbMilestoneDeliveryInfo]' , MilestoneID = ThisItem.MilestoneID ,MilestoneDeliveryInfoID) Thank you,

Was this reply helpful? Yes No
mogulman 764 on at

Like (0)

Report
Copy link

Link copied!
You don't mention the data source but when I need to do this in Gallery I use SQL Server views. View appears as table. BTW, VGA stands for View for Gallery.

ALTER VIEW [dbo].[MatterVGA] AS SELECT m.MatterID, m.MatterName, s.Stage, m.SettlementDate, cl.ClientName FROM dbo.Matter m INNER JOIN Client cl ON m.ClientName = cl.ClientID INNER JOIN Stage s ON m.Stage = s.StageID GO

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like (0)

Report
Copy link

Link copied!

Hi

My syntax is still returning an error

And says 'Invalid Argument Type'

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like (0)

Report
Copy link

Link copied!

I have thought about doing this
But I might have multiple rows in the my table 2 , which I need to call from
I will also consider doing this to see

Was this reply helpful? Yes No
h-nagao 392 on at

Like (0)

Report
Copy link

Link copied!

Hi I have checked your error, and you may have also "Name isn't valid...." error on ThisItem.MilestoneID. This error is arise when its name is not correct in data source (Table1). Could you verify field name once again?

Was this reply helpful? Yes No
jesenavaranjan 227 on at

Like (0)

Report
Copy link

Link copied!

It appears to be correct here?

Also what is the syntax for multiple criteria? Maybe because there is a sysdate within the data (table-dummy data right now) so if I select latest sysdate, perhaps it will only show 1 row?

Jese

Was this reply helpful? Yes No