cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Weird Error in Apps (... eq null)

Hi, 

I have created an app that allows managers to access employees details in one glance. The app is working fine, all the details are able to appear when managers search their employees names. But there's always error codes popping out when we use the app. When I tried to fix the issue back in the edit mode, the red wiggly lines just disappeared.

Is there someone out there who knows what's the problem and how to solve it?

Please let me know if I need to provide more details. Thanks!!!

Data Source : Excel Online

KSV_0-1618391224221.png

Below is the dropdown selection of employees name according to the manager (user log in)

KSV_1-1618390489144.png

 

Below is one of the result details that will appear.

KSV_2-1618390679425.png

 

 

3 REPLIES 3
JR-BejeweledOne
Super User
Super User

Right off the top of my head it appears to be telling you that there is no value in DropdownMgr.Selected.Result



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
Anonymous
Not applicable

Hey @JR-BejeweledOne , thanks for the reply.

Is there a way to correct the error even when DropdownMgr.Selected.Result has no value?

Example : if DropdownMgr.Selected.Result is blank, no nothing (Not sure how the coding works for this)

Will the example above helped to solve the problem?

JR-BejeweledOne
Super User
Super User

Try this:

 

If(
   !IsBlank(DropdownMgr.Selected.Result),
     LookUp(FDnm2,
        EmpNAME = DropdownMgr.Selected.Result,
        EmpID
)


If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,187)