cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
flobber
New Member

Update a row with a dataverse lookup

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 issueflow issue

 

 

3 REPLIES 3
MarconettiMarco
Super User
Super User

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

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 

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

 

BR,

Marco

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,980)