cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muhammad07
Helper I
Helper I

Search button

Hi Community,

I am working with search function. But I want it with lookup column.

Search(
Inventory_Test,
SearchBox.Text, "Part")

Part is a lookup column in Inventory_Test list. Error is looking for Text.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
phipps0218
Super User
Super User

You would need to use a Filter rather than Search because search function only supports text type field.

 

Try something like this: Filter(Inventory_Test, SearchBox.Text in Part.Value)

 

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

View solution in original post

2 REPLIES 2
phipps0218
Super User
Super User

You would need to use a Filter rather than Search because search function only supports text type field.

 

Try something like this: Filter(Inventory_Test, SearchBox.Text in Part.Value)

 

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

v-yujincui-msft
Community Support
Community Support

Hi @Muhammad07 ,

 

Maybe you could try the following formula:

Search(AddColumns(Inventory_Test,"partvalue",Part.Value),SearchBox.Text,"partvalue")

vyujincuimsft_0-1657874143905.png

 

 

Best Regards,
Charlie Choi

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,954)