Answered

Reading Excel Data and Variables

(0) Share

Report

Posted on by narfff

Hi all,

Very new to PAD - been reading and watching as much as I can. I have a flow that I'm working on and have hit a roadblock.

The premise is for the user to input a job number, PAD finds the job folder on our network based on said number and opens an accompanying excel file.

(The excel is basically an inventory list of items for said job, and the user here is marking whether or not that item is complete)

I've gotten PAD to do everything up to this point - I was wondering what direction to go from here.

I need it to read the number of rows in the excel file (pretty sure I've got that down [first free row?]), then based off that dynamic number read each of those rows and check column 18 or 'R' in excel, for the completion status.

If complete = true then it needs to copy columns 1,3,4, etc for each row and paste that text somewhere... outlook most likely.

I know this is a lot - if anyone can point me in the right directions it would be much appreciated.

FLow FLow

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

DSB Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello - the following short videos might help:

Read from Excel
Loop through excel

Note that you can get your row count from the Read from Excel action output %"VariableName".RowsCount%
Sounds like you'll need a loop and an 'If' condition to check whether the column within a row is empty, and if so then populate it with something. Let me know if this helps.

Thank you.

Was this reply helpful? Yes No
narfff 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for the response it helped a lot.

This was the loop I came up with, seems to be working! Now I just need to clean up the outputted text a bit.

Was this reply helpful? Yes No