web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps- Data is not...
Power Apps
Answered

PowerApps- Data is not showing up for lookup field and showing error

(0) ShareShare
ReportReport
Posted on by

Hi,

 

In canvas app I am using Account and Contact lookup field while adding this lookup dropdown filed is showing error and not showing data.

 

Showing error as : The fuction 'Search' has some invalid argument for searchfeild.

 

Thanks ,

Prasad

Categories:
I have the same question (0)
  • Verified answer
    RezaDorrani Profile Picture
    12,143 on at

    @prasadsmartify 

    Use CountRows(Filter(datasourcename,User().Email in Approvers.Email )) and check to see if the row count is greater than 0. If yes then user is in the approvers list

  • v-xida-msft Profile Picture
    on at

    Hi @prasadsmartify ,

    Could you please share a bit more about your issue?

    Which formula do you used within your app? Could you please share more details about it?

    Further, do you use Search function in your app?

     

    Based on the needs that you mentioned, I suppose that you want to search your Account records or Contact records using Search function based on LookUp column, is it true?

     

    Currently, within PowerApps, the Search() function used to search records based on Text type columns rather than complex type column (e.g. LookUp column).

    If you want to filter your data source records based on LookUp type columns, please take a try with the following workaround:

    Filter(
     'Account',
     TextSearchBox1.Text in LookUpColumn.'Primary Name'
    )

    Note: The LookUpColumn represents the LookUp column in your Account data source. The 'Primary Name' represents the column in the referenced data source, where the LookUpColumn references values from.

    More details about Filter function, please check the following article:

    Filter function

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard