Unanswered

Add value from List B to List A

(0) Share

Report

Posted on by NicoApps

Hi,

I have two lists, A and B. I think about them as a Fact/Dimension in data modeling. The Joint column is Department which exists in both lists. On creation of an item in List A (Via a Form) there is a column, left blank, and that is the Department's Email, which is stored in List B. How to update List A after its creation by the Value in Column B that shares the same Department value?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Re: Add value from List B to List A

Your Department Filed should be a Looup column.
Here is How I would do it.

List A (named "Departments") will contain the Deaprtment name and email address.
List B will have a Lookup column Called Department that is connected to List A
When a new item is created In List A, the associated Department values from List B can be referenced directly. You don't need flow for that.
List B will have a Lookup column called Department

Was this reply helpful? Yes No
NicoApps 23 on at

Like (0)

Report

Re: Add value from List B to List A

Well, how to automate this though? The use-case is
1-data comes to list B via a Form. since there is no Department email capability in this Form, therefore list B misses this piece at the creation instance.
2-At this point, this needs to be automated, and update the missing email filed from list A. My hope is to automate that way, without going to the table to pick from available lookup values.

Was this reply helpful? Yes No