Help with lookup

[Lefty]

Hi

Struggling with the syntax i think

I want to be able to write on a single line text field, the value of a dropdown, i know there is a long way of doing this by creating a variable on the screens OnVisible and then referencing that for this datacard, but as my data will be written to SPO and this field I want to pick up the value which is in a column in SPO

I thought something like this would work, but doesnt:

LookUp(ListName.ColumnName.Selected.value)

Or:

LookUp(Choices(ListName.ColumnName.Selected.Value)

Simply want to get the value from this columname to be displayed in the datacard, Thanks in advance

[mdevaney]

@Lefty 

Can you please give an example?  Share a screenshot of your app and another screenshot of the data you want to pull.

[Lefty]

@mdevaney 

Apologies, I probably didnt explain properly

I have choice column "Approved" or "Rejected" the column name in SPO is Status

I want on another screen, after the item is submitted to pre-populate Approved or Rejected into a single line text field, so i can make the datacard displaymode disabled

Hope this explains a bit better?

[mdevaney]

@Lefty 

Is the dropdown in your PowerApp and do you want to put the value showing in the dropdown into a Text field?  To do this put the following code in the Default property of Text Input.

Dropdown1.Selected.Value

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Lefty]

HI @mdevaney 

Yes, I can do it like that, and yes the dropdown is in my app, but the dropdown is on another screen, so ideally i didnt not want to ref it from another screen due to slowness issues.

I thought I could do some sort of lookup to obtain the field value, otherwise I can create a variable on the screen by setting the variable by using OnVisible property of that screen and then referencing it on the screen Ii have my datacard, as mentioned I thought I could just do a lookup to obtain the value from SPO?

[mdevaney · Accepted solution]

@Lefty 

If the dropdown value is on another screen and you don't want to reference from there you should create a variable and refer to that instead.  Put this code in the OnChange property of your dropdown.

Set(currentDropdownValue, Dropdown1.Selected.Value)

Now you can use the value anywhere on your next screen.

currentDropdownValue

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Lefty]

@mdevaney 

Thanks didn't know you could do it like that also and it works - need to figure out how I do a N/A if that screen is to be kept empty, if the reviewer is for that screen is empty thus the field would be empty