Hi,
Pretty new to dataflows and looking for some assistance.
We have a dataflow setup to update our dynamics accounts dataverse table based on a daily excel extract.
This is working as expected however the one thing we can't seem to map and update is the ownerid field of the account, this doesn't seem to be an option to map to.
We merge our excel extract with our own custom user dataverse table with our own key, to be able to retrieve the corresponding azureadguid and ownerid of the user specified in the excel extract.
This approach has allowed us to populate other, person fields based on the retrieved azureadguid however ownerid never appears as an option to populate.
Table Column
Merged Query
Missing Mapping
Any help appreciated.
Thanks.
