cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kuglarz96
Frequent Visitor

Populating choice field in form with another already submited choice

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

 

 

2 REPLIES 2
v-monli-msft
Community Support
Community Support

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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 

2019-09-04_10-45-12.png

 

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.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,991)