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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Error When Comp...
Power Apps
Answered

Filter Error When Comparing Unique ID's

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi All,

 

I am attempting to make a cacasding drop down list using two tables, while comparing the unique ID's of items. My two tables are the follwing:

 

Referrals: ID, X, Y, Z, Created By, Created

Decision: Title, ID (reference to referral unique ID's), A, B, C

 

Currently, my first dropdown menu has an item value of Distinct(Referrals,ID). This works fine, but the problem comes in with my items value for my second dropdown, which is (Distinct(Filter(Referrals,ID = Dropdown1.Selected.Value),"Created By"). I get an error that the filter is attempting to compare a number to a text value. When I change the .Value to .ID, I still end up with an error stating that the equation is invalid. is there anyway that i can use a referenced ID to get the created by value? Thanks in advance.

Categories:
Building Power Apps
  • Verified answer
    v-micsh-msft Profile Picture
    v-micsh-msft Microsoft Employee on at

    Would you please share more details about the field type of the ID field in the Referrals table, by the way, what is your data source?

     

    You could take a try with the Value() or the Text() function to convert between string or number type.

    Depending on the ID type defined in the table, if it is a number type, then try:

    Distinct(Filter(Referrals,ID = value(Dropdown1.Selected.Value)),"Created By")

    Or for a text type:

    Distinct(Filter(Referrals,ID = text(Dropdown1.Selected.Value)),"Created By")

    Regards,

    Michael

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

News and Announcements

Welcome to the Power Platform Communities

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

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans