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 Pages / Metadata filter for list
Power Pages
Suggested Answer

Metadata filter for list

(0) ShareShare
ReportReport
Posted on by 3
I need a more advanced Metadata filter for a list.
The "Dynamic Lookup Set" is fine, but I need to filter on some user-permissions that are not directly related to the list or related tables.
It is possible for me to make my own Lookup Set as a dropdown with Liquid and fetchxml, but is it possible to make this dropdown interact with the list...?
Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at
    Hi
     
    Could you please explain with an example? Looks like you need custom JScript to do this.
     
    Thanks
  • Suggested answer
    CU23101439-0 Profile Picture
    3 on at
    I actually solved it - with javascript :-)
    Added FetchXml and Liquid to the page in order to inject a JSON object embedded in a script tag.
    Then, with Jquery, it is easy to clear the filter-dropdown and insert the options that I want.
    Not the most beautiful solution, but it works OK.
  • Suggested answer
    SaiRT14 Profile Picture
    1,990 Super User 2025 Season 1 on at
    try the below:
    {% assign fetchxml = "<fetch mapping='logical' distinct='true'><entity name='account'><attribute name='name'/></entity></fetch>" %}
    {% assign accounts = fetchxml fetchxml %}
    <select id="custom-filter">
        <option value="">Select an Account</option>
        {% for account in accounts.entities %}
            <option value="{{ account.id }}">{{ account.name }}</option>
        {% endfor %}
    </select>
     

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

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!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 21 Super User 2026 Season 1

#2
CN-06091549-0 Profile Picture

CN-06091549-0 18

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 17 Most Valuable Professional

Last 30 days Overall leaderboard