Answered

ForAll working with manually filled collection but not with filtered Table

(0) Share

Report

Posted on by pingun

Hi,

the last statement is red underlined:

ClearCollect(colToSpooler; Filter(Gallery2.AllItems; Checkbox1.Checked));;
ClearCollect(uuu; { Ort: "Berlin" }; { Ort: "London" });;
ForAll(uuu; Patch(BK_Emailvalidierung_Spooler; Defaults(BK_Emailvalidierung_Spooler); { SpoolerName: "Oliver"; Startdatum: Today() }));;
ForAll(colToSpooler; Patch(BK_Emailvalidierung_Spooler; Defaults(BK_Emailvalidierung_Spooler); { SpoolerName: "Oliver"; Startdatum: Today() }));; // is marked red

ColToSpooler is shown corrrectly in an Gallery.

Why is ForAll(uuu ... working correctly and ForAll(colToSpooler ... is marked with a red line (and not working)?

Thanx

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @pingun ,

Assuming the fields in BK_Emailvalidierung_Spooler of SpoolerName is Text and Startdatum is a Date, I am not sure why it is invalid, however you are not patching anything from the gallery/collection.

Assuming for example SpoolerName exists in the gallery data, you can also do this

ForAll( Filter( Gallery2.AllItems; Checkbox1.Checked ) As aSpool; Patch( BK_Emailvalidierung_Spooler; Defaults(BK_Emailvalidierung_Spooler); { SpoolerName: aSpool.SpoolerName; Startdatum: Today() } ) );;

is this what you are trying to do?

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.

Was this reply helpful? Yes No
pingun on at

Like (0)

Report
Copy link

Link copied!

Hi@WarrenBelz,
thanks a lot! Is working.
To get it to work at all, I tried static data. Therefore I didn't need a reference to the contents. In the meantime I had also tried with "As"...
Therefore I have to make the detour over the Collections.
But why does the above example not work? Any idea?
I've tried it this way too, but without the "As". So I trid

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @pingun ,

I must admit I have never tried a ForAll Patch and then not used any of the output from the Items in the Patch, however when I think about it technically, it should work and simply post the number of new records that are in the dataset referenced, but in reality you would never do this.

The As statement is simply a very effective disambiguate tool and I only used it to demonstrate how to Patch a field when the name in both the source and target are the same. If the matching fields are named differently, you do not need it. You can still Patch the gallery contents directly.

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.

Was this reply helpful? Yes No