cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Jer82

PowerApps table selection limit

Submitted by Jer82 on โ€Ž06-26-2017 08:33 AM

We have a database that exceeds the current number of tables that can be returned by the search when building a SQL connector in PowerApps. 

 

It would be nice to have the ability to manually enter a table name, or some other ability to select the tables outside of the limit.

Status: New
See more ideas labeled with:
7 Comments (7 New)
Comments
PierreGiusti
PierreGiusti
Level: Powered On
โ€Ž07-12-2017 12:55 AM

This is very important and necessary.

 

Pierre

imabigdog
imabigdog
Level: Powered On
โ€Ž09-06-2017 09:07 AM

I'm running into the same problem with the ORACLE connector.  I'm not able to access all the tables in

my database.....

Any one come up with a solution or workaround for this.  


Jer82
Jer82
Level: Powered On
โ€Ž09-06-2017 09:25 AM

There are a couple of workarounds that I am playing with, neither of which are ideal.

 

1. Configure permissions at a table level for a specific service account and restrict it to only the tables that are  required for your specific PowerApp.  If you require more than the limit of tables, you may have to create multiple accounts for different connection points.

 

2. Configure some sort of method for your data to be replicated to another database (in our case a SQL Trigger) and then somehow processed back into the source database.  This is the method we are currently leaning towards as we ran into some other issues regarding SQL defined required fields which are not required via our software.  Once a field is required by SQL and you are using a SQL connector via PowerApps you cannot have is as an optional field in PowerApps (Not sure if Oracle has the same restriction).

 

Hopefully one of these solutions will help

avanderm
avanderm
Level: Powered On
โ€Ž09-12-2017 09:57 AM
MS Flow provides a "Enter Custom Value" option in the Oracle related actions, why not add this functionality to Power Apps?
bbasham
bbasham
Level: Power Up
โ€Ž11-09-2017 08:53 AM

Yes this would be great! I have an oracle database that I need to see all the tables for. Currently I can only see the first 512 tables. It would be awesome to have all the tables availble. 

avanderm
avanderm
Level: Powered On
โ€Ž12-05-2017 10:16 AM

I used the following workaround:

 

1. Create a new user on the Oracle DB

2. Grant SELECT, INSERT, UPDATE, DELETE rights on tables that you want to use in PowerApps for this user

3. Create a new connection in PowerApps for this user

RandallAtRyder
RandallAtRyder
Level: Powered On
โ€Ž12-06-2017 08:04 AM

I have an Oracle user account with 4300 tables (!!!).  I'm trying to get the dba to reduce that, but meanwhile I can't get at the tables I need to access via PowerApps or Flow (too far down in the result set)...