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?
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.
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.