Share
Report
878So for my sharepoint list form app I have a text column that's updating from a Combobox. This gets its items from an Excel table. The defaultSelectedItems is set to:
Coalesce(locSelectedClient);
That's because in another Combobox that uses the Excel Table I have in the Onchange property this:
UpdateContext({locSelectedClient: Self.Selected})So, in this second combobox you select a Invoice Number, and therefore what is supossed to happen is that the next combobox changes automatically with the Matching Client ID in that Excel table. This is working, so yay.
My problem is that when I go to edit, the combobox goes back to black (Which I'm guessing is due to the fact that DefaultSelectedItems depends on that locSelectedClient, which only adds value when you select something different).
So I'd assume that I need to add something to the formula that checks if the item is new, and if it is, do the Coalesce already written command. However if it's not a new item, it should then... Do something which I'm not sure yet.
I tried this code, but gave errors:
If(
IsBlank(ThisItem.ID);
Coalesce(locSelectedClient);
Parent.Default
)
Greatly appreciate your input in advance :D
Categories:
I have the same question (0)
All responses (
Answers (
