web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Invalid Argument Type ...

Power Apps

Answered

Invalid Argument Type Lookup Column

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I am new to Power Apps and I am having some problems when trying to add a filter to a dropdown using a lookup field.

This is what I am trying:

Sort(Filter('List Name', 'LookupField' = ""), 'DropDownDisplayName',Ascending)

If I use another list where the dropdown is not a lookup column it works fine.

Any help or ideas on how to fix this will be very appreciated.

Thank you!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Take a look at the third video on this web page https://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-with-respect-to-all-column-types/
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You cannot filter on a Lookup field - you might try this (note the comment at the bottom also)

Sort( Filter( AddColumns( 'List Name', "MyLookup", 'LookupField'.Value ), MyLookup = Blank() ), 'DropDownDisplayName', //this needs to be the field name, not the control Ascending )

Please click Accept as solution 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 Thumbs Up.

Join the conversation