Skip to main content
Community site session details

Community site session details

Session Id : Z1z7QF2djOy5oeGb5hbWGT
Power Automate - Using Flows
Unanswered

Related Column with 2 SharePoint List

Like (0) ShareShare
ReportReport
Posted on 13 Aug 2021 09:33:13 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 20 Aug 2021 at 01:05:18
    Re: Related Column with 2 SharePoint List

    There anybody support my case

  • Lucas_Ignatius Profile Picture
    230 on 19 Aug 2021 at 14:49:48
    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 19 Aug 2021 at 00:33:34
    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 18 Aug 2021 at 02:45:28
    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,236 Most Valuable Professional on 16 Aug 2021 at 18:56:46
    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 16 Aug 2021 at 15:20:34
    Re: Related Column with 2 SharePoint List

    Hai, are you need any information?

  • Lucas_Ignatius Profile Picture
    230 on 15 Aug 2021 at 01:57:44
    Re: Related Column with 2 SharePoint List

    Hi @ScottShearer 

    Need your support please

  • Lucas_Ignatius Profile Picture
    230 on 14 Aug 2021 at 06:33:08
    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,236 Most Valuable Professional on 13 Aug 2021 at 14:29:18
    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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics

Restore a deleted flow
Loading complete