Answered

Power Automate Desktop, Count specific values from list

(0) Share

Report

Posted on by GucluGunduz

Hello everyone,

In one part of a long flow, I have long lists of tools, and I need to calculate how many of each tool are in those lists. For example, in my list of 200 vehicles, I need to calculate how many Volvos and how many Fiats there are by scanning the list items. In the last ı must write the conclusion to the excel like 71 volvo, 57 Fiat etc. I am using Power Automate Desktop.

Thanks in advance

Categories:

Power Automate Desktop

All responses (4)

Answers (2)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@GucluGunduz
Please follow the suggested actions:
Search for occurrences of the text "Volvo" within the "List" using "Parse Text" Action as mentioned as below.
Displaying/Get the counts of occurrences for "Volvo" use "%VolvoList.Count%"
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@GucluGunduz
Please paste the following code into your PAD designer. It should function correctly.

Code:

Text.ParseText.Parse Text: ToolList TextToFind: $'''Volvo''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> VolvoList Text.ParseText.Parse Text: ToolList TextToFind: $'''Suzuki''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> SuzukiList Display.ShowMessageDialog.ShowMessage Title: $'''Count''' Message: $'''Volvo: %VolvoList.Count% Suzuki: %SuzukiList.Count%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed

If my response addresses your concern, please consider marking it as the solution and giving it a thumbs up. This helps others in the future and also serves as motivation for me. Thank you!
GucluGunduz 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help

Instead of display messege, I need to print the result to Excel, so can you share a screenshot so that the settings are visible? Excel data: 72 Volvo, 57 Fiat, 43 Suzuki
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@GucluGunduz
Here you go!!

Code:
Text.ParseText.Parse Text: ToolList TextToFind: $'''Volvo''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> VolvoList
Text.ParseText.Parse Text: ToolList TextToFind: $'''Suzuki''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> SuzukiList
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\deenu\\OneDrive\\Documents\\result.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance2
Excel.WriteToExcel.WriteCell Instance: ExcelInstance2 Value: $'''%VolvoList.Count% Volvo''' Column: $'''A''' Row: 1
Excel.WriteToExcel.WriteCell Instance: ExcelInstance2 Value: $'''%SuzukiList.Count% Suzuki''' Column: $'''B''' Row: 1
Excel.SaveExcel.Save Instance: ExcelInstance2