Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Add value from List B to List A

(0) ShareShare
ReportReport
Posted on by 23

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:
  • NicoApps Profile Picture
    NicoApps 23 on at
    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. 

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Add value from List B to List A

    Your Department Filed should be a Looup column.

    Here is How I would do it.

     

    1. List A (named "Departments") will contain the Deaprtment name and email address.
    2. List B will have a Lookup column Called Department that is connected to List A
    3. 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.

    SudeepGhatakNZ_0-1665103990047.png

    List B will have a Lookup column called Department

     

    SudeepGhatakNZ_1-1665104063979.png

     

    SudeepGhatakNZ_2-1665104094909.png

    SudeepGhatakNZ_3-1665104107208.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard