Catalog items - if/else does not work

[Unbihexium]

Hello

I try to create one view respectively two views with the catalog depending on who is logged in.
That does not work and I do not know what I'm doing wrong.
Strangely, I have the same in another app which works wonderfull.

The tables comes from an Excel sheet which is saved in OneDrive... Excel table is correctly formated and every row has an powerAppSID
gallery1 (see screen shot)
code: no errors
If(User().FullName in Tabelle4.Visoren;Tabelle2;Tabelle1) --> does not work

If(User().FullName in Tabelle4.Visoren;Tabelle2.Auswahl2;Tabelle1.Auswahl1) --> does not work

Error in text field: "The name is invalid. This identifier is not recognized."

but the name is 100% correct and exists

as soon as I skip the "else" or leave only one table to choose from, it works !?

If(User().FullName in Tabelle4.Visoren;Tabelle2) --> works
or
If(User().FullName in Tabelle4.Visoren;Tabelle2;Tabelle2) --> works

What am I doing wrong? Please help me I despair here!

regards

[v-yutliu-msft]

Hi @Unbihexium ,

That's a little stange.

Could you tell me

1)are Tabelle1,Tabelle2,Tabelle4 all tables' name?

2)have you formatted all three tables?

3)have you connected with all three tables successfully?

4)did you use all these formulas in the gallery's Items?

Please try :If(User().FullName in Tabelle4.Visoren;Tabelle1)

Take a look at whether the problem is because of Tabelle1.

Best regards,

Community Support Team _ Phoebe Liu

[Unbihexium]

Hello Phoebe Liu

Thank you for your reply!

1) are Tabelle1,Tabelle2,Tabelle4 all tables' name? = yes (see screen shot 1 )

2) have you formatted all three tables? = yes (see screen shot 1)

3) have you connected with all three tables successfully? = yes (see screen shot 2)

4) did you use all these formulas in the gallery's Items? = yes, I would like to have different view for super visors 

Please try :If(User().FullName in Tabelle4.Visoren;Tabelle1) = this works fine but as soon I put "else" in, it dont work anymore. (see screen shot 2)

Its strange because I have already an app with the same option and this works. (see screen shot 3)

Best regards

[v-yutliu-msft · Accepted solution]

Hi @Unbihexium ,

I've made several times of test, but still not met the same problem like your description.

Maybe you could try to ask for help here:

https://powerapps.microsoft.com/en-us/support/

Best regards,

Community Support Team _ Phoebe Liu

[Unbihexium]

Hi Phoebe Liu

I will take a look as soon I get a bit more time for it. At the moment I've created a second screen for the other table(visors), and automated the login... this works fine.

login page:
If(User().FullName in Tabelle4.Visoren;Navigate(HomeScreen_Visors;Fade);
Navigate(HomeScreen_Users;Fade))

I've created a new app and a new Excel as well just to test it and got always the same error... I dont get it.

Anyway thank you very much for your efforts!
Have a good day!

Best regards