@LohithaSannathi
Your first step is to get Oracle DB as a data source in your PowerApp.
Use these instructions for using Oracle DB with PowerApps
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-oracledb
For remaining query:
@LohithaSannathi wrote:
For Example : If user selects Supplier name rest of All Supplier fields should be auto Populated. how to accomplish this. Is there any possibility of Writing queries to fetch the data and Auto populate in Fields based on Selected supplier.
Regarding the above you can do this by using a combination of Formulas and Variables in PowerApps.
Initialize a variable: On App Start and OnVisible of your first screen, use
Set(AlmostAnyVariableNameOfYourChoice,SomeInitialValue)
to initialize a variable.
You can use the "Default" property in each Control for AutoPopulation - just change the Default property of a control to the name of a variable you initialized, which is almost any variable name of your choice.
On your Dropdown control, use OnChange to make something happen when the value is changed. This is where you might change your Variable(s) value(s) using something along the lines of the below pseudo-formula for OnChange:
If(NameOfSomeRelevantControlAnyhwerInTheApp.UseCorrectRelevantPropertySuchAsSelected.UseCorrectRelevantPropertyIfApplicableSuchAsValue = "Some Text Value 1",Set(AlmostAnyVariableNameOfYourChoice,SomeNewValue);Set(SomeOtherVariable,SomeOtherValue),SomeOtherSimilarIfConditionForTheElsePartThatCanEvenHaveMoreConditionsNestedWithinItIfNeededInSimilarWay)
So then these changes will be picked up by the Variable and would then be auto-populated in all the Controls due to the Default property of the Controls being set to the appropriate variables.
So we recommend you focus on the data source part first, you are using on-premises Oracle so it is tricky, you'll need to set up a gateway and do initial setup to use PowerApps with Oracle on-premises.
