cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Catalog items - if/else does not work

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Catalog items - if/else does not work

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

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Catalog items - if/else does not work

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

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Catalog items - if/else does not work

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

Highlighted
Community Support
Community Support

Re: Catalog items - if/else does not work

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

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper III
Helper III

Re: Catalog items - if/else does not work

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

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,198)