Patch with ForAll? How to use?

[simms7400]

Hi Guys -

I have the following Patch logic on one of my forms and it's working fine:

If(
	AssetEditForm.Mode <> New,
		Patch(
			rdInvestments,
			LookUp(rdInvestments,CompoundCode=DataCardValue53.Text),
			{CompoundAlias:DataCardValue54.Text}
		)
)

However, I"m running into an issue where if there are multiple of the same values (DataCardValue53.Text) in my SP list i am patching TO, it only does the first instance it finds. How do I modify this command to ensure it patches all instances?

Thank you!

[PowerAddict · Accepted solution]

Try something like this:

Patch(rdInvestments, Filter(rdInvestments,CompoundCode=DataCardValue53.Text), ForAll(Filter(rdInvestments,CompoundCode=DataCardValue53.Text),
{CompoundAlias:DataCardValue54.Text}))

Let me know if this works for you.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[iAm_ManCat]

You could try creating an invisible gallery, that is filtered to only contain items where

Filter(rdInvestments,CompoundCode=DataCardValue53.Text)

Then you can run a ForAll against FilteredInvestmentsGalleryName.AllItems

There are of course other ways to do it, I like this way so that I can unhide the gallery and check the content if I feel like there's something wrong with the way its filtering (in more complex cases)

Cheers,

ManCat

[simms7400]

@PowerAddict   That worked great, thank you!!!

@iAm_ManCat  That is a great idea, thank you.  I will try that approach as well. I like the idea of being able to see the elements that will be affected.

Thank you, both!!!