Skip to main content

Notifications

Community site session details

Community site session details

Session Id : BF4pqJ0Fa7LZSr/Iq71Wl9
Power Apps - Building Power Apps
Unanswered

Filter dropdown based on variable

Like (0) ShareShare
ReportReport
Posted on 9 May 2022 23:27:52 by 134

Hello,

 

I have a dropdown that I need to populate based on a variable. For instance, when I'm in the edit form I need the dropdown to display all of the objectives that start with "3." if the variable name varID is set to 3. If varID is set to "5" then it displays all objectives that start with "5.", etc. Any help would be appreciated.

Categories:
  • ChrisS81 Profile Picture
    134 on 10 May 2022 at 10:33:39
    Re: Filter dropdown based on variable

    @Drrickryp  "Objectives" in the "Form-Test" list is actually a Lookup column from another List called "Objectives". It's pulling over the title field from the objectives list and it displays the values 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, etc. 

     

    Sorry I didn't make that clear in the beginning.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on 10 May 2022 at 00:46:48
    Re: Filter dropdown based on variable

    @ChrisS81 

    What type of column is objectives?

  • ChrisS81 Profile Picture
    134 on 10 May 2022 at 00:07:28
    Re: Filter dropdown based on variable

    @Drrickryp thanks for the reply. I'm getting 2 errors:

    ChrisS81_0-1652141106102.png

    and

    ChrisS81_1-1652141168254.png

    I'm writing:

    ChrisS81_2-1652141235976.png

     

     

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on 09 May 2022 at 23:42:13
    Re: Filter dropdown based on variable

    @ChrisS81 

    The Items property of the dropdown should be Filter(splist, StartsWith(Objectives, varID))

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard
Loading started