How do I delete items in a list after 10 items added by each user?

%3CLINGO-SUB%20id%3D%22lingo-sub-1660289%22%20slang%3D%22en-US%22%3EHow%20do%20I%20delete%20items%20in%20a%20list%20after%2010%20items%20added%20by%20each%20user%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20loyalty%20app%20for%20our%20cafe%20in%20powerapps%3A%20Linked%20to%20a%20QR%20code%2C%20which%2C%20when%20scanned%20updates%20a%20sharepoint%20list.%20But%20I%20want%20the%20items%20to%20delete%20for%20each%20individual%20user%20on%20their%2011th%20Scan%20(so%20the%20loyalty%20card%20resets%20to%20zero).%20Can%20this%20be%20done%20in%20sharepoint%20or%20is%20it%20best%20as%20a%20powerautomate%20flow%3F%3C%2FP%3E%3CP%3EHow%20do%20I%20get%20it%20to%20look%20for%20individual%20user%20entries%20(e.g.%20when%20Jane%20has%20done%2011%20scans%2C%20her%20loyalty%20points%20reset%20to%20zero)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660754%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20items%20in%20a%20list%20after%2010%20items%20added%20by%20each%20user%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660754%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10825%22%20target%3D%22_blank%22%3E%40Amy%20Christie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20an%20interesting%20question%20and%20it%20looks%20like%20a%20cool%20app.%20But%20just%20checking%20first%20to%20make%20sure%20you%20know%20that%20Power%20Apps%20can%20only%20be%20shared%20with%20(i.e.%20used%20by)%20people%20who%20have%20accounts%20on%20your%20Microsoft%20365%20tenant%2C%20or%20who%20are%20guests%20connected%20to%20your%20tenant%20via%20Azure%20B2B.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fshare-app%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Fshare-app%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ask%20because%20I%20imagine%20that's%20not%20the%20case%20with%20customers%20of%20your%20cafe...%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESandy%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have created a loyalty app for our cafe in powerapps: Linked to a QR code, which, when scanned updates a sharepoint list. But I want the items to delete for each individual user on their 11th Scan (so the loyalty card resets to zero). Can this be done in sharepoint or is it best as a powerautomate flow?

How do I get it to look for individual user entries (e.g. when Jane has done 11 scans, her loyalty points reset to zero)

2 Replies
Highlighted

Hi @Amy Christie 

 

That's an interesting question and it looks like a cool app. But just checking first to make sure you know that Power Apps can only be shared with (i.e. used by) people who have accounts on your Microsoft 365 tenant, or who are guests connected to your tenant via Azure B2B. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app

 

I ask because I imagine that's not the case with customers of your cafe...?

 

Sandy

Highlighted

@Sandy Ussia Oh good point, but we are a school, so the customers are our students at the school canteen, so all members.