Values based on the text box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am creating a canvas,

I have used a text box for a question .

for answers I have created a dropdown.

User need to know the what was the answer he had given last time. I have those values in my excel.

I want previous year answer to be automatically picked from excel based on the question which is there is the text box?

Is this possible to achieve ?

Please help me

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

In the Default of another Textbox, put;
LookUp(Table1, Question=Dropdown1.Selected.Value,Answer)
Or
LookUp(Table1, Question=Dropdown1.Selected.Question,Answer)
If you have issues, give a screenshot of the excel table.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@raks3,
Could you please share more details about your scenario?
It will be appreciated if you can post a screenshot about your excel table.
Do you want to populate the Dropdown with the corresponding question in the text box?
I have a test on my side, please take a try as below.
Set the Items property of the DropDown as below.

Filter(Table2,Question=TextInput1.Text).Answer

You can check the GIF for reference.
Best Regards,
Qi

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

Like (0)

Report
Copy link

Link copied!

Question Previous Year Score Current Year Score
AAAA 5
BBBB 4
CCCC 2

I have question in my canvas those questions in a box and I want to my previous year score to be printed automatically.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

What you need is the reply I provided. Did you try it. What is the name of your table.

Assuming your Dropdown1 items is:
Table1.Question where you would be selecting the questions,

In the Default of another Textbox, put;
LookUp(Table1, Question=Dropdown1.Selected.Value, Previous Year Score')
Or
LookUp(Table1, Question=Dropdown1.Selected.Question, 'Previous Year Score')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No