Auto Populate a column based on existing records on another Table

(0) Share

Report

Posted on by Simon001

Hi Guys,
I have two tables, Slope_lookup and Roof.

slope_lookup has been pre-populated with data hence the name Lookup.
It consists of 4 columns
Column 1, Column 2, Column 3, and Column 4. which contains data provided by a governing body to help guide our operations.

On the roof Table, I collect Data for Columns 1,2, and 3 and need to populate column 4 accordingly.
I am looking for a function that says if columns 1,2 and 3 are the same as that on Slope_lookup set the value of column 4 to the record value. any ideas?

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

You will write javascript to find record is slop_lookup based on 3 fields value

learn.microsoft.com/.../retrievemultiplerecords

Based on the result you will set the column 4 field

Make sure you register your code on onchange of 3 fields.

Make sure to clear the Column 4 field value when no match is found

Was this reply helpful? Yes No
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

Hi Simon001,

You can use power automate to create one flow:

Then you can use 'list rows' action to retrieve records, then update records with 'Update a row' action:

Was this reply helpful? Yes No
Simon001 5 on at

Like (0)

Report

Hi Leah, I have tried to recreate this flow, but it fails with an invalid XML error, can you help check if I've missed something?

I have also tried to create the flow using just the filter query, but it runs successfully without pulling out the required record.
[quote user="Simon001"]
Hi Guys,
I have two tables, Slope_lookup and Roof.

slope_lookup has been pre-populated with data hence the name Lookup.
It consists of 4 columns
Column 1, Column 2, Column 3, and Column 4. which contains data provided by a governing body to help guide our operations.

On the roof Table, I collect Data for Columns 1,2, and 3 and need to populate column 4 accordingly.
I am looking for a function that says if columns 1,2 and 3 are the same as that on Slope_lookup set the value of column 4 to the record value. any ideas?
[/quote]

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

Hi Simon001,

Could you share code about your fetch xml query?

You need to check that the xml query created is correct and does not contain special characters:

https://d365demystified.com/2021/05/04/invalid-xml-issue-in-dataverse-connector-for-list-rows-action-fetch-xml-query-power-automate/

Was this reply helpful? Yes No
Simon001 5 on at

Like (0)

Report

Hi Leah here it is

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Space is missing after operator operator="eq" Value="xyz"

Also,

Condition attribute field name ends with underscore _ is this correct?

en_si_orientation_

Was this reply helpful? Yes No
Simon001 5 on at

Like (0)

Report

Thanks @Bipin the space was the issue

the flow is firing now

Was this reply helpful? Yes No