Announcements
Hi there.I need to display user name (meno-cloveka) from Excel stored on SharePoint in a label.I created a label with lookup formula, but it doesn't work. Although I look on it for a two hours I am not able find out what is problem. I will grateful for help.
Have you tried adding a period after the last parentheses?
Yes, I did. But nothing happened. Btw, this is text of error: "Syntax error at postion 6 in email-cloveka eq 900121@… inner exception: Syntax error at position 6 in email-cloveka eq 900121@… . client ReqestId: …"
@MonteTT
Try this,
LookUp(DataSource,email-cloveca = "EmailAddress").meno-cloveca
-------------------------------------------------------------------------------------------------
If it solved your problem give a kudo and accept it as a solution.
Follow and Subscribe 365 Stack for more updates.
Doesn't work, but it doesn't matters. I have solve it - I insert the data directly into the app. Thanks to all for effort.
Hi @MonteTT ,
I suspect you may have spaces in the end of the email address so if the criteria includes hard-coded text it will not return the result. Try and use a Trim function for the email-cloveca column that is:
LookUp(ExcelTable;Trim('email-cloveca') = "...";'meno-cloveca')
Hope this helps.
Best regards,
Community Support Team _ Jeffer NiIf this post helps, then please consider Accept it as the solution to help the other members find it.
I have same problem but my data have "-" on it like 12345-1 the "-" is the problem, Some one could help me ?
LookUp(Import, 'Part-Number' = StockRoomCriticalBoard[@MATERIAL])
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 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
