Answered

Need some help with my Power automate Desktop flow.

(0) Share

Report

Posted on by Atlantis1

Hi Everybody.

I am trying to create a flow to simplify my daily workload. My scenerio is like this. I created a form with excel in order to fill in how many tools i need to order with that particular type and send an email to my supplier.

This is how i start my flow.

After all input dialogs have been typed in, it will type into my excel and will send an email to the supplier (i can do this part). My goal is to make a dynamic condition in my flow which will fill in amount of tool correspondly in excel. Meaning if Tool1 in excel form is moved into another row in the future PAD will always follow T1 row and fill in the amount at order column and continue so with other tools. Hope i make myself clear enough. Below is my exceldata from pad.

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

VJR 7,635 on at

Like (1)

Report
Copy link

Link copied!

Hi @Atlantis1

For your future reference this forum here is more inclined towards Power Automate Desktop.

Regarding the requirements I am not sure if I fully understood it but will give a try.

I guess you would like to dynamically search for T1 and enter the details in Order column next to T1.
If so, you could use the Find functionality.

Let's search for 2 in Column A and write something next to it in Column B.

After launching the Excel, Find for 2.
This will return the RowIndex and ColumnIndex on the cell it was found.

Since our Search data is in the 1st column, we need to add 1 to the column index for writing the result into the next column ie; Column B

After the flow finishes it will write TWO next to where it found 2.

Was this reply helpful? Yes No
Verified answer

Atlantis1 74 on at

Like (1)

Report
Copy link

Link copied!

Thanks @VJR again for your support. I will test it out and let you know if there is any hiccup. But you did understand what i´d like to do with my flow.

Regarding posting question. Next time i will post it on the section you mentioned. Thanks for pointing out for me. There are a lot to learn for a newbie.

Just test after your recommendation. Flow is exactly what i am looking for and it is a much cleaner flow. Thanks again.

Was this reply helpful? Yes No