web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Related Column with 2 ...
Power Automate
Unanswered

Related Column with 2 SharePoint List

(0) ShareShare
ReportReport
Posted on by 230

Hello everyone, I was created flow for Budgeting, but there is a problem where the ID is not related with other List.

But I was related with Lookup column


List -1

Lucas_Ignatius_0-1628846802805.png

List -2

Lucas_Ignatius_1-1628847023600.png

 

flow

Lucas_Ignatius_2-1628847148678.png

Lucas_Ignatius_3-1628847180148.png

 

 

I'm appreciate for anyone help and advice.

 

Thank you

 

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @Lucas_Ignatius 

    Can you provide additional details on the issue that you are experiencing?  I am not quite clear on your issue.

     

  • Lucas_Ignatius Profile Picture
    230 on at

    Hi @ScottShearer 

    For list-1 column "Amount" will be update  calculated (+) to list-2 column "Realisasi" 

    But based on list-1 column  "ID Budget Category". 

     

    I hope my explaination is easy to understand.

  • Lucas_Ignatius Profile Picture
    230 on at

    Hi @ScottShearer 

    Need your support please

  • Lucas_Ignatius Profile Picture
    230 on at

    Hai, are you need any information?

  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    My apologies but I just don't understand the issue.  May I suggest that you explain in detail in the language of your choice and I'll will translate?

     

     

  • Lucas_Ignatius Profile Picture
    230 on at

    Hi @ScottShearer 

     

    I'm sorry

     

    I mean List-2 (BudgetMasterCategory) column "Realisasi" it will be filled and sum from list-1(TransactionBudgetMasterCategory).

     

    Example in this case : Input into list-1 with IDBudgetCategory 601 and amount 25.000. I need it will be update and sum into list-2 column "Realisasi" 25.000 but based on "IDCategoryBudget is 601"

     

    Noted : IDBudgetCateory and IDCategoryBudget, is same Column because it related with Lookup Column.

     

    That’s a very kind of you for helping me

  • Lucas_Ignatius Profile Picture
    230 on at

    Hi @ScottShearer 

    I hope my explanation makes it easier for you to understand

    If it's still not clear, please let me know

  • Lucas_Ignatius Profile Picture
    230 on at

    Hi @ScottShearer 

    Can you help me?

    I was give example for my problem, i hope can make make you understand for this problem

  • Lucas_Ignatius Profile Picture
    230 on at

    There anybody support my case

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 484

#2
11manish Profile Picture

11manish 282

#3
David_MA Profile Picture

David_MA 280 Super User 2026 Season 1

Last 30 days Overall leaderboard