Power Platform Community Forum Thread Details

Hello guys,

can someone help me with this error?

I'm using a code like this:

ForAll(Collection; Patch(table1;Lookup(excel; data1=data2)

{

test: "t"

}

)));;

Categories:

Building Power Apps

Hi @Cedric0404

What are the fields in "Collection", "table1", and "excel"? If any or all of these have field names "data1" or "data2", then Power Apps may get confused on which one is being referenced.

I am going to make the following assumptions:

"Collection" contains the field "data2"
"table1" and "excel" are set up with the same data structure. i.e. the fields are the same
"excel" contains the field "data1"
The field "test" exists in table1

If all of that is correct, then your formula should be something like:

ForAll(Collection As UniqueNameHere; 
	Patch(table1;LookUp(excel; data1=UniqueNameHere.data2);
	{
		test: "t"
	}

));

Notice the use of "As" to give "Collection" a name that can be referenced later to prevent Power Apps from getting confused in more than one data source contains the field "data2". Also notice that LookUp has the "U" capitalized as I don't think Power Apps will recognize "Lookup" as valid.

-Mark

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up.