Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Oracle Connector table limit

(0) ShareShare
ReportReport
Posted on by

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

  • ConstructionBI Profile Picture
    ConstructionBI 6 on at
    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.

  • benatmic Profile Picture
    benatmic 6 on at
    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 Profile Picture
    ConstructionBI 6 on at
    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 Profile Picture
    benatmic 6 on at
    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 Profile Picture
    ConstructionBI 6 on at
    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 Profile Picture
    benatmic 6 on at
    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.

     

     

  • v-monli-msft Profile Picture
    v-monli-msft on at
    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics