Announcements
Hi friends,
from the pic below I tried to Name-surname box auto default display by value in emp id box by Lookup formula but its shows a warning message like this, how could I fix this?
employee table in excel online
Hi @Anonymous
I suspect that EmpID is formatted in your Table as Text (both the left alignment and the error you are getting would suggest this). Try the formula without Value()
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
@WarrenBelz thanks for your reply, i tried to remove value() but result still the same.
@Anonymous ,
It is saying it will not accept a blank search box - you can try this
If( Len(DataCardValue6_l.Text) > 0, LookUp( Employee_T, EmpID = DataCardValue6_l.Text ).PersonnelNumber, "" )
however Excel is a terrible data source and that is another one that works for everything else that I have not seen posted before. I suggest you switch to SharePoint Lists if you have that available.
@WarrenBelz superbb, the warning message is already gone after replace with your formula, thanks a lot
I am having a similar issue. I have replaced my formula with the one you provided but I am still facing the "eq null" issue. My changed formula: If(Goal_Id_DataCard1 > 0,LookUp(Table1,Goal_Id = Goal_Id_DataCard1).Goal_Id,"")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
