web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages execute liquid array f...

Power Pages

Unanswered

execute liquid array filters on fetchxml results.

(0) Share

Report

Report

Posted on by MichielVanduren

20

hi,

is it possible to execute liquid array filters on fetchxml results ?

For example I have this fetchxml query :

{% fetchxml fetchSoldTo %}

<fetch>

<entity name="pre_contactaccountmapping">

<attribute name="pre_visible" />

<attribute name="pre_contactaccountmappingid" />

<attribute name="pre_portalcontactfrom" />

<filter>

<condition attribute="pre_portalcontact" operator="eq" value="{{ user.id }}" />

</filter>

<link-entity name="account" from="accountid" to="pre_itemssoldtoaccount" alias="acc">

<attribute name="accountid" />

<attribute name="name" />

<attribute name="accountnumber" />

<attribute name="address1_city" />

<order attribute="accountid" />

<link-entity name="pre_country" from="pre_countryid" to="pre_countryid" alias="ctry">

<attribute name="pre_name" />

<attribute name="pre_countrycode" />

</link-entity>

</link-entity>

</entity>

</fetch>

{% endfetchxml %}

I need the results of this query but I want to reuse this query to get the number of unique pre_portalcontactfrom values,

so I try :

{% assign uniqueContactsFrom = fetchSoldTo.results.entities | group_by: 'pre_portalcontactfrom' %}

and use {{ uniqueContactsFrom.size }} but this gives not the right result.

or can I use a where condition to get a specific record?, ex :

{% assign myContact = fetchSoldTo.results.entities | where: 'pre_portalcontactfrom', '11111111111111111111' %}

I try to use these liquid array filters, but doesn't seem to work :
https://learn.microsoft.com/en-us/power-apps/maker/portals/liquid/liquid-filters#array-filters

Categories:

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro - Series II

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#2

omkarsupreme 24

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans