Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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

 

  • Lucas_Ignatius Profile Picture
    230 on at
    Re: Related Column with 2 SharePoint List

    There anybody support my case

  • Lucas_Ignatius Profile Picture
    230 on at
    Re: Related Column with 2 SharePoint List

    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
    Re: Related Column with 2 SharePoint List

    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
    Re: Related Column with 2 SharePoint List

    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

  • ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Related Column with 2 SharePoint List

    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
    Re: Related Column with 2 SharePoint List

    Hai, are you need any information?

  • Lucas_Ignatius Profile Picture
    230 on at
    Re: Related Column with 2 SharePoint List

    Hi @ScottShearer 

    Need your support please

  • Lucas_Ignatius Profile Picture
    230 on at
    Re: Related Column with 2 SharePoint List

    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.

  • ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Related Column with 2 SharePoint List

    @Lucas_Ignatius 

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

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,522 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,890 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow