Hi
I have a peculiar issue, that I am struggling to resolve.
Setup:
PowerApp with SharePoint list as data source.
Problem:
In my app I store the record that I am currently working with in the variable varRecordToOpen. There is a column called FunktionenNeu which ist of the type choice and allows multiple values.
To manipulate the options for FunktionenNeu I store the selected values to a local collection.
The local collection is called colFunktionenNeu and is populated in the following way:
The collection colFunktionenNeu is used throughout the app.
This is where the problem occurs. The expected result would be the values of the selected options in my collection. This should not take longer than a few ms.
In reality this takes roughly 30 seconds and in some cases the browser stops responding.
In the monitoring tool it shows the click of the button and the storing of the values. But this is followed by roughly 1800 LookUp-calls none of which containing any details.
As a reference I tried the same operation on a test collection that is used nowhere else:
This results in the expected behaviour:
To add to this peculiarity I use the same setup (choices and local collection) for other columns, where it seems to be working as intended.
Which leads me to the following questions:
I would be grateful for any advice, insights or tips you can give me.
Best regards
Jek
WarrenBelz
87
Most Valuable Professional
mmbr1606
71
Super User 2025 Season 1
Michael E. Gernaey
65
Super User 2025 Season 1