LookUp Formula error

(0) Share

Report

Posted on by RenataValente

Hi,

I'm trying to link a form ("Return Form") to a previously filled line in a sharepoint list ("Library APP Form").

The goal is when a person writes his/her name, the app searches the sp list lines, auto-fills the name of the book and when the person submits the form, it adds the return date to that same line.

I've used the LookUp formula: LookUp('Library APP Form'; NAME = DataCardValue44; 'BOOK TITLE') but it's not working ("incompatible type for comparison. it is not possible to compare these types: text, control").

Both columns are single-line text, so I don't understand what I'm doing wrong.

Can you please help?

Thanks in advance

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this
LookUp('Library APP Form'; NAME = DataCardValue44.Text; 'BOOK TITLE')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try using DataCardValue44.Text in your formula and it should work better.

Hope that helps,

Bryan
RenataValente 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Didn't work ☹️
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The LookUp edit suggest by me and @eka24 will work to generate a valid text response, but it looks like you are using this to populate the Items property of a dropdown? A dropdown is looking for a table of values to choose from, not a single text value. Can you help us understand better what you're trying to achieve?

Bryan
RenataValente 18 on at

Like
a
(0)

Report
Copy link

Link copied!

So the reason I chose a dropdown is because a person can have more than 1 book requested.
In that case, when they insert their name, the "book title" section will let them know the books they have in their possession and choose the one they want to return.

Do you think the formula won't work with the dropdown if there's only one book registered?

Thanks
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@RenataValente wrote:

So the reason I chose a dropdown is because a person can have more than 1 book requested.

In that case, when they insert their name, the "book title" section will let them know the books they have in their possession and choose the one they want to return.

Do you think the formula won't work with the dropdown if there's only one book registered?

Thanks

In that case, try using Filter() instead of LookUp() to get a small table of all the books your customer has reserved. Filter() returns a table of all records that match the search criteria, while LookUp() returns only the first matching record.

Bryan
RenataValente 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't get it 😭
Sorry @BCLS776 , but I'm new to powerapps and not even close to being a developer... so this might take a while 😅
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
No worries, we all start somewhere 🙂

Try putting this statement in the Items property of your dropdown:

Filter('Library APP Form'; NAME = DataCardValue44.Text).'BOOK TITLE'

This should return a list of the books associated with the user's name.

Bryan
hemrhk 361 on at

Like
a
(0)

Report
Copy link

Link copied!

In your Dropdown Items property,
Filter(Datasource,fieldNametoFilter=NameControl.Text)
Select the field which you want to show in the dropdown

Give a Like if it solves your problem.
Follow 365 Stack for more power platform updates
RenataValente 18 on at

Like
a
(0)

Report
Copy link

Link copied!

IT WORKED!!

THANK YOU SO MUCH BRYAN!