How to assemble a XML for Fetch Xml Query field dynamically?

(0) Share

Report

Posted on by helio1981

Let's suppose that my values come from a array, like: {'54','55','56'}

How can I dynamically assemble the xml below ( in the values tags )?

<fetch top='5'>
	<entity name="abc">
		<attribute name="abc1" />
		<attribute name="abc2" />
		<filter type="and">
		 <condition attribute="abc2" operator="in">
			<value>999-53</value>
			<value>999-55</value>
		 </condition>
		</filter>
 </entity>
</fetch>

Thank you in advance

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi, @helio1981

You can refer to this flow to generate the dynamic <value>:

item()

join(body('Select'),decodeUriComponent('%0A'))

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No