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:

Building Power Apps

Community site session details

Combobox going blank

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates