Answered

Assistance Needed with ForAll Function in Power Apps

(1) Share

Report

Posted on by CU01100710-1

Hi [Recipient's Name],

I hope this message finds you well. I’m currently working on a Power Apps project where I have a gallery that displays certain records. I have a Patch function that works perfectly on its own:

Patch(

ETP_CAP_AAF,

LookUp(

ETP_CAP_AAF,

Email = User().Email && Date = SelectedDate && CAP = CAP_2.Text

),

{'Nombre d''ETP': Value(TextInput1.Text)}

)

However, I'm struggling to incorporate a ForAll function to iterate through the items in the gallery while using this Patch function. I would appreciate any guidance or suggestions on how to implement this effectively.

Thank you for your help!

Best regards,

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Nandit 1,568 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi

Try to use the following formula, it should work -

ForAll( GalleryName.AllItems as Item, Patch( ETP_CAP_AAF, LookUp( ETP_CAP_AAF, Email = User().Email && Date = Item.Date && CAP = Item.CAP ), {'Nombre d''ETP': Value(Item.TextInput1.Text)} ))

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
CU01100710-1 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Nandit,

I wanted to take a moment to sincerely thank you for your prompt and detailed response to my question. Your suggestion gave me the perfect direction, and after making a few adjustments, I was able to implement a solution successfully.

I’m grateful for the support!

Best regards,

Was this reply helpful? Yes No