Lookup value in Dataverse

(0) Share

Report

Posted on by muku611

I need help in Power Automate for lookup flow for Dataverse table

I Have two tables one

Table 1: Table name Locationtest , having City & Location column and HCV column.

If I edit the cell against Dibrugarh-Assam as Yes in HCV

I want the same will be auto-updated in the second table named Branchmaster test where i have the same name column and cell value but multiple times, so I want Yes to be updated in the Branchmastertest table in all the 3 rows.

please help.

Categories:

General topics

All responses (5)

Answers (2)

Sort by

Linn Zaw Win 2,996 on at

Like
a
(0)

Report
Copy link

Link copied!
@muku611
You can achieve it by a cloud flow with Microsoft Dataverse trigger + actions
The trigger would be Microsoft Dataverse When a row is added, modified or deleted
Change Type = Update
Table name = Locationtests
Select Columns = <<Logical name of HCV column>>
List rows Dataverse action
Table = BranchMastertests
Filter = <<logical name of City & location>> eq <<Dynamic City value from the trigger>>
Apply to each
Update a row Dataverse action
Update BranchMastertests and set the value for PL-HCV to Yes
muku611 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Linn

Thanks for your prompt response, I am in the learning stage so my query may be silly to you. please guide on flow.

I am getting an error

I inputted Logical name of City & Location of Locationtest table

eq

Dynamic Trigger value of City & Location

Below is the error

My Flow is
Verified answer

Linn Zaw Win 2,996 on at

Like
a
(1)

Report
Copy link

Link copied!

@muku611
First of all, please use the Microsoft Dataverse connector (the green one) since the legacy (grey) one is deprecated.

The error that you are getting is because of the missing single quote characters ' around the dynamic value.
The filter condition of the string value will require the single quotes.
e.g.
cr9fa_citylocation eq '«City & Location»'
which would be transformed into
cr9fa_citylocation eq 'Dibrugarh-Assam'

Sometimes, I find it easier to use the FetchXML Builder tool to get the parameters for the Dataverse List Rows action in Power Automate.
https://saralagerquist.com/2019/11/13/be-lazy-filter-list-records-in-power-automate-with-fetchxml-builder/
https://blog.magnetismsolutions.com/blog/nickchin/2020/05/07/power-automate-flow--making-the-filter-query-easier
Verified answer

muku611 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Last step and error

--batchresponse_2fab79e1-bc0d-4da8-ae68-04063c49c34b
Content-Type: application/http
Content-Transfer-Encoding: binary
HTTP/1.1 400 Bad Request
REQ_ID: 3719382a-e429-4525-afd4-0a0baaf5ef38
Content-Type: application/json; odata.metadata=minimal
OData-Version: 4.0
{"error":{"code":"0x0","message":"Bad Request - Error in query syntax."}}
--batchresponse_2fab79e1-bc0d-4da8-ae68-04063c49c34b--

My Flow at this stage is
muku611 19 on at

Like
a
(1)

Report
Copy link

Link copied!

Its working fine, Thanks Lots @LinnZawWin for your support, I was struggling to fix this from last 5 days.
You are awesome.