SQL Query to powerapps

(0) Share

Report

Posted on by HectorOlivos

411

Hello community.

Is it possible to make the next SQL query into powerapps

SELECT 
P.planta as Planta,
C.[nombre_cliente] as Cliente,
 EIG.[ID_INFORMACION],
AMS.FOLIO_COTIZACION + ' - ' + EIG.Part_Description as [FOLIO_COTIZACION],
AMS.ANIO,
AMS.MES,
AMS.DESCRIPCION,
 AMS.NUM_RECLAMOS_OF,
 AMS.NUM_RECLAMOS_NOF
FROM 
[PCP_ALERTAS_AMS] as AMS
LEFT JOIN EPCP_INFORMACION_GENERAL as EIG ON EIG.[ID_INFORMACION] = AMS.ID_INFORMACION
left join [dbo].[COT_CLIENTES] AS C on EIG.id_cliente = C.[id_cliente]
left join [DW_PCP].[dbo].[COT_PLANTAS] as P on P.id_planta = EIG.PCPPlant

I´ve tried to do it, but im getting some trouble with AddColumns

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

You can't run SQL Select queries directly from Power Apps. You can use a Flow to run the query and return the data.

Was this reply helpful? Yes No
HectorOlivos 411 on at

Like (0)

Report
So working with power automate is way more optimal, thanks for the advice.

However I´ve tried using the next formula

ClearCollect( colGridData, AddColumns( AddColumns( PCP_ALERTAS_AMS As AMS, "id_planta_p", LookUp( EPCP_INFORMACION_GENERAL, FOLIO_COTIZACION = AMS.FOLIO_COTIZACION, PCPPlant ), "id_cliente_c", LookUp( EPCP_INFORMACION_GENERAL, FOLIO_COTIZACION = AMS.FOLIO_COTIZACION, id_cliente ) ), "Planta", LookUp( COT_PLANTAS, id_planta = id_planta_p, planta ) , "Cliente", LookUp( COT_CLIENTES, id_cliente = id_cliente_c, nombre_cliente ) ) )

This is only to show in gallery.
But sometimes the formula loads everything and sometimes it dont.

image.png

image.png

Was this reply helpful? Yes No
Verified answer

HectorOlivos 411 on at

Like (0)

Report

I just created a SQL View to make it more simple, and used it as datasource for the gallery
😊

Was this reply helpful? Yes No