Power Platform Community Forum Thread Details

So 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:

Using Apps Using Formulas

Community site session details

Combobox going blank

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates