Answered

ClearCollection and confusing

(0) Share

Report

Posted on by dalacarelia_196

648

I have a problem with my Collection; it doesn't display all the columns in my Gallery when I use "ThisItem." However, when I directly reference the database, it shows the contents of that column. It's as if the collection is losing some columns.

I have no filters or any other operations such as dropping columns; it's just a straightforward query and connection to my SharePoint database.

ClearCollect(VisaKoppladeKonton_Admin;
Switch( lblKst.Text;

"1003";UnitGVXSTU_BANK;
"1004";UnitUPPSTU_BANK;
"1005";UnitSDLSTU_BANK;
"1006";UnitORBSTU_BANK;
"1008";UnitVSTSTU_BANK;
"1010";UnitKSDSTU_BANK;
"1012";UnitHELSTU_BANK;
"1014";UnitVXOSTU_BANK;
"1015";UnitJKGSTU_BANK

)

In both cases, "ThisItem.usermail" is visible.

Direct to the database
UnitGVXSTU_BANK

From the collection
VisaKoppladeKonton_Admin

Any idea ?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Jonathan Manrique 2,695 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello
You should check the number of records that are being loaded into the collection whether or not you are delegating the function you are executing. Power Apps has a limit of 2000 records, which are the ones it brings when we use formulas and these have delegation.
I recommend you take a look at this video

https://www.youtube.com/watch?v=plXNRszEXxU

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you sir for your response. I found the issue, and it was because the databases didn't have identical column names. When I changed that, my collection started working.

The tip ypu gave me was a good reminder of the limits 🙂

Was this reply helpful? Yes No