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

Announcements

News and Announcements icon
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:
  • Verified answer
    RezaDorrani Profile Picture
    12,145 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
    Microsoft Employee 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 271

#3
Mohsin Ali Profile Picture

Mohsin Ali 239

Last 30 days Overall leaderboard