cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshleyFoozi
Level: Powered On

Repeating Table and Dropdown

Hi All. I have seen a similar question here which has not been adequately answered. 

I have a repeating table in a gallery (using Shane Young's brilliant Youtube videos). In the row I have several fields; some text boxes and others drop downs. After filling the first row and creating the next row, I noticed that the selected drop down values go back to the first value of the Items. When looking at the collection the values are correct. Some users might think that their entry hasn't been saved. I have other repeating tables without drop downs and they work perfectly. Anybody have any suggestions?

First row entry.......

Capture1.PNG

Second Row entry.......

Capture2.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Repeating Table and Dropdown

Hi @AshleyFoozi 

 

Make sure the default value for that dropdown is being set based on the collection item

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: Repeating Table and Dropdown

Hi @AshleyFoozi 

 

Make sure the default value for that dropdown is being set based on the collection item

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

AshleyFoozi
Level: Powered On

Re: Repeating Table and Dropdown

Brilliant @Reza 

 

Thanks for the help.

vwyankee
Level: Powered On

Re: Repeating Table and Dropdown


@RezaDorrani wrote:

Hi @AshleyFoozi 

 

Make sure the default value for that dropdown is being set based on the collection item

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly


I have the same issue and can't seem to remedy it. I've found a couple threads indicating that I need to use "ThisItem.collectioncolumn" or "{value: collectioncolumn}" but neither are working for me. With either (or just using the collection column as the default value) I have a warning that "This formula uses scope, which is not presently supported for evaluation." I'm unable to find any examples with this warning and the issue I'm seeing. Some of my comboboxes are using a SharePoint list as a lookup data source while others are using a SQL database. The text boxes are fine but every combobox is reset after adding a new row just as the original poster here shows which makes me curious if he was able to fix his or just said thanks for the answer.

I am using patch with "ThisItem" as noted as well in this other other discussion.

vwyankee
Level: Powered On

Re: Repeating Table and Dropdown

Completely redesigning the way the repeating table works I thought I was in the clear with simply having the gallery show the collection and the top line resetting to add the next row, but have the same issue once again where all lookup fields are blank when putting those rows back in the top row for editing.

 

One difference this time is I'm not getting any warnings at all and the formula preview shows me the correct data but it's just not showing in the field. Extremely frustrated I'm about to put in a ticket with MS support as I interpret this as something not working that should be, especially since the preview is showing what we want to show in the input box. Here are a couple examples where I'm using the gallery and the collection identifier for the same field's Default property.

vwyankee
Level: Powered On

Re: Repeating Table and Dropdown

For anyone else that may have a similar problem as I have... It turned out to be a pretty simple solution after getting insight from Microsoft support. I had a different issue and while on the call I asked about this one and you have to use the same schema as your datasource. The simpler way to put it - if your datasource for your dropdown/combobox is specifying a column and/or filters to grab the values for the choices you need to use the same lookup to get the correct value to show back in the field after it's saved to the collection. Because we're working with tables/records (whether it's a SharePoint list, SQL table, Excel file, etc) we need to use the DefaultSelectedItems property instead of the Default property. Okay, time for examples to clarify.... I'm going to call the repeating table fields that are drop-downs or comboboxes choice fields for simplicity.

 

If you're using the method from Shane Young's Repeating Table videos where you're adding a new collection input row after saving the first row you'll want to set the DefaultSelectedItems property to filter the the datasource using the collection value as the equalizer. If we have a choice field pointing to a SharePoint list with the name Units of Measure, the Items property is set to: 'Units of Measure'.Title so we can get all the values in the Title column as our choices, right? Right. In this case our DefaultSelectedItems property needs to lookup to that same data source and find the choice that's been saved to the collection (named MyCollection) with the collection column name of ColUM. The formula to get this value: Filter('Units of Measure', Title = ThisItem.ColUM)

Translated in layman's terms: Filter the data source 'Units of Measure' where Title is equal to the value saved for this item/row in the ColUM column. It's the same using SQL and Excel data sources.

A SQL example formula: Filter('[dbo].[Units of Measure]', Title = ThisItem.ColUM)

 

See below, if you're using the method of separate (non-connected) input controls and a gallery to show the results (like my redesign) so that the top row is always the input "form" and you see the results in the gallery and then put the gallery/collection row back in the top line for editing... maybe I should make a YouTube video of that to compliment Shane's? 


It's a little different since you need to specify the gallery item selected (vs ThisItem in a collection): Filter('Units of Measure', Title = MyGallery.Selected.ColUM)

I've found that in this design you can either the collection or the gallery as the equalizer. In other words, this formula for the same thing works too where GalUM is the name of the label control within MyGalleryFilter('Units of Measure', Title = MyGallery.Selected.GalUM.Text) 

 

Of course, with all that explained I still have two fields from a SharePoint list data source that I can't get to work with the same method because they have multiple results and the distinct and first functions don't seem to be helping me. It's a back and forth love/hate relationship with PowerApps... I'll update when I get that sorted!

 

For lookups where there may be multiple results you need to use the Distinct function with a Result for your logical test. If the above example had multiple rows with the same values in the Title field we would make the formula: Filter(Distinct('Units of Measure'.Title, Title), Result = MyGallery.Selected.ColUM) 

Translated in layman's terms: Filter the data source 'Units of Measure' where Title is equal to the value saved for this item/row in the ColUM column and show me just one result value if there are multiple matches.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,903)