Share
ReportHi,
My projet is made of a gallery displaying some items stored in an Excel. I want those items to be modified so I added on the side some text entries, dropdowns, etc. Then, when you edit a field, you can push the changes using an icon that run a Patch function to the Excel.
I didn't wanted to use Forms, in order to get more freedom with my fields. Also, all of my fields (text entries, dropdowns, etc.) are components.
The dropdown component have the following properties:
- Input
- OriginaValue [text] which is then used to set the default value of the combobox (let's name it MyCombobox) inside the component
- Output
- CurrentValue [text] which is MyCombobox.Selected.Value ; it is used in the app to retrieve the actual value of the combobox from outside of the component.
Then, on the screen with the gallery, the OriginalValue is set to MyGallery.Selected.NameOfTheColumn. And, in the Patch function, I have something like { NameOfTheColumn: MyComponent.CurrentValue }.
Until this point, everything works fine, the Excel is updated when patched, the selection works in the gallery etc.
But here is the problem:
I tried to add a sorting tool. It is composed of one of my DropdownComponent (let's name it SortingColumnDropdownCompo). I use it to select the column to be sorted on. And my Gallery Items are : SortByColumns(myExcelTable, SortingColumnDropdownCompo.CurrentValue, Descending).
And the moment I add this line, the sorting seems to be working, but all of my DropdownComponents shows an error message except for the SortingColumnDropdownCompo :
"This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value."
But I can't find this circular reference.
I mean, there's obviously one with GalleryItem <- DropdownOriginalValue <- DropdownCurrentValue <- PatchArguments <- Excel <- Gallery. But the patch is only ... a patch, so it's a one-time action.
Moreover this error only appears when I add the sorting formula to the gallery. And the components on the side only mirror what the gallery selected items is.
Thanks you for your help,
If you need any precision I will be happy to provide them.
All responses (
Answers (
405
