web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps change textbox based o...

Power Apps

Answered

change textbox based on lookup result

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

What I have:

I have 2 textboxes on a screen. i'm trying to change the values in the textboxes based on the result of the lookup text

Looking into sql server table:

if RBK_FVP.Text = LOOKUP_EMAIL_ADDRESS in the sql table then

make RBK_FVP.Text= RBK_RSVP.Text

else

RBK_FVP.Text = RBK_FVP.Text

being fired off from a onChange event in another textbox :

If(!IsBlank(
LookUp(
t_escalation_email_exceptions,
RBK_FVP.Text = LOOKUP_EMAIL_ADDRESS
)),
RBK_FVP.Text= RBK_RSVP.Text,
RBK_FVP.Text = RBK_FVP.Text)

Thanks

dave

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

In PowerApps you cannot assign values to controls like you are trying. PowerApps derives its property values based on Formulas. It is very much like Excel in that cells have formulas in them that reference other cells and formula.

So, for what you need, you will be focused on the Default property of the RBK_FVP control.

Unfortunately what you are asking for creates a circular reference, so you will need to employ an behavioral action and a variable for this.

Set the formula in the OnChange action of the control to:

UpdateContext({newVal: If( LookUp(t_escalation_email_exceptions, LOOKUP_EMAIL_ADDRESS=Self.Text, true), RBK_RSVP.Text, Blank() ) })

Then change your Default property of the textinput control to:

If(!IsBlank(newVal), newVal)

I would also recommend turning the DelayOutput property to true so that your app doesn't fire off a lot of lookups as you type in the control.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

worked great randy

Was this reply helpful? Yes No

Join the conversation