Error messages - Ugh!

Like (1) Share

Report

Posted on 22 Mar 2025 22:27:52 by KDennis

Hi there,

I'm on lesson 6 (Connect to Loans table data in my canvas app) of Building a Canvas App for a School Library (I'm slow) and need some guidance.

When I connect the Loans database to the app, it works fine (picture 1). When I put in the formula, it gives error messages (picture 2). I've even tried picture 3 but still get the error messages. Does anyone have any tips to try?

Also, in my infinite wisdom I may have changed something with the source data and don't know how to 'reset it'. Loving the program so far!

Thanks!

Keri

I'm

Categories:

General Discussion

All responses (8)

Answers (0)

Suggested answer

RitaBento 4 on 21 Apr 2025 at 22:15:02

Like (0)

Report
Error messages - Ugh!

Hi Keri,

Since I'm not sure if you allready managed to make it work...

There is only one thing that I've noticed that hasn't been mentioned yet:

Where you have "Find Student" that is a "Text". But what you need is a "Text input".

Hope it helps,

Rita
w.p 4,373 on 24 Mar 2025 at 16:30:30

Like (0)

Report

Error messages - Ugh!

For housekeeping and others can benefit, please mark the post if it answers your question.
KDennis 9 on 23 Mar 2025 at 13:08:34

Like (0)

Report

Error messages - Ugh!

Thank you so much for this It's really helpful!
Suggested answer

w.p 4,373 on 23 Mar 2025 at 00:39:33

Like (0)

Report
Error messages - Ugh!

Don't worry, this forum is dedicated to Power Up program students (I think).

1-From your screenshots I couldn't find the text input control and its name also need to change to txtSearch

2-txtSearch.Text for classic text input control
txtSearch.Value for modern text input control

Search(Loans,txtSearch.Text,StudentFullName)

3-The formula expression is case-sensitive. Use Intellisense instead of typing the full text.

Intellisense suggestions:
Use the arrow keys to navigate through the suggestions and press Tab to select and insert the highlighted suggestion.
KDennis 9 on 23 Mar 2025 at 00:07:05

Like (0)

Report

Error messages - Ugh!

Sorry, total newbie here. I've created this a couple of times and I still get the error so I'm wondering if it's something 'deeper'?
w.p 4,373 on 22 Mar 2025 at 23:51:48

Like (0)

Report

Error messages - Ugh!

@KDennis

Can you show the Items formula of the gallery.

Deleting and recreating the gallery might be faster than troubleshooting.
KDennis 9 on 22 Mar 2025 at 23:40:02

Like (0)

Report

Error messages - Ugh!

Here are the error messages associated with galLoans. Thanks so much for looking at this @w.p!

Here are some of the other error messages for good measure. I really hit the error jackpot on this.
w.p 4,373 on 22 Mar 2025 at 23:03:02

Like (0)

Report

Error messages - Ugh!

It seems it has something to do with the gallery items/source (galLoans).

Can you provide the error messages of the galLoans?