Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter formula for global variable

(0) ShareShare
ReportReport
Posted on by 72

For my item description box, I would like to filter the descriptions depending on the commodity that was chosen. The current box for the commodity is datacardvalue9. This is the current formula I use

Filter ('Conditioning Tool 2', Commodity = DataCardValue9.Selected.Result). It is not working. Although, a dropdown box is in the commodity section. A global variable is used to select the correct commodity depending on the button used to get to the edit screen. Is this why the formula is not working? If so, how do I fix the issue?

Categories:
  • CU06111240-0 Profile Picture
    CU06111240-0 72 on at
    Re: Filter formula for global variable

    Thank you!!

  • Verified answer
    Ramole Profile Picture
    Ramole on at
    Re: Filter formula for global variable

    Hi @tchamb2 
    Is this what you looking to? please check the sample app i have made created for you 2 ways to accomplish 

    2436840e.JPG

    2436840e2.JPG

    2436840e3.JPG

     

  • CU06111240-0 Profile Picture
    CU06111240-0 72 on at
    Re: Filter formula for global variable

    I want the item descriptions that pop up to match the commodity selected. See how avocados is the commodity, however it starts with pears. 

    tchamb2_0-1699100439373.png

    The formula I used for the commodity was this: 

    tchamb2_1-1699100503080.png

  • Ramole Profile Picture
    Ramole on at
    Re: Filter formula for global variable

    Hi @tchamb2 
    Please share screenshot what are you trying to accomplish 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard