Power Platform Community Forum Thread Details

Hello,

I have a multipage form that requires a 'save as draft' functionality in the app and cascading dropdowns within the form itself. 'Page 1' lists all unsubmitted drafts as the form in a gallery and should allow the user to select it and view their saved data in a page called 'ItemsView'. From there, if the user wishes to continue filling out the form, they can click the edit button which should take them to the original form, 'Page 2'. My intention is to have the data that has already been saved, to repopulate in the form. This is where my problems comes, that data doesn't seem to show for the fields that are combo boxes or dropdowns.

I believe it has something to do with the fact that these are cascading combo boxes. To implement this cascading dropdown/combo box functionality, I followed this tutorial https://www.youtube.com/watch?v=IWEQwGLcW7Q . It seemed to work for me, however when it came time to edit a draft, the data would show on the 'ItemsView' page but when the edit button is clicked and redirected to 'Page2' (page with editing form), the data would not appear in the dropdowns/combo boxes. All other fields such as text inputs, do in fact show the saved data.

In an attempt to fix this, I used the following formulas:

- In the Update property of the data card:

ComboBox1.Selected.ColumnName

- The Items property of the combo box:

'DataSource'.ColumnName

- The DefaultSelectedItems property of the combo box:

{ColumnName:ThisItem.ColumnName}

This solution works to some extent however, the items property causes duplicate values to appear in the dropdown

*Central should only be displayed once*

The YouTube tutorial from above requires that the items property uses the formula below, however this doesn't allow for data to be pulled from the parent page:

Distinct('DataSource',ColumnName)

So, is it possible to use this formula ('DataSource'.Column Name) in the items property, while also using the distinct function to keep to from showing duplicate values while also being able to pull from parent page? Is there a way to combine the to formulas or to make this formula show only distinct values?

Categories:

Building Power Apps