Hello
Please be so kind as to read my full post before responding.
Thank you for your consideration.
In one of my PowerApps, I want to show a Gallery of items of a custom "WelcomeApp Event Config" entity, which is linked to the default systemuser entity via a many-to-many relationship "kk_kk_welcomeapp_userconfig_systemuser", depending on the user who is logged in.
I have a two other many-to-many relationships between custom entitities which don't cause any problems.
Since this is a pretty recent PowerApp, the relational data feature is turned on by default.
But with this particular relationship, I don't seem to be able to use the relational table as Items or for Collect.
Both of them only yield an empty (?) table.
CountRows works though.
What happens in my App is that with App.OnStart I have:
Set(userEmail, User().Email);
Set(testCount, CountRows(LookUp([@Benutzer], 'Primäre E-Mail-Adresse'=userEmail).'WelcomeApp Event Configs (kk_kk_welcomeapp_userconfig_systemuser)'));
ClearCollect(testCollect, LookUp([@Benutzer], 'Primäre E-Mail-Adresse'=userEmail).'WelcomeApp Event Configs (kk_kk_welcomeapp_userconfig_systemuser)');
CountRows gives the correct result from the CRM, but Collect of the counted thing yields nothing
I've also tried directly using the relational table as Items of a gallery EventConfigsGallery.Items
LookUp([@Benutzer], 'Primäre E-Mail-Adresse'=userEmail).'WelcomeApp Event Configs (kk_kk_welcomeapp_userconfig_systemuser)'
and set Text of a Label to
CountRows(testCollect) & "/" & testCount & ", " &
CountRows(EventConfigsGallery.AllItems) & "/" &
CountRows(LookUp([@Benutzer], 'Primäre E-Mail-Adresse'=userEmail).'WelcomeApp Event Configs (kk_kk_welcomeapp_userconfig_systemuser)') &
" Events"
yielding
This only showcases the same problem I had with App.OnStart.
My questions
- How do I get this to work?
- What's the problem here?
- Am I using the wrong entry from the (below) autocomplete list?
- Is there something special about (many-to-many?) relationships to the systemuser entity because there's already a lot of standard relationships to that entity anyway?
Thank you,
Sa.
