
Hello everyone,
I am aware that in Canvas App to patch a lookup column in Dataverse we will usual do something like this:
Patch(Datasource, Default(datasource), ColumnSchemaName: Lookup(datasource, Name="ABC")).
but is it possible to do it like this instead?
Patch(Datasource, Default(datasource), ColumnSchemaName:{ IDColumn: "100", Value:"ABC"} )
Hi, yes you can as long as you have the id
Patch(MySource, Defaults(MySource),
{
LookUpField:
{
Id: TheId,
Value: Whatever Column that is the default like Name
}
}
);
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey