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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,598)