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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Filter Criteria in Ite...
Power Pages
Unanswered

Filter Criteria in Item Actions not working.

(0) ShareShare
ReportReport
Posted on by 24

I have a filter criteria on the Item Actions. I only want to show the edit button when the records meet a particular criteria. But I see the Edit action for all the records. This is my filter criteria I am using.

 

<fetch version="1.0" mapping="logical" distinct="true" >
<entity name="edm_travelrequest">
<filter>
<condition attribute="edm_requeststatus" operator="in" value="">
<value>784940001</value>
<value>784940005</value>
</condition>
</filter>
</entity>
</fetch>

Categories:
I have the same question (0)
  • Fubar Profile Picture
    8,338 Super User 2025 Season 2 on at

    Try getting rid of the value="" inside the Condition tag.

    Also, depending on where you are applying the filter you may not need the whole FetchXML e.g. for a List you only need the filter tags and its contents.

  • jothivels Profile Picture
    24 on at

    That did not seem to help either. This is what I have . 

     

    jothivels_0-1664231032953.png

     

  • ragavanrajan Profile Picture
    7,044 Most Valuable Professional on at

    Hi @jothivels 

    I am not sure you have any link entities. But please give it a try. Sample below 

     <filter type='and'>
     <condition attribute='replace attribute name' operator='eq'/>
     </filter>
    

     

     

    Hope it helps. 
    ------------

    If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

  • jothivels Profile Picture
    24 on at

    @ragavanrajan  This did not fix the issue either.

  • Fubar Profile Picture
    8,338 Super User 2025 Season 2 on at

    Have you are cleared the Portals' cache (<portalurl>/_services/about when logged in as a user with the Administrators web role assigned  or syncing) - as these types of changes will not push up to the portal immediately so you usual force it .

  • Verified answer
    GeraldGut Profile Picture
    92 on at

    Hi jothivels,

     

    have you tried the fetchXML within Advanced find or XrmToolbox - FetchXML Tester? 

    Are there records returned?

     

    Did you try to use the complete fetchXML within the filter field?

    Not really sure, but in my entitylists - actions the filter field accept complete fetchXML.

     

    Best regards,

    Gerald

     

  • jothivels Profile Picture
    24 on at

    Thank you all for your help . I was able to get it to work using the following after testing with  XRM toolbox Fetch XML Tester. 

    <fetch>
    <entity name="edm_travelrequest" >
    <filter type="and" >
    <condition attribute="edm_requeststatus" operator="in" >
    <value>784940000</value>
    <value>784940001</value>
    <value>784940005</value>
    <value>784940006</value>
    </condition>
    </filter>
    </entity>
    </fetch>

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 71

#2
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard