Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Seamus Marrinan]

I am trying to pull a value from another table but it seems that there is not a full dataset.

Here is the command that I am using:

= Table.AddColumn(#”Changed Type”, “Scrap Assignment”, each ScrapAssignments{[IndexSA=[#”Index-ScrapAssignments”]]})

I need an alternative that allows me put in a value if there is an error or null. Any suggestions?

Thanks

——————————
Seamus Marrinan
8594812330
——————————

[Lutz Bendlin]

use the TRY … OTHERWISE …  construct for errors, and the IF … THEN … ELSE  construct for nulls.
Or look into the [HasError]  property.

https://docs.microsoft.com/en-us/powerquery-m/errors

——————————
Lutz
——————————
——————————————-