Why isn't Coalesce working?

[simms7400]

Hi Folks -

I have an field (Asset ID) I do not display to the end user at any time as it's just a unique I populate with an MS Access VBA routine after submission. However, I upon intial submission, I populate it with whatever is available in the Alias field (Asset Alias).  Recently, I found out this wasn't working...

I would expect the value of Asset Alias to be in Asset ID:

Here is my Defauly propety of Asset ID:

Coalesce(ThisItem.Name,ThisItem.Alias)

Keep in mind,  Name = Asset ID and Alias = Asset Alias.

Would anyone know why this isn't working? I even tried to reference another field and it still doesn't work.

Thanks!

[v-xida-msft · Accepted solution]

Hi @simms7400 ,

Based on the issue that you mentioned, I think there is somethin wrong with your formula.

Before you submit a new record (intial submission), the ThisItem.Name and ThisItem.Alias formula in your Edit form (in New mode) would both return blank. So the Coalesce() function within your app would return blank.

I have made a test on my side, please take a try with the following workaround:

Set the Default propety of Asset ID to following:

Coalesce(ThisItem.Name, EditForm1.Updates.Alias)

or

Coalesce(ThisItem.Name, AssetAliasTextBox.Text)

Note: The EditForm1 represents the Edit form in your app. The AssetAliasTextBox represents the Text Input box within the Asset Alias data card.

Best regards,

[simms7400]

Hi - Worked like a charm - thank you!!