How to trigger text control lookup autofill? non-test property

(0) Share

Report

Posted on by Ginko

221

I have the below function that is throwing up an error I do not understand how to solve.

SetProperty(DataCardValue20_4.Text, LookUp(REQLINES,ITEM=Value(DataCardValue30_4.Text), DESCRIPTION))

The intent of this function is to fill OnSelect of a button the DataCardValue20_4.text with DESCRIPTION from REQLINES data source if DataCardValue30_4.text matches an ITEM number from the same REQLINES table. Basically trying to create an autofill button for my form if the data already resides on REQLINES table, where ITEM is my comparison value to create the data match.

What function should I be using instead of SetProperty, or others adjustments to enable this lookup & autofill?

Thanks in advance for any advice!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not a user of forms, but I would use a label and its Default property.

Something like a button with a OnSelect of Set(varMyLookUp, LookUp(DataSource, Record)) and the label's Default would just be varMyLookUp.AnyField

Regards.

Was this reply helpful? Yes No
Ginko 221 on at

Like (1)

Report
Copy link

Link copied!
This works, so much easier than expected too! My below function also works in real-time I just had the ITEM number used in testing typed wrong haha
If(EditForm1_5.Mode=FormMode.New,LookUp(REQLINES,ITEM=DataCardValue30_4.Text,DESCRIPTION))
Thank you!

Was this reply helpful? Yes No