Unanswered

How to find a record based on a number or string value

(0) Share

Report

Posted on by kiro7shiro

What's wring with this "code":

UpdateContext(
 {
 Code: RandBetween(
 1;
 3
 )
 }
);;
UpdateContext(
 {
 SavedName: LookUp(
 Items;
 ThisRecord.Code = Code;
 Name
 )
 }
);;

I have an excel table with three items in it named: "Items". I want to search for the "Code" column and than save the "Name" property of this record in a second var. Why is the above not working? Because the "SavedName" variable is always the first name of the table.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Hi @kiro7shiro,

My guess is that PowerApps gets confused when you use the same names. Can you try the following?

UpdateContext( { RandomCode: RandBetween( 1; 3 ) } );; UpdateContext( { SavedName: LookUp( Items; Items[@Code] = RandomCode; //Code = RandomCode should also work I guess Name ) } );;

Was this reply helpful? Yes No
kiro7shiro 25 on at

Like (0)

Report

My guess is powerapps confuses a lot of things. Especially since those two variables should not interfer with another. Because they are declared in an entire seperate context. One on the table and the other in the app context. Very wierd. Again! 😉

Was this reply helpful? Yes No