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
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
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.
User | Count |
---|---|
164 | |
96 | |
78 | |
73 | |
59 |
User | Count |
---|---|
209 | |
167 | |
98 | |
93 | |
79 |