Values based on the text box

[Anonymous]

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 

[eka24]

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.

[v-qiaqi-msft]

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 

[Anonymous]

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.

[eka24 · Accepted solution]

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.