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 / Filter Choices with Co...
Power Apps
Answered

Filter Choices with Collection content

(0) ShareShare
ReportReport
Posted on by 364 Moderator

Hello, 

I try to filter a Choices content with the result of a single column of a collection. I'm surely close to the goal but something bugs. 

 

The result of that filtering ends up in the Items property of a Combobox (single value selection only). 

Individually, the Cjoices and the collection return the values expected. 

 

PierreCA_0-1706902829307.png

 

PierreCA_1-1706903159658.png

 

Categories:
  • cha_cha Profile Picture
    4,932 Moderator on at

    Hello @PierreCA 

     

    It looks like your collClientActif_EntiteDonee doesnt have a column named "ID". Maybe try "Id"?

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @PierreCA,

    What is clientTrouve, an boolean variable?

    Could you please post the error message in English?

     

    I assume that Client is a LookUp column in Communiquer, you want to filter the choice in a single text column, right?

    If so, you need to compare the Id paramater from the client column with the ID paramater from the collection directly, try to modify as below:

    vqiaqimsft_0-1707095863836.png

     

  • Verified answer
    PierreCA Profile Picture
    364 Moderator on at

    Hello @v-qiaqi-msft ,

     

    About the error message displays, unfortunately I don't have the control on the language used. 

     

    You're right in your analysis about what I'm trying to do.

     

    @cha_cha , I double check and made sure the collection column name is  ID.

     

    I've try your proposition, @v-qiaqi-msft , but something is still missing. 

     

    The error message says: Impossible to convert that type of data. Power Apps cannot convert that Number into UntypedObject

     

    There's a kind of missmatch, but I cannot know it's nature

     

    PierreCA_0-1707141606841.png

     

    But when I look at the content of the collection alone, it looks empty but my query return two records. And it says  that the column contains a data without type.

    PierreCA_0-1707150286598.png

     

     

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard