cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
imabigdog
New Member

Oracle Connector table limit

I'm want to use powerapps to connect to Oracle 11g tables.   But seem the Oracle connector is limited to the first 150 tables (alphabetically) .  Is there any way to:
1. Up the limit?

2. Specify the 150 tables instead of it just getting the first 150?



Thanks All

7 REPLIES 7
v-monli-msft
Community Support
Community Support

Hi @imabigdog,

 

It seems that this is the current limitaion in flow. Consider to post an idea to see if this could be considered into future release:

 

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Regards,

Mona Li

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 Hello,

this limit of the 150 tables in Oracle still exists on september 2017 and we also don't have access to the views.

This is a major issue for my company. Due to that limit we will not use PowerApps.

 

 

Have you tried selecting the 'enter custom value' choice at the bottom and manually entering the view name (the format would be  namespace.view)? I was able to connect to views doing this. But then I get stuck because the connector only returns 512 rows and setting the 'maximum get count' doesn't seem to work.

Thank you for your answer, I'm a bit disappointed by those connexion issues.

 

I'm using PowerApps on line, not in Visual Studio :

is it the reason why I don't see  'enter custom value' choice on the bottom ?

 

When I make my formular, I insert an object 'Data table'

which I connect to the Oracle connector, selecting a whatever table (one of the firsts table of my database).

Then for this Data table inserted on my window, I select 'Advanced' properties.

For 'Data Items', I change the value for '[TEST].[PART_TAB]'.

==> It doesn't worked : I have an error 'Invalid name'

 

Do you try also connexions on other tables than the firsts given in the list ?

I am not actually making the Oracle connection directly from PowerApps, so not sure what the user experience there is like. I am using Flow directly. I was assuming the connector would have the same experience between PowerApps and Flow, but that may not be the case. 

 

Maybe try 'TEST.PART_TAB' (without the [])? 

 

And i didn't try and other tables first.

Thank you ConstructionBI for your help.

 

When you write your using Flow, do you first create the connection via the main menu 'Connections', and choose for Oracle Database the table or view you want ?

 

In my case I did the following:

 

1. Created a new flow from blank template

2. Setup a recurring schedule (but could be setup with different trigger)

3. added an action of type 'Oracle Database - Get Rows'

4. If i remember correctly, it then asks you for your db connection info and credentials

5. Clicked the 'Table name' dropdown and scrolled to the bottom and selected 'Enter custom value'

 

After this, I tested the flow run and it successfully pulled rows. But i ran into the 512 row limit after this step.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,379)