Answered

Unable to Copy a Dataverse Text Column to a Lookup Column in Same Table

(1) Share

Report

Posted on by Community Power Pla...

I am building a simple Flow to copy data from a text column (Deal-Request-ID) to a lookup column (DRID).
Flow Copy Dataverse column Table view.png
Here are the two columns.
Flow Copy Dataverse columns text lookup.png
Here are screenshots from the Flow and it fails in the Apply to Each 2 loop in the Get a row by ID (404 error). Any recommendations are appreciated.
Flow Copy Dataverse column Err 2.png Flow Copy Dataverse column.png

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Community Power Pla... on at

Like (0)

Report

One additional clue: The INPUTS & OUTOUTS show raw inputs/outputs are both blank and the Output has a status reason = 200.

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Anonymous ,

I see the table name in the flow is "AssignedUserss" while the display name in Dataverse it is "AssignedUsers", could you please check if you have selected a wrong table from the dropdown?

For more info, raw outputs of the List rows action is abnormal to be blank. But status code 200 means action is succeed. Could you please tell how many items are there in this table? It is possible to see blank in the output when the table holds many items, the raw outputs need to download the whole metadata so it will appears to be blank for a short period of time before the download work complete.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-jefferni - Thanks so much for your response! As shown below, there is unfortunately only the AssignedUserss table available in the dropdown.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-jefferni - I manually entered "AssignedUsers" for the table name and got this error.

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Anonymous ,

I haven't noticed that you were using OData Id for the Get a row action. It should be the unique identifier column from the source table, which I assume it should be the same as the table's name: "AssignedUsers":

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-jefferni - Thank you, updating the Row ID per your suggestion fixed the issue with Row IDs! I do still have one more step - Update the Lookup column for DRID with the value in Deal-Request-ID.

Solved: Re: Help with expression - Power Platform Community (microsoft.com) provides an answer "try /entityname(GUID)" but I cannot get it working and the error is "Resource not found for the segment 'cr4de_assignedusers'". This is also an article on Tip #1311: Use entity name in Flow lookups | Power Platform & Dynamics CRM Tip Of The Day.

Here is a screenshot of my updated Flow. Any recommendations are greatly appreciated.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-jefferni - I peeked the code for the "Get a row by ID" action, and I retrieved the entityName as shown in the screenshot below.

Next, I updated the Update a Row action for the DRID field (DV lookup col) that I'm trying to populate with the data in the Deal-Request-ID field. Now I am getting a new error ')' or ',' expected at position 7 in '(020722-101146)', which indicates there are issues with the dash in the DRID lookup column. Any recommendations?
@ChristianAbata & @Mira_Ghaly - You have provided similar answers to this question on other posts. Are you able to determine how to resolve this error? Any feedback is appreciated!

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

It seems you have put the wrong value as the LookUp column GUID value.. To be clear, in Power Automate, to setup a LookUp column values, You will need the GUID of the source record. So, as I can see, you will need the GUID column of the DealIntakeApps table.

A solution will be use List rows action again, with filter query set to DRID eq Deal-Request-ID the dynamic content and use the output GUID as the input value.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-jefferni - Thanks gain for your response! I can add another List Rows action as shown below, but setting the filter DRID eq Deal-Request-ID won't work because my goal is to copy the Deal-Request-ID data to the DRID column which has no data. Therefore, the filter won't produce any rows since the DRID column has no values.

Can you be more specific about your solution? Thank you!

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

I understand the situation now. You have a blank DRID table for now and will like to populate this table then the AssignedUsers table Deal column looks to this table and get the corresponding values. So, the action should be "Add a new row" based on the Deal-Request-ID of the AssignedUsers table then create the LookUp column value based on GUID of this new created record. Below are the basic steps of the flow, for your reference:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No