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

Announcements

Agent Academy Hackathon is happening now!
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 / Need to return value f...
Power Apps
Answered

Need to return value from a column while filtering through another column

(0) ShareShare
ReportReport
Posted on by thonne03 12

I have a table wherein I will filter using a column with unique values and will return the value of another column.  I can't seem to make it work.  Here's the syntax:

 

(Filter(promo_volume2_ncrs, Concatenate3 = ConcatenateLevels_1.Text), Volume_CS)

 

The table is promo_volume2_ncrs

The column with unique values is Concatenate3.  I'm referencing it vs. a calculated field outside of the table. 

The column that I need the value is Volume_CS

 

Thank you in advance.

Categories:
Building Power Apps
I have the same question (0)
  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @thonne03 ,

     

    Please try below formula:

    Filter(promo_volume2_ncrs, Concatenate3 = ConcatenateLevels_1.Text).Volume_CS

     

    Best regards,

  • thonne03 Profile Picture
    thonne03 12 on at

    Hello,

     

    I tried the formula and it still has error.

     

    thonne03_0-1690773155803.png

     

  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @thonne03 ,

     

    What's your data source and what's the column type of Volume_CS?

     

    Best regards,

  • thonne03 Profile Picture
    thonne03 12 on at

    Hello.

     

    Data source is promo_volume2_ncrs.

    Volume_CS is numeric.

     

    Although it's weird.  The source table doesn't have values.  It's just 75K+ rows.

  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @thonne03 ,

     

    Where are you using this formula, on which control? Besides, could you please double check the column name? See if the column is in the suggestions dropdown list when input dot after the Filter function

    Filter(promo_volume2_ncrs, Concatenate3 = ConcatenateLevels_1.Text).

     

    Best regards,

  • thonne03 Profile Picture
    thonne03 12 on at

    Hello,

     

    ConcatenateLevels_1 is an input text I created to concatenate the selected values from several dropdown lists that users will answer.

     

    When I input the dot after the filter function, nothing appears.  Column name is really Volume_CS

  • v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @thonne03 ,

     

    OK, there would not be columns prompt in suggestions list now. But you can know the columns when having the filter function only:

    vjefferni_0-1690774966093.png

     

    My data source is SharePoint list, and the Filter is on Items of Gallery control. Please share the info of your case.

     

    Best regards,

  • thonne03 Profile Picture
    thonne03 12 on at

    Hello,

     

    My data source, promo_volume2_ncrs, is an Excel table that I uploaded.

    I will be filtering through Concatenate3 column.  This is a column with unique values. 

    I will use the TextInput ConcatenateLevels_1 to filter Concatenate3.  It's an TextInput that is a concatenated values of 6 drop-down lists that users will have to select (I used the concatenate formula here)

     

    By filtering Concatenate3 = ConcatenateLevels_1, since it's unique, it should return only 1 value of Volume_CS, a column which is also in the promo_volume2_ncrs data source.  This is what I want to be reflected in this TextInput field I'm creating.

     

    Hope this helps.

     

    Thank you.

  • Verified answer
    v-jefferni Profile Picture
    v-jefferni Microsoft Employee on at

    Hi @thonne03 ,

     

    If you are using the formula for a Text input box, then it'll be better using below formula：

     

    LookUp(promo_volume2_ncrs, Concatenate3 = ConcatenateLevels_1.Text, Volume_CS)

     

     

    Filter function returns a table as result, which could not be used in a Text input box that only accepts text type values. 

     

    Best regards,

  • thonne03 Profile Picture
    thonne03 12 on at

    Thanks!  It works fine now. 

     

    But when it's returning empty value.  When I checked the source table (I extracted it back to to Excel), the downloaded data shows 0 rows.  I uploaded an Excel file of about 75K+ rows.

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

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 893

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 482

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