Calculation in a Collection

(0) Share

Report

Posted on by PMO_CH

122

Dear all,

Hope someone can help me to find a solution.

i have a collection like this in powerapps

There is a current value "Anzahl" (Stockmanagement) and a MinimumStock- value.

I'm looking for a solution to inform the product-owner (Field "ToInformInCaseOf) with an email or teams-message if the current value (Anzahl) is smaller than the MinimumStock-Value.

Thank you very much 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey!
When you create the item to to the collection you can check the product and check if anzahl < MinimumStock-Value
Then, you use function MailTo

Was this reply helpful? Yes No
PMO_CH 122 on at

Like (0)

Report

Hy Nogueira1306

Sounds good, but unfortunately i need more help from your end. I don't know where to begin with this command.
Thank you very much.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey! Just tell me how do you create the collectipn. Print from the form and the code of the Collect()

Was this reply helpful? Yes No
PMO_CH 122 on at

Like (0)

Report
Hi,
It looks heavy and for sure there is the possibility to shrink the code, but don't know how and do that in many small steps 🙂
Look at the bottom to find the creation in the collection.
SubmitForm(EditForm1);; Navigate(Screen1);; ClearCollect( spArticleMinimumRest; StockArticle );; ClearCollect( spData; StockData );; ClearCollect( spDataLast; StockData );; ClearCollect( spDataLast; Filter( spDataLast; WasOrder = true ) );; ClearCollect( spDataLastUnitPrice; AddColumns( spDataLast; "Lagerwert Unit CHF"; Sum(EK_x002d_Preis / (MengeProEinheit * AnzahlGeliefert)); "Lagerwert Unit EUR"; Sum(EK_x002d_PreisAT / (MengeProEinheit * AnzahlGeliefert)) ) );; ClearCollect( spDataGroup; AddColumns( GroupBy( spData; "Title"; "Category"; "ArtNr"; "GroupedTitle" ); "Anzahl"; Sum( GroupedTitle; ((AnzahlGeliefert * MengeProEinheit) - CarriedOutAnzahl) ) ) );; ClearCollect( SemiFinalDataCollection; AddColumns( spDataGroup; "MinimumStock"; LookUp( spArticleMinimumRest; Artikel_x002d_Nr_x002e_ = spDataGroup[@ArtNr]; Mindestbestand ); "ToInformInCaseOf"; LookUp( spArticleMinimumRest; Artikel_x002d_Nr_x002e_ = spDataGroup[@ArtNr]; ToInformInCaseOf ) ) );; ClearCollect( UltimateDataCollection; DropColumns( SemiFinalDataCollection; "GroupedTitle" ) );; RemoveIf( StockView; true );; ForAll( UltimateDataCollection; Patch( StockView; Defaults(StockView); { ArtNr: ArtNr; Title: Title; Category: Category; Stock: Anzahl; MinimumStock: MinimumStock; ToInformInCaseOf: ToInformInCaseOf } ) )

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

This is just checking for First Item because I am assuming that you dont delete all items and re create the collection, I am assuming that you patch 1 item at a time

If you need additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Was this reply helpful? Yes No