web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using Search function ...

Power Apps

Answered

Using Search function for searching in lookup columns

(0) Share

Report

Report

Posted on by PratikJadhav08

86

I have few lookup columns in my table , namely "PERMIT_TYPE" , "DEPARTMENT" and "PLANT".

The formula i wrote is as follows , even before completing i get this error. I checked the syntax but couldn't find any solution.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Pacel1 79 on at

Like (1)

Report
Copy link

Link copied!
Searching the lookup column can be problematic.
To work around this, you can create a collection that adds the text value from the lookup field to a new column
ClearCollect(NameOfCollection,AddColumns(WORK_PERMIT_DETAILS,YourNewColumnName,PERMIT_TYPE.'PERMIT_TYPE'))

Then searching the collection should work correctly

Search(NameOfCollection, TextInput2.Text,YourNewColumnName)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Pranay123

Can you please remember to post your code in Text - saves re-typing here. The code should be something like
Search( AddColumns( WORK_PERMIT_DETAILS, PermitType, PERMIT_TYPE.Value ), Textlnput2.Text, PermitType )

Also as a bit of advice, SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field items directly from the second list with Power Apps and write back to a Text column.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No

Join the conversation