Getting value out of database when filling a textbox in

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I am going to ask a question about this section of my application: https://gyazo.com/58300f12fbca4455e5e8511a52241d44

Basically what I want to do is:

The user fills in the tekeningnummer, whenever this is filled in, I want it to be looked up inside of my database. https://gyazo.com/d70e398140c75aba9d29bd0d66d7b983

The database looks like that ^ the bestandsname is the tekeningnummer. So basically whenever the tekeningnummer is filled in, I want it to automatically make a connection between the row with the tekeningnummer in my database. So let's say someone fills in the second tekeningnummer inside of my database (19030-12_0402). I want to have a textfield that has the product_usage that comes with it (400-E-M; rubber EPDM). How can I do this?

I have tried this formula but sadly can't get it to work. I am able to do this with a dropdown box but not with this formula:

Distinct(Filter(Tabel4, Bestandsnaam=DataCardValue12.Text),Product_usage)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

Try changing your formula to the following:

Lookup(Tabel4, Bestandsnaam=DataCardValue12.Text, Product_usage)

That should give you what you are looking for.

I hope this is helpful for you.

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

Like (1)

Report
Copy link

Link copied!

Worked, thank you!

Was this reply helpful? Yes No