cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
imabigdog
Level: Powered On

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
Community Support Team
Community Support Team

Re: Oracle Connector table limit

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.
benatmic
Level: Power Up

Re: Oracle Connector table limit

 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.

 

 

ConstructionBI
Level: Powered On

Re: Oracle Connector table limit

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.

benatmic
Level: Power Up

Re: Oracle Connector table limit

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 ?

ConstructionBI
Level: Powered On

Re: Oracle Connector table limit

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.

benatmic
Level: Power Up

Re: Oracle Connector table limit

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 ?

 

ConstructionBI
Level: Powered On

Re: Oracle Connector table limit

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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (9,661)