Unanswered

How to Fetch data by using oracle View based on the value selected in above fields

(0) Share

Report

Posted on by LohithaSannathi

I have oracle View

i have created power APPS using data source as SP List , Here i have some of the static data maintained in choices of SP List

For example

Org name - GEINIME then this value should be passed as parameter to my Oracle View and cascade the results in the below drop down fields of powerapps.

Please suggest your thoughts on how to achieve this . Quick responses are highly appreciated.

Thanks

Lohitha

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LohithaSannathi

If you are asking the general question of how to create cascading dropdowns I suggest you watch this video

Cascading Dropdowns by Shane Young

https://www.youtube.com/watch?v=pkZG2boN7jQ

Once you have watched the video and attempted to build it for yourself I would suggest you return to the forum and tell us what specific problems you are having.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
LohithaSannathi 69 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

I understand from static data point of view thru this video

https://www.youtube.com/watch?v=pkZG2boN7jQ

I am working on POC where we can fetch data thru oracle View
i have created power APPS using data source as SP List , Here i have some of the static data maintained in choices of SP List
i wanted to know whether it is possible or not , if possible need right direction to achieve this.
If Microsoft community is not able to give direction / If they not aware right direction . Request you to please let me know where to post to get the direction.

please let me know your thoughts, Quick responses are highly appreciated.

Thanks
Lohitha

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LothithaSannathi
Are you asking how can I create a Cascading Dropdown with Oracle views because there is no such thing as a Choices field?

The community is here to help and we'll do what we can to answer your question.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @LohithaSannathi

Can you try to setup the configuration like:

1) How are you getting the value from SharePoint list, lets say from the dropdown 1 using Dropdown1.Selected.ColumnName

Can you try to use Dropdown1.Selected.ColumnName on a temporary label and check if this is returning the correct value?

2) To pass this value in the Oracle query and get data in the second dropdown:
if Step1 returns correct data, you can use the expression as:

Filter(OracleDataSource, ColumnNameinOracle = Dropdown1.Selected.ColumnName)

This will populate the second dropdown from data in Oracle table based on filter from the SharePoint list.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
LohithaSannathi 69 on at

Like (0)

Report
Copy link

Link copied!

Hi
@mdevaney

Let me give clear idea on what POC im working on
I have attached POC _oracle View
Those fields i wanted to display in my power APP as it has some of the static data i have used SP List (List name - Test Request) to create them and create power APP using datasource as Test Request (Please see Test_Power APP_Oracle Invoice.docx)
i have org name i wanted to auto cascade data into the dropdown fields . I have DB connection to Oracle and Oracle View available to fetch data based on org name. I have also attached Oracle View. ( Please check GET_SUPPLIER_DETAILS.docx).
Once this request is submitted, it will trigger a flow asking for approval from Approver ( i have already created a flow)
I wanted to save the Request data submitted thru this APP so only created thru SP list (Test Request). Please correct me if im going in wrong direction

Can you please tell me how to auto cascade data based on org name. Also please correct me if im going in wrong direction.
Quick Responses are highly Appreciated.

Thanks
Lohitha

Test_Power APP_Or...
GETS_SUPPLIER_DET...
POC on Oracle Vie...

Was this reply helpful? Yes No
LohithaSannathi 69 on at

Like (0)

Report
Copy link

Link copied!

Hi
@yashag2255

Let me give clear idea on what POC im working on
I have attached POC _oracle View
Those fields i wanted to display in my power APP as it has some of the static data i have used SP List (List name - Test Request) to create them and create power APP using datasource as Test Request (Please see Test_Power APP_Oracle Invoice.docx)
i have org name i wanted to auto cascade data into the dropdown fields . I have DB connection to Oracle and Oracle View available to fetch data based on org name. I have also attached Oracle View. ( Please check GET_SUPPLIER_DETAILS.docx).
Once this request is submitted, it will trigger a flow asking for approval from Approver ( i have already created a flow)
I wanted to save the Request data submitted thru this APP so only created thru SP list (Test Request). Please correct me if im going in wrong direction

Can you please tell me how to auto cascade data based on org name. Also please correct me if im going in wrong direction.
Quick Responses are highly Appreciated.

Thanks
Lohitha

GETS_SUPPLIER_DET...
POC on Oracle Vie...
Test_Power APP_Or...

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LohithaSannathi

I really appreciate you taking the time to write down the details. Unfortunately, I'm still not understanding what you are needing to do... Sorry 😞

@yashag2255

Any ideas here?

Was this reply helpful? Yes No
LohithaSannathi 69 on at

Like (0)

Report
Copy link

Link copied!

Hi

@mdevaney , @yashag2255

I am attaching the sample that will be fetch my oracle View. (GETS_SUPPLIER_DETAILS.XLS)
I have attached excel sheet with fields that i need in my power apps (mentioned Static means- not from Oracle DB ,System Driven means - data fetched from Oracle Database)
Once i select org name rest all the fields (System Driven) need to fetch data or cascade data in to below fields.
Hope you understood what i need. Please let me know if you still have any questions.

Thanks
Lohitha

GETS_SUPPLIER_DET...
POC on Oracle Vie...
Test_Power APP_Or...

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @LohithaSannathi

If I am understanding it correctly, you want to get a few fields form excel and few from the Oracle database.

To get the fields from Oracle database, you can create a collection on the "OnChange" property of the control where you are selecting the "Org" name as:

Control -> OnChange -> ClearCollect(MyCollection, LookUp(OracleTable, ColumnforMatchingOrgName = Dropdown1.Selected.Value))

Here, I was not able to find any column in the excel sheet shared by you, which matches Organization Name, so please update the column name as needed.

Now, in the individual controls, select the controls inside the datacard, unlock them and set the Default Property as:
State Field: First(MyCollection).State
and so on.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
LohithaSannathi 69 on at

Like (0)

Report
Copy link

Link copied!

Hey
@yashag2255

"If I am understanding it correctly, you want to get a few fields form excel and few from the Oracle database." -- Here you are going in wrong direction to understand my requirement. Let me try to explain you bit more clearly

Here i have uploaded the fields in excel ,Doesn't mean it i want it from Excel.
I am trying to show you all the fields that i need in my power APP and mentioned against each field saying static /System Driven based on Org Name (Org Name is the column name)

Static - Refers to field not from DB (either free to enter data directly or select from choices)
System Driven - Refers to field fetch from oracle DB

I have created SP List (SP List name - Test Request) , The Fields available in SP List are same in Excel ( I have sent you Excel sheet to give you bit more clarity).

I have created a POWER APP using "P List -Test Request" and also selected Data source as "SP List -Test Request". I wanted to save the Request data submitted thru this APP so only created thru SP list (Test Request). Please correct me if im going in wrong direction.
Please refer power apps screen shots in "Test_Power APP_Oracle Invoice.docx"

I have created Oracle View to Fetch the data from oracle DB
Fields are fetched from oracle DB along with the sample data returned thru oracle (Please see GETS_SUPPLIER_DETAILS.xlsx)

i have org name i wanted to auto cascade data into the dropdown fields .( i mean all the system driven fields mentioned /Shown to you thru excel sheet "POC on Oracle View.xlsx"

If you are still not clear of what im asking .please let me know

Thanks
Lohitha

Test_Power APP_Or...
GETS_SUPPLIER_DET...
POC on Oracle Vie...

Was this reply helpful? Yes No