Update a row with a dataverse lookup

[flobber]

Hi All, 

Im building a flow which updates a batch of dataverse records using two tables , one called < Organisations > , the other called   < Domains > . The Organisations table has two key columns, one called organisation name the other is a lookup to domains called domains, it reads the domain name field

What I want to do is iterate through all the records in Organisations and where the domain is found to be blank populate it with the data in organisation name in the organisation table.  The organisation name is the same as data found in the domains, domain name table (dont ask why)

Is there a way to override the lookup ? - any help is massively appreciated

flow issue

[MarconettiMarco]

Hello @flobber ,

before the update a row, you should add the "List rows" action selecting the "Domains" table and search for Name equal to Organization name (please add 1 in the "Row count" field".

Then, in the "Update a row", in the Domain field you have to specify the Domain schema name/the GUID got from the previous action, like below:

domains/a4cea450-cb0c-ea11-a813-000d3a1b1223

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[flobber]

Thanks Marco - I cant seem to get the Odata filter to work in the list rows - im trying DomainName eq 'OrganisationName' as dynamic content and it throws a bad request error 

[MarconettiMarco]

@flobber please share the flow in edit mode and specify where you’re getting the error.

BR,

Marco

[AkioSImokomaki]

Hey

You set up this wrong 

hsa to be like that to work 

domains(gud)