Answered

Need help with Multiple Updates in a collection

(0) Share

Report

Posted on by becca51180

What is the best way to update a collection with data that a person has entered form multiple input boxes. The below formula is not working

UpdateIf(CommentaryUpdates,Reviewer = LedgertAcctGallery.Selected.Reviewer && MajorName = LedgertAcctGallery.Selected.MajorName,

{RootCause: RootCause_Text.Text,
 ActionPlan: ActionPlanIP.Text,
 OutsideControl: YesNoRadio_2.Selected.Value,
 Outside_Explanation: TeamsControl_IP.Text,
 ResolutionPrediction:ResolveCombobox_2.SelectedItems.Value,
 ResolutionExplain: NotSure_Comment.Text,
 DateUpdated:Today())};

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

becca51180 55 on at

Like
a
(0)

Report
Copy link

Link copied!
I figured it out. I used a ForAll to make it work

ForAll(AccountInfo_2.AllItems, UpdateIf( CommentaryUpdates, Reviewer = ThisItem.Reviewer, {DateUpdated: Today(), RootCause: Var_Root, ActionPlan: Var_Action, OutsideControl: Var_YesNoResoltion, ResolutionExplain: Var_Resolved_Explain, ResolutionPrediction: Var_Resolution_Selection, Outside_Explanation: Var_ControlExplain} ) );

Was this reply helpful? Yes No
alrezac Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your follow up post. I am glad you were able to get this solved! Hopefully this will prove useful to future communities users.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No