Pulling counts from a spreadsheet.

(1) Share

Report

Posted on by DF-14081717-0

I am a newbie at excel and power automate. I am looking to pull data and get a count from it. I was given the job of inventory. What I need to do is count how many computers we have of a certain type and location. If there are say two HP 650's at the prison I need to take that number (2) and compare it to another spreadsheet. At this moment I'm just trying to figure out how to make it find only the HP650s and only at the prison and create a number. Any help appreciated or if you can guide me to a article or video that would be great. I don't know if i'm using the correct keywords to find answers.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

AnthonyAmador 2,557 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi,

First, you need to create a table in the excel file with the information, otherwise Power Automate will not be able to read it.

Then you can use the action "List rows present in a table" select your excel file and table, then add a Filter Query, for example if you only wan to extract the rows that contains 'HP 650' in the Computer column, use:
Computer eq 'HP 650'

With the response from the excel action, you use the Compose action with the following expression:

length(outputs('List_rows_present_in_a_table')?['body/value'])

This will give you the number of records extracted.

Hope this helps.

Anthony.

If my reply answers your question, please like and mark it as verified. This helps me stay motivated to assist others and makes it easier for users with similar questions to find the answer. Thanks!
Feel free to connect with me on LinkedIn!

Was this reply helpful? Yes No
Suggested answer

David_MA 14,614 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

You could probably use Power Automate for this, but it might not be the most efficient tool for the job. If Excel is your data source, I recommend using Excel’s built-in tools like pivot tables and charts to analyze the data and get the metrics you want. You can add filters to the pivot tables to pinpoint exactly what you’re looking for.

I haven't watched this specific video, but I have watched others produced by this YouTuber and he does a great job of explaining and demonstrating things in simple terms that are easy to follow: https://youtu.be/PdJzy956wo4?si=73LAG8p_cJ9RRBzX.

Additionally, edX offers several courses on using Excel for data analysis. I took one a few years ago, and it was really good. Here’s one you might find useful: RITx: Data Processing and Analysis with Excel | edX.

Was this reply helpful? Yes No