Announcements
I trying to find a correct function for lookup SharePoint to get a row and specific column.
Like that? LookUp('Announcement Management', 'Announcement Screen' = "DHS Student Homepage")
Hi @dylandavis09,
Your formula is correct...
Could you please show me the error of the first screenshot?
Hover over on this red x mark, and post the specific error message.
Sure, here!
HI @dylandavis09,
I mean specific error message
Have you seen the red "X" sign? Hover over your curse on it and it will report an error message.
Post that to me.
Also, tell me which control and which property you set for this formula?
I am using text, and in this context, I would like to specify a title in 'DHS Student Homepage', where the 'message' column will display a message on the screen.
No, it is not the error message.
Have you seen the Name is not valid?
An error message will hover over your error, not the error like below:
What's more, if you want to display a specific column like Message in this Label, you need to modify your formula as below:
LookUp('Announcement Management', 'Announcement Screen' = "DHS Student Homepage").Message
It's working, thank you!
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 633
11manish 588
Valantis 457
