Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZfRu6jjkk59OW5WJeEIlk7
Power Up Program - Build A Canvas App
Answered

6. Connect to Loans table data in my canvas app- Formula for search is not working

Like (1) ShareShare
ReportReport
Posted on 23 May 2025 11:30:26 by 2
In lesson 6 , when we write this formula(
Search(Loans,txtSearch.Value,StudentFullName)
 
It shows error as it is not recognising (.Value)
 
see the screenshot
Categories:
  • Verified answer
    timl Profile Picture
    35,189 Super User 2025 Season 1 on 23 May 2025 at 15:37:39
    6. Connect to Loans table data in my canvas app- Formula for search is not working
     
    The txtSearch control should be a text input control - based on your screenshot, it looks like you added a label control.
     
     
     
     
    If txtSearch were a text input control, the icon should look like this:
     
    If you remove your current txtSearch control and replace it with a text input control, the error should go away.

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.

Helpful resources

Leaderboard > Microsoft Power Up Program Community

#1
w.p Profile Picture

w.p 326

#2
timl Profile Picture

timl 162 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 82 Super User 2025 Season 1

Featured topics