Answered

ForAll does not work properly.

(0) Share

Report

Posted on by aytactaskiran

Hi everyone,

I am creating a work order for the logistics department, the codes I wrote are below. These codes were working properly but not they don't.

First I created the collection for the toggle tool, with this transition one or more rows can be selected. After selecting one or more rows, the corresponding columns become "true" in the collection.

Then, after clicking the "create work order" button, the rows controlled by toggle in sql db become "true".

These codes were working fine before. But now it is not working properly. That is, after clicking the "create work order" button. The value of each row does not convert to the "true " value. Some values become true but some do not.

I couldn't find a way to fix it.

Thanks in advance to all of you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @aytactaskiran ,

You can improve the efficiency of your code speed-wise as below (Patch the table instead of looping through it)

With( { wList: Filter( isEmri01ustur4; malSecim ) }; Patch( MEksikMalzeme; ForAll( wList As aPatch; {makineSase: aPatch.makineSase}; { drm: true; isemriOlusturmaTarihi: Now() } ) ) );;

but are you saying the field drm in MEksikMalzeme is not being changed to true?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
aytactaskiran 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Thank you for your reply, I will use your method.

But as you mentioned, field drm is not changed to true.
I have more than one record which has same "makineSase" I want to change all of them to true value. But only first record is changed to true value

Was this reply helpful? Yes No
WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aytactaskiran ,

That is strange - if you put this on a button

ClearCollect( colTest, Filter( isEmri01ustur4; malSecim ) )

then View > Collections > colTest, do you see the records (the first 5 at least) you want updated?

Was this reply helpful? Yes No
aytactaskiran 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Yes I can see the records. But It is not changed to true after run codes above. If you want to see them I can send screenshots

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@aytactaskiran ,

Is makineSase a unique identifier for the record ? If not try this

With( { wList: Filter( isEmri01ustur4; malSecim ) }; ForAll( wList As aUpdate; UpdateIf( MEksikMalzeme; makineSase = aUpdate.makineSase; { drm: true; isemriOlusturmaTarihi: Now() } ) ) );;

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
aytactaskiran 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much @WarrenBelz 🙂

Was this reply helpful? Yes No