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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / check if collection it...
Power Apps
Answered

check if collection item exists, if it does update it, if not make the item

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi guys,

 

So i'm trying to work with collections so i can make an offline app. What i am trying to do is to check if a collection item already exists. If it does the quantity needs to be updated. If it doesn't exist it needs to be added to the collection.

 

Currently i make my collection like this: 

 

Collect(
 matList;
 {
 material: varThisMaterial;
 quantity: varAmount;
 bonitem: varBonItems;
 bonNr: varBonNr
 }
)

 

 

I would need like a function that does this: if( matlist.material=varThisMaterial && matlist.bonitem=varBonItems && bonNr=varBonNr, update quantity to quantity+varamount, else make a new collection item.

 

Underneath picture will make u understand what i am trying to do:

 

2021-03-01 14_22_07-Savic - Opgeslagen (niet gepubliceerd) - Power Apps.png

As you can see on the picture i have the same items a few times in my collection. I just want them to add up whenever i add more of them. 

 

Greetings Anthony

Categories:
Building Power Apps
I have the same question (0)
  • JR-BejeweledOne Profile Picture
    JR-BejeweledOne 5,836 Moderator on at

    I think you are looking for something like this:

     

    If(
            CountIf(matlist, Material = varMaterial && bonitem = varBonItems && bonNr = varBonNr) >0,

              Patch(matlist,
                 First(
                    Filter(matlist,
                      Material in varMaterial && bonitem = varBonItems && bonNr = varBonNr,
                        {
                           quantity: quantity + varAmount
                           }
              )
         )
    ),

    Collect(
             matlist:
                {
                    material: varThisMaterial;
                    quantity: varAmount;
                    bonitem: varBonItems;
                   bonNr: varBonNr
                 }

           )

    )

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    dear @JR-BejeweledOne ,

     

    I tried your code but i seem to be getting some errors. Is this maybe because the first time i'm trying to add materials the collection doesn't exists yet and because of that it gives errors?

     

    This is the error i get:

    Boolean expected & invalid arguments in filter.

    2021-03-02 10_03_15-Savic - Opgeslagen (niet gepubliceerd) - Power Apps.png

    This is the code that gives errors (i need to use ";" somehow in my powerapps instead of ","):

     

     

    If(
 CountIf(matlist; material = varThisMaterial && bonitem = varBonItems && bonNr = varBonNr) >0;

 Patch(matlist;
 First(
 Filter(matlist;
 material in varThisMaterial && bonitem = varBonItems && bonNr = varBonNr;
 {
 quantity: quantity + varAmount
 }
 )
 )
);

Collect(
 matlist;
 {
 material: varThisMaterial;
 quantity: varAmount;
 bonitem: varBonItems;
 bonNr: varBonNr
 }

 )
)

     

    Thank you for helping me!

     

  • JR-BejeweledOne Profile Picture
    JR-BejeweledOne 5,836 Moderator on at

    Can you provide a screenshot of the entire code with the error lines?   Also to test the code, you might put a button on the screen to create your collection.  You will definitely get errors if the collection doesn't exist.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @JR-BejeweledOne 

     

    How should i change the code so that when i start the app and the collection doesn't exist yet, i don't get errors?

     

    Here's the full code (it is the "on select" property of a check icon):

     

    2021-03-02 13_52_03-Savic - Opgeslagen (niet gepubliceerd) - Power Apps.png

  • JR-BejeweledOne Profile Picture
    JR-BejeweledOne 5,836 Moderator on at

    You can create the collection on app start like this:

    Collect(matlist,
 {
 material:"",
 quantity:0,
 bonitem:"",
 bonNr:""
 }

); Clear(matlist)

     

     

    Then change the formula I gave you previously to this:

     

    If(
 CountIf(matlist, material = varMaterial && bonitem = varBonItems && bonNr = varBonNr) >0,

 Set(varRecord,
 First(
 Filter(matlist,
 material in varMaterial && bonitem in varBonItems && bonNr in varBonNr).quantity
 )
 ); Set(varAmount, varRecord.quantity + varAmount);

 Patch(matlist,
 First(
 Filter(matlist,
 material in varMaterial && bonitem in varBonItems && bonNr in varBonNr)),
 {
 quantity: varAmount
 }
 ),
 

Collect(matlist,
 {
 material: varMaterial,
 quantity: varAmount,
 bonitem: varBonItems,
 bonNr: varBonNr
 }
 )
)

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @JR-BejeweledOne  

     

    I tried your code but it makes the var "varAmount" give a lot of errors. It also makes the UI to insert varAmount completely full of errors.  Also i changed the collection items names a little because i tried something else with my sharepointlist (that didn't work aswell).

     

    varAmount is the "text" property of a label. I made a UI for the user to insert the amount they want (did this with string manipulation):

     

    2021-03-03 09_32_47-Savic - Saved (Unpublished) - Power Apps.png

     

    My onstart:

    Collect(
 matlist,
 {
 Title: "",
 quantity: "0",
 bonitem: "",
 bonnr: ""
 }
);
Clear(matlist

     

    My onselect checkicon:

     

    If(
 CountIf(matlist, Title = varThisMaterial && bonitem = varBonItems && bonnr = varBonNr) >0,

 Set(varRecord,
 First(
 Filter(matlist,
 Title in varThisMaterial && bonitem in varBonItems && bonnr in varBonNr).quantity
 )
 ); Set(varAmount,varRecord.quantity + varAmount);

 Patch(matlist,
 First(
 Filter(matlist,
 Title in varThisMaterial && bonitem in varBonItems && bonnr in varBonNr)),
 {
 quantity: varAmount
 }
 ),
 

Collect(
 matlist,
 {
 Title: varThisMaterial,
 quantity: varAmount,
 bonitem: varBonItems,
 bonnr: varBonNr
 
 }

 )
)

     

    errors i get:

    2021-03-03 09_32_08-Savic - Saved (Unpublished) - Power Apps.png

     

    I tried changing a lot and nothing worked..

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @JR-BejeweledOne 

     

    I fixed it and all works fine now. I had to change the var (varAmount + quantity) to a new var "varPatchAmount". Now the code runs perfect and does the job! Thank you very much for your great help!

     

    Here's the code:

     

    If(
 CountIf(matlist, Title = varThisMaterial && bonitem = varBonItems && bonnr = varBonNr) >0,

 Set(varRecord,
 First(
 Filter(matlist,
 Title in varThisMaterial && bonitem in varBonItems && bonnr in varBonNr).quantity
 )
 ); Set(varPatchAmount,varRecord.quantity + varAmount);

 Patch(matlist,
 First(
 Filter(matlist,
 Title in varThisMaterial && bonitem in varBonItems && bonnr in varBonNr)),
 {
 quantity: varPatchAmount
 }
 ),
 

Collect(
 matlist,
 {
 Title: varThisMaterial,
 quantity: varAmount,
 bonitem: varBonItems,
 bonnr: varBonNr
 
 }

 )
)

     

  • JR-BejeweledOne Profile Picture
    JR-BejeweledOne 5,836 Moderator on at

    Try this, it's a much cleaner solution and eliminates the need for the  extra variables.   If you still get errors with varAmount, you might have to wrap it like this:  Value(varAmount)

     

     

     

    If( 
 CountIf(matlist, Title = varThisMaterial) >0,
 With(
 {_item: LookUp(matlist, Title = varThisMaterial && bonitem = varBonItems && bonNr = varBonNr)
 },
 
 UpdateIf(matlist, !IsBlank(_item.Title) && _item.Title = varThisMaterial, {quantity: _item.quantity + varAmount})
 
 ), 
 
 Collect(matlist, 
 {Title: varThisMaterial,
 quantity: varAmount,
 bonitem: varBonItems,
 bonnr: varBonNr
 }
 )
 )

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,074

#2
Valantis Profile Picture

Valantis 639

#3
11manish Profile Picture

11manish 606

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans