Choices

(0) Share

Report

Posted on by Anonymous1198

In Lookup Column, Item property not working

LookUp('account','name' = [TextInput3.Text],[TextInput4.Text],[TextInput5.Text])

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous1198 ,

You are using the wrong syntax. Please try:

LookUp( 'account', 'name' = [TextInput3.Text] || 'name' = [TextInput4.Text] || 'name' = [TextInput5.Text] )

Was this reply helpful? Yes No
Anonymous1198 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
It give only one value not all 3 in Lookup comboBox

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous1198 ,

If you want to return only items that match for all three criteria, use && instead of ||:

LookUp( 'account', 'name' = [TextInput3.Text] && 'name' = [TextInput4.Text] && 'name' = [TextInput5.Text] )

Was this reply helpful? Yes No
Anonymous1198 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer

If I use [] then incompatible compare error

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous1198 ,

Apologies, but I don't understand what you mean by that.

What is it you need to get from the data source?

So far I provided solutions where:

- the name is equal to either of the three TextInputs

- the name is equal to all three TextInputs

If you're looking to get more that one item, you need to use the Filter function instead of LookUp:

Filter( 'account', 'name' = [TextInput3.Text] || 'name' = [TextInput4.Text] || 'name' = [TextInput5.Text] )

Was this reply helpful? Yes No
Anonymous1198 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer

Actually
I have two Screen and on First Screen have 2 Editform of Account Tables
Second Screen, I have 1 Contact table editform having Account Table Lookup and item =[Choices([@'Contacts'].account)
If user fill both edirform of Account table then in Second Screen Account Lookup show DataCardValue1 and DataCardValue2 as choices

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous1198 ,

This is a bit different to what you asked earlier on, but ok..

So you want to filter the choices for a LookUp type column, based on the selected items in DataCardValue1 and DataCardValue2? The below should work for the Items property of the lookup DataCardValue on screen 2 if DataCardValue1 and DataCardValue2 are both ComboBoxes:

Filter( [Choices([@'Contacts'].account), Id = DataCardValue1.Selected.ID || Id = DataCardValue2.Selected.ID )

Was this reply helpful? Yes No