Answered

Patching Dataverse within ForAll as specified by a Collection

(0) Share

Report

Posted on by R_March

Hi all,

I'm having trouble with a Patch operation from within PowerApps and I hoped someone here could help me.

I have a collection (MyCollection) with a column containing an ID (CollectionID).
Using a ForAll loop, I'm trying to Patch a choice column ('My Parameter') in each record of a Dataverse Table(MyDataverseTable), where the column 'Dataverse ID' is equal to the CollectionID of the current item being iterated in MyCollection.

So, if the CollectionID of the current record is 1234, it should patch the 'My Parameter' column of the record with the 'Dataverse ID' of 1234.

I've tried permutations of things like:

ForAll(
	MyCollection,
	Patch(MyDataverseTable,
		LookUp(MyDataverseTable,
		'Dataverse ID' = Text( MyCollection[@Collection_ID] )
		),
	{'My Parameter':'My Parameter (MyDataverseTable)'.Yes}
	)
);

It seems however, that the CollectionID of the Collection record is not accessible inside the LookUp.
The code does not throw an error, it simply seems to do nothing.

What am I doing wrong here?

Thanks for any input!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

R_March on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Thanks for your suggestions. They both work, I took the first one for simplicity. However, what was also making things not work was the "Text(MyCollection.Collection_ID)" part of the formula, as it was not being delegated. As a workaround I added an extra column to my collection with the same ID in Text format, did the comparison then and now it works fine. Thanks once more!

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @R_March ,

Try the following code

ForAll( MyCollection, With( { CurrentRecord: LookUp(MyDataverseTable, 'Dataverse ID' = Text( ThisRecord[@Collection_ID] ) ) }, Patch( MyDataverseTable, CurrentRecord, { 'My Parameter':'My Parameter (MyDataverseTable)'.Yes } ) ) );

Hope this helps

Was this reply helpful? Yes No
Verified answer

scalca on at

Like (0)

Report
Copy link

Link copied!

what you can do is to add the As function into ForAll
so for example, ForAll(MyCollection As CollectionRecord, Patch(DataverseTable, LookUp(DataverseTable, Id = Text(CollectionRecord.Id))

the choice value must match value in your Dataverse Table where you can references directly the dataverse column in order to get the choice values

Was this reply helpful? Yes No