Power Platform Community Forum Thread Details

hi Team,

I have a requirement where I need to create one gallery, this gallery should contain the data from two Azure SQL tables, TableA, TableB

Schemas of TableA is

TableA : (colA: string, colB: string, colC: int........)

TableB: (colA`: string, colB: bool..........)

ColA and ColA` will contain same value

for a value in colA, there can be multiple entries in TableB

In my gallery I want to display like

ColA, ColB, trueCountFromTableB, falseCountFromTableB, colC

Can someone suggest how to achieve this.

Categories:

data from two tables in one gallery