Limit of imported data from MySql DB

(0) Share

Report

Posted on by FatimahAlQadib

I have MySql database link it to Power app, I have around 6000 rows & I want to import all into a Combobox.

I used this formula to import employee id concatenated with their names. It imported only 2000 rows. see image1

but when I used this formula I got all rows, see image2.

1- Why did it work like this? I want it to import & display all rows. and search the Combobox by Name or ID

2- Also, when I want to choose the EmployeeId (which is a primary key) as the search field & the primary text to be displayed into the Combobox I can't & it is not available to be chosen.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FatimahAlQadib

To the first question:
The issue is from AddColumns function, AddColumns function is not delegable for SQL Server, so it can only get 2000 record(maximum threshold). So the workaround is to create a calculated column in SQL table as Text type.

To the second question:
Do you mean you cannot select 'EmployeeId' from Field - Primary Text?
Could you please try to modify the DisplayFields and SearchFields directly to check if the issue is fixed?
1. set DisplayFields / SearchFields property of combo box: ["EmployeeId"]
Sik

Was this reply helpful? Yes No
FatimahAlQadib 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-siky-msft

for your suggestion to create a calculated column in SQL table as Text type. How to do it?

Yes, they are fixed I cannot change them. Even if I tried they return back to the default value.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @FatimahAlQadib

About how to combine two columns into a third column, please refer to these threads:
https://stackoverflow.com/questions/29947704/combine-two-columns-of-a-table-in-third-column
https://stackoverflow.com/questions/24729372/add-a-column-that-represents-a-concatenation-of-two-other-varchar-columns

To your second question, it seems to be a limitation that the combo box can only display Text fields.
As a workaround, please try to create a new column to store EmployeeId as Text, just as your first question.
Sik

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FatimahAlQadib,

Has your issue been resolved?
Feel free to post back if there are still problems.
Sik

Was this reply helpful? Yes No
FatimahAlQadib 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-siky-msft

For the limitation of MySql, I have used dropdown to filter the employees according to their department and then use the ComboBox to populate the employee id/name.

For my second problem,I have change the type of the employee_id as @v-siky-msft suggested

Was this reply helpful? Yes No