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?

All responses (7)

Answers (1)

Simon001 5 on at

Like (0)

Report

RE: Auto Populate a column based on existing records on another Table

Thanks @Bipin the space was the issue

the flow is firing now
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: Auto Populate a column based on existing records on another Table

Hi,

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

Also,

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

en_si_orientation_
Simon001 5 on at

Like (0)

Report

RE: Auto Populate a column based on existing records on another Table

Hi Leah here it is
Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Auto Populate a column based on existing records on another Table

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/
Simon001 5 on at

Like (0)

Report

RE: Auto Populate a column based on existing records on another Table

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]
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

RE: Auto Populate a column based on existing records on another Table

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:
Suggested answer

Bipin D365 28,961 Moderator on at

Like (1)

Report

RE: Auto Populate a column based on existing records on another Table

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