You’re offline. This is a read only version of the page.
33
I'm trying to create a record in my production environment from a flow triggered via a Power BI visual. I followed these directions: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-desktop. Because the Power Automate flow is still in preview, it only operates with the default environment. I want to create the record in my production environment, so I'm using the Dataverse (legacy) actions, which allow me to select the environment.
I'm trying to create a record in a custom table and I'm running into issues with the lookup fields. I'm trying to set the owner to be my user ID, but the flow fails on save with the following message (random GUID inserted instead of my actual user guid):
Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Add_a_new_row_(legacy)': The parameter with value '"systemusers(3d23fccb-c9e1-4883-87e9-7ab786876490)"' in path 'item/_ownerid_value' with type/format 'String' is not convertible to type/format 'String/uuid'.'.
I've tried LOADS of formats for this string. Here are some examples:
I've tried hard coding my guid as a string:
I've tried looking up my user record and then populating with the dynamic systemuserid field. Every time, it fails with type/format 'String' is not convertible to type/format 'String/uuid'.
What am I doing wrong? Does this Dataverse legacy connector just not support lookup fields? Is there a different or better way to create a record in my production environment?
Resolved.
The solution is to just put the raw GUID in the field, with no table name. This worked for the owner and for a custom object.
Share
Report
All responses (
Answers (
