PowerApps - issue with LookUp function

(0) Share

Report

Posted on by SZ-23070748-0

Hi all, I have an issue with LookUp() function used in ForAll().
Currently I obtain the following result:

Instead, the expected result is:
A - A1
B - B1

Am I doing something wrong?

Please copy-paste the code below to a new button to test it:

ClearCollect(
 _col_ItemsToSearch,
 {
 lookup_name: "AP-24",
 result_name: "A"
 },
 {
 lookup_name: "AP-23",
 result_name: "B"
 }
);

ClearCollect(
 _col_WhereToSearch,
 {
 lookup_name: "AP-24",
 result_name: "A1"
 },
 {
 lookup_name: "AP-23",
 result_name: "B1"
 }
);

ClearCollect( 
 _test,
 ForAll(
 _col_ItemsToSearch,
 ThisRecord.result_name & " - " & LookUp( _col_WhereToSearch, lookup_name = ThisRecord.lookup_name, result_name )
 )
)

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Sergii24

please try this version:

ClearCollect( _col_ItemsToSearch, { lookup_name: "AP-24", result_name: "A" }, { lookup_name: "AP-23", result_name: "B" } ); ClearCollect( _col_WhereToSearch, { lookup_name: "AP-24", result_name: "A1" }, { lookup_name: "AP-23", result_name: "B1" } ); ClearCollect( _test, ForAll( _col_ItemsToSearch, Let( varCurrentRecord, ThisRecord, varLookupResult, LookUp(_col_WhereToSearch, lookup_name = varCurrentRecord.lookup_name), If( !IsBlank(varLookupResult), varCurrentRecord.result_name & " - " & varLookupResult.result_name, varCurrentRecord.result_name & " - Not Found" ) ) ) );

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
SZ-23070748-0 23 on at

Like
a
(0)

Report
Copy link

Link copied!

There are following errors:

It seems that use of Let() within ForAll() is incorrect...

Was this reply helpful? Yes No