Result command not recognized with Split command with ForAll

(0) Share

Report

Posted on by TJJones

I am attempting to patch a canvas Dataverse table named SBin_Inventories using the following command:

ForAll(
 Split(SCont_Bins, ","),
 Patch(
 SBin_Inventories,
 Defaults(SBin_Inventories),
 {S_Bin: Trim(Result)}
 )
)

This gives the error that 'Result' isn't recognized. I've tried various combinations of code, using a collection, etc., but it always gives the same error.

The SCont_Bins field is a text field that was populated by a Multi-Select Combobox. The S_Bin field is also a text field.

I can replace Trim(Result) with "Test" and it will create a unique record for however many split values are in the SCont_Bins field.

All documentation I find shows this should work. Bing Chat gave me various code snippets to try, but the issue is always the same. It is like this function is not supported.

If anyone has some advice, I would appreciate it.

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@TJJones , could you try:

Patch( SBin_Inventories, ForAll( Split( SCont_Bins, "," ), {S_Bin: Value} ) )
TJJones 37 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe that works! Thanks!
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

The Split function returns a single column table called "Value", not "Result". Also, avoid preceding a Patch function with a ForAll function. While it is valid, it is inefficient.

Also please remember to accept the solution.