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?
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:
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.