Populating choice field in form with another already submited choice

[kuglarz96]

Hi,

I created custom form app in powerapps

I'm using LookUp function to populate some new form fields with already submited forms. 

I have Dropdown1, which has all submited forms with their unique names.

In data fields in Default property i typed:

LookUp(MySharePointList, uniqueName = Dropdown1.Selected.uniqueName, SpecificColumnName)

It all works perfectly when I try to populate text fields, but it doesnt with choice, dropdown boxes. 

I understand that in choice powerapps expecting record values, not text, but i have no idea how to reach it.

Does anybody know the answer?

Thank you

[v-monli-msft]

Hi @kuglarz96 ,

Did you mean that SpecificColumnName in your formula is a choice column, and you want to put this formula in the Default property of this SpecificColumnName's data card? 

If so, then I just tested with the same formula that it seems that I cannot reproduce your issue. This formula works for me perfectly.

Or did I misunderstand anything? Please feel free to tell.

Regards,

Mona

[kuglarz96]

@v-monli-msft 

SpecificColumnName is choice type. It has three numbers for example 185, 251, 300.

On SpecificColumnName's properties I put formula 

Default:
LookUp(MySharePointList, uniqueName = Dropdown1.Selected.uniqueName, SpecificColumnName)

Items:
Choices(MySharePointList.SpecificColumnName)

When I'm making new form, by clicking " + New " on sharepoint list, on my data card first I have 

Then, I select the uniqueName on Dropdown1, and all my text fields update basen on what I chose in dropdown, but not choice data card. 

The point of app is that user should has two options of populate all fields - 1. type his own, new ones 2. base on already submited forms, and then correct some data if he wants to.