Power Platform Community Forum Thread Details

I am trying to build application for payment request where I have some static data and some of the data to be fetched from oracle database. So I have created all the records thru sharepoint list

I have a requirement to fetch data from oracle database multiple tables

Populate the data automatically based on the above selected values in drop down. Can you please help me how to achieve this.

For Example

Below is the screen shot from power apps

Please see pic 1

Based on the selection of org name – org id ,legal entity name, legal entity id, invoice currency should be autopopulated ( data source for this I have choosen is share point list, Records are one- one mapping)

Another one is below . Please see pic 2

Based on supplier GSL Number – Supplier name, vendor site code, address line1 ,address line2, city,state,country should be autopopulated ( This supplier GSL number should old the values which has been selected on Org name)

Below is my oracle sql query

SELECT PS.SEGMENT1, PS.VENDOR_NAME, SSS.VENDOR_SITE_ID, SSS.VENDOR_SITE_CODE, SSS.ATTRIBUTE14 AS SCX_CODE,

SSS.ADDRESS_LINE1, SSS.ADDRESS_LINE2, SSS.CITY, SSS.STATE, SSS.COUNTRY,

SSS.PAYMENT_METHOD_LOOKUP_CODE, OU.ORG_ID, OU.SHORT_NAME

--OU.SHORT_NAME,

FROM APPS.AP_SUPPLIER_SITES_ALL SSS, APPS.AP_SUPPLIERS PS

, APPS.GETS_INV_OP_UNIT_INFO OU

WHERE

PS.VENDOR_ID=SSS.VENDOR_ID

AND OU.ORG_ID=SSS.ORG_ID

AND OU.SHORT_NAME IN ('GEINIME','GEINIMT','GEINIDL','GERTIO')

AND nvl (sss.inactive_date,sysdate+1) >= sysdate