Power Platform Community Forum Thread Details

I have two oracle DB views and I need to write a query to use it on Power pp.

the first view is for getting all billing profiles that are related to one account number (Select * from DISCONNECT_ASSET_POSTPAID where AccountNum = '123456')

then search by each billing profile in the second DB (ASSET_VIEW_FULL) to check the statutes for each billing profile if the statutes are active, I need to ignore them and have only the inactive ones in the power app.

and the result at the end of the inactive billing profile needs to have them in the gallery.

Categories:

Building Power Apps