Hi all.
I'm building a powerapp for assortment planning and hit a problem with a dropdown in a Form component.
Based on a table in Dataverse, I added a column of type Choices, referencing a choice table which I added in powerapp GUI.
This works fine so far when using the GUI for editing the data.
Now for my powerapp, I show a dropdown on a screen with a form connected to the table from dataverse. The field shows all options from the choices and I'm able to select different options. After saving the data (by submitting the form) they show up as they should in dataverse.
Now for the problem: If I now enter my screen with the form again, all fields are filled with the appropriate fields from the dataverse - except the combobox for the choices-column!
Form before submit:
Data in dataverse:
Form when called again (all previously modified data is set up correctly, except the choice field):
Am I overlooking something??
Best regards,
Alexander
Solved! Go to Solution.
Solved the issue!
In my screen with the data table, I did not include the column with the Targeting Group (Zielgruppe). So when navigating to the edit screen the form's item was set to table.Selected. However, this did not contain the data of the column Zielgruppe.
Because I have a very broad table with over 100 columns, I cannot display them all on the data table screen. I did it differently like this:
EditForm(frmEditGeneral);;
Set(gblSelected; LookUp(Sortimente;Sortiment=tblBrowseSortiment.Selected.Sortiment));;
Navigate('Edit Detail Screen';ScreenTransition.None);;
where the Column 'Sortiment' is the GUID of the row. The Item of the form element is then set to gblSelected.
This does the trick!
Best regards,
Alexander
Hello @Sahlex,
Hope in DataVerse environment it is CHOICES field not CHOICE field. Because as per the screenshot I can see you are selecting Multiple values.
Make sure the Default items you are refering to the DataVerse Choice field.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hi Ram Prakash,
The field in DataVerse is clearly CHOICES, which is intentional.
The field setup is auto-generated by powerapps when I add the field to the form so I expect it to work. The DefaultSelectedItems is referring to Parent.Default which itself is set to ThisItem.Zielgruppe.
ThisItem is initialized with a Selected (row) from a table.
Best regards,
Alexander
Solved the issue!
In my screen with the data table, I did not include the column with the Targeting Group (Zielgruppe). So when navigating to the edit screen the form's item was set to table.Selected. However, this did not contain the data of the column Zielgruppe.
Because I have a very broad table with over 100 columns, I cannot display them all on the data table screen. I did it differently like this:
EditForm(frmEditGeneral);;
Set(gblSelected; LookUp(Sortimente;Sortiment=tblBrowseSortiment.Selected.Sortiment));;
Navigate('Edit Detail Screen';ScreenTransition.None);;
where the Column 'Sortiment' is the GUID of the row. The Item of the form element is then set to gblSelected.
This does the trick!
Best regards,
Alexander
User | Count |
---|---|
19 | |
9 | |
9 | |
5 | |
5 |
User | Count |
---|---|
32 | |
30 | |
18 | |
18 | |
6 |