Unanswered

Importing data into dataverse, then writing to lookup column in dataverse

(0) Share

Report

Posted on by KThom

I'm at my whits ends, can someone please help?

I have built a power automate flow which is triggered when I simply import data into a dataverse table. This triggers a follow on action where multiple single records are created in another dataverse table from the import. Some of the columns in the second dataverse table that contains the new records are lookup columns. I'm unable to make the lookup columns populate with the data from the table they are looked up from. These are the steps I have in my flow:

I want to update the rows Academic Plan (P1), P2 and P3 with the value that is looked up from a table named Program Requirements from the previous step where I'm getting the row by ID.

Any help would be appreciated. I'm constantly getting this error: Bad Request - Error in query syntax. And I really don't know what I'm doing wrong here. The flow works perfectly when I'm not trying to populate the look-up columns, so it must have something to do with this. And yes, I have watched Shane's awesome video, and I'm doing exactly as he explains in there, but it is still not working.

Thank you so much!

Categories:

General topics

All responses (2)

Answers (0)

Sort by

TaijuHataya 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi There,

Has this problem been solved? I am facing the exact same situation. Yes have seen the great Shane's video, did exactly as it explain and get "error": {"code": "0x0","message": "Bad Request - Error in query syntax.").

There are syntax of without / in front in other HP. Did tried that does not work.

Please help if you have any information.
KThom 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I've got it to work; turns out I missed two steps: "List rows" and "compose". However, it is only writing the first item that it finds in the list rows action into the new row. I actually need it to go through the list of items in "list rows" and find the one that is equal to one in "get a row by ID" and then write that value back into the "add a new row." So I'm still trying...