web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch ForAll Combobox ...

Power Apps

Answered

Patch ForAll Combobox Items

(0) Share

Report

Report

Posted on by luisep

105

Hi all,

I have a problem when I try to execute the patch function in a ForAll.
My scenario:

SP List1:
ColumnTask
Column Owner (user)

I've created a gallery with a combobox to select the users.
Finally on the button to run the patch:

ClearCollect(Col_SPList1;Gallery_SPList1.AllItems),

ForAll(Col_SPList1,
Patch(SPList1,
{'Owner':ComboBox1.Selected}))

The problem is that the user in the Owner column in SP is not updated.
If someone can help me with this problem.

KR

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@luisep

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. It is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as designed and intended and will provide better performance.

That aside, your issue is related to the Items property of your combobox - what is the Items property?

Was this reply helpful? Yes No
luisep 105 on at

Like (0)

Report

Thanks for your reply @RandyHayes,

The Items property of my combobox is: Choices([@'SPList1'].'Owner')

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@luisep

Very good, then your formula should be:

Patch(SPList1, ForAll(Gallery_SPList1.AllItems, {ID: ID, 'Owner':ComboBox1.Selected} ) )

Was this reply helpful? Yes No

Join the conversation