Unable to change the value of a variable inside ForAll

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following formula:-

Set(varXML,"");
ForAll(Colrow As _item,
varXML=varXML+
"<Item>
<ArticleInput type=""System.String"">"+_item.Article+"</ArticleInput>
<ArticleDescription type=""System.String"">"+_item.Description+"</ArticleDescription>
<ArticleReturnable type=""System.String"">"+_item.Returnable+"</ArticleReturnable>
<Qty type=""System.Double"">"+_item.Qty+"</Qty>
</Item>";
));

where i am trying to append the text of a variable named varXML inside ForAll, but i am getting an error on the "varXML=varXML".. any advice?

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohn123

ForAll is not a For Loop!! It is a function that returns a Table of records.

However, your formula needs the Concat function, not a loop.

Set(varXML, Concat(Colrow, "<Item> <ArticleInput type=""System.String"">" & Article & "</ArticleInput> <ArticleDescription type=""System.String"">" & Description & "</ArticleDescription> <ArticleReturnable type=""System.String"">" & Returnable & "</ArticleReturnable> <Qty type=""System.Double"">" & Qty & "</Qty> </Item>" ) )

I hope this is helpful for you.
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!
@Randy ok thanks now i tried this formula, to add pre & post text to the concat, as follow:-

Set(varXML,"<?xml version=""1.0"" encoding=""utf-8""?><RepeaterData><Version /><Items>"+Concat(Colrow, "<Item><ArticleInput type=""System.String"">" & Article & "</ArticleInput><ArticleDescription type=""System.String"">"&Description & "</ArticleDescription><ArticleReturnable type=""System.String"">" & Returnable & "</ArticleReturnable><Qty type=""System.Double"">" & Qty & "</Qty></Item>")+"</Items></RepeaterData>");

but i got incompatible type error
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohn123

Yes, you cannot add text to text. The plus (add) operator is only valid on numbers.

You need to use the ampersand character to join your text. You had this in your original post and I corrected it in the formula I provided.

So, with the new addition, the formula is:

Set(varXML, "<?xml version=""1.0"" encoding=""utf-8""?><RepeaterData><Version /><Items>" & Concat(Colrow, "<Item><ArticleInput type=""System.String"">" & Article & "</ArticleInput> <ArticleDescription type=""System.String"">" & Description & "</ArticleDescription> <ArticleReturnable type=""System.String"">" & Returnable & "</ArticleReturnable> <Qty type=""System.Double"">" & Qty & "</Qty></Item>" ) & "</Items></RepeaterData>" )

Take note of the & character and not the +