Create a dual Excel list

(0) Share

Report

Posted on by jkingno1

141

Hi,

I have 35 images to sort, they each contain an image which says the company name (e.g. Kilzipore) and the file name is the Job number_(Random number) E.g. 34572_4383. I would like to create a flow that Logs the Job number (The first 5 numbers) and the Company name next to it (The Job # is in its own cell and the Company name is in its own cell next to this Job number). This needs to log all 35 Jobs in a list format (It isn't always 35 can be as many as 200 or more etc).

I know how to get the variables for the Company name (with OCR) so don't worry about that, and getting the variables for each file is obvious enough with 'Get files' (With a Subtext regular expression for the first 5 only. What I don't know is how to log this data correctly to excel in this above described list format.

Does anyone have an idea on how to create this flow? I have already tried and have yet to get something working.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @jkingno1

You should try this approach

First you have to initialize a datatble variable using set variable like with below,

Here i am assuming there are only two columns Company Name and Job Number,

next, loop through each file and extract the company data and job number and add it to the datatable like below

Here i am assuming that company data and job id is stored in strCompanyName and strJobId variable.

Outside of loop, use write to excel action to write dt1

Hope this helps you
Mark it as solution if it resolves your query 🙂

Was this reply helpful? Yes No
jkingno1 141 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

I have done what you've shown, and seems to work well but the Excel only puts the data in A1 and doesn't list it. Could i be doing something wrong? Ill attach some images below of my results 🙂
Thanks!

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @jkingno1

Check whether you have assigned dt1/datatable variable correctly

adding data to dt1

Try this

Let me know whether it worked

(Note: there is change in flow with respect to headers, earlier headers where specified in datatable while intializing it using set variable using ^ symbol, but i have observed that while writing data to excel using write excel action, it won't add headers, so to resolve that issue, i have added headers as value while intializing datatble and so headers appears. )

Was this reply helpful? Yes No
jkingno1 141 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar
I just saw that and have corrected my mistake, it now works almost exactly how i want, although it list all data only in the A1 column down, with the company name first, then the Job number. Id prefer if the data was beside one another. Again i may have something slightly off, but heres some images of the data i got.

Thanks!

Was this reply helpful? Yes No
Verified answer

jkingno1 141 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

I have made this change to your flow and it does exactly what i need it to, again thanks for your help, i appreciate it a lot.

Was this reply helpful? Yes No