Answered

Comma Separate the Fetch XML Output and assign the output to a liquid variable

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Experts,

I have a fetch XML query that gives the list of available organization in the CDS entity. I need to list all the organizations using the fetch XML and separate the fetch XML output using a comma and then assign it to a liquid variable.

My fetch XML query is as below,

{% fetchxml my_query %}

</filter>

</entity>

</fetch>

{% endfetchxml %}

{% for result in my_query.results.entities %}

{% assign org = result.organization_entity | join: "," %}

{% endfor %}

In this case I get the output as:

T, e, s, t, , C, o, m, p, a, n, y, , 1T, e, s, t, , C, o, m, p, a, n, y, , 2

I want to get the output as Test Company 1, Test Company 2. and then assign it to a liquid variable. Could anyone please help me on achieving this..

Your help is greatly appreciated.

Thank you

Categories:

Power Apps portals

All responses (3)

Answers (1)

Sort by

oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi, I think you are missing your "name" attribute there. But don't think that's the issue.

I don't think you need the | join filter there.

In your loop try something like this:

{% for result in my_query.results.entities %} result.organization_entity{% unless forloop.last %},{% endunless %} {% endfor %}
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OliverRodrigues ,
Thank you for your reply.. Could you please let me know how the comma separated value can be assigned to a variable as I need to use that variable again in my code..
Your help is greatly appreciated.
Thank you!
Verified answer

oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi you should be able to use the capture Liquid tag:

{% capture my_variable %} {% for result in my_query.results.entities %} {{ result.organization_entity }}{% unless forloop.last %},{% endunless %} {% endfor %} {% endcapture %} my_variable --> {{ my_variable }}