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!
Solved! Go to 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,
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,
Hi - Worked like a charm - thank you!!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
53 | |
50 | |
36 | |
35 |
User | Count |
---|---|
270 | |
91 | |
82 | |
76 | |
75 |