How to select and copy the cell in Excel in the same row, the next cell, then use the cell value to find the file with that name in a folder, to copy the file and paste in WhatsApp.

(0) Share

Report

Posted on by fritserasmus

The flow successfully

1. opens WhatsApp Web,

2. opens a folder with the files (bills in pdf) I want to send via WhatsApp, and

3. opens an Excel file that is read sequentially. In that Excel are two columns:

Name range A has the Contact number

Name range B has the file name (of the bill in pdf)

Using the contact number (A) the flow search, find, and open the WhatsApp contact.

test this, I successfully sent the same text "Hello World" to each contact number in A.

I would like to use the value in A, select and copy the value in B next to A then find and copy the file from the folder (in 2) and paste that into WhatsApp and send it

This is my first flow, so I acknowledge I might struggle with the obvious

I would appreciate some help with this

Regards
Frits

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

HI
@fritserasmus
In for each
click on + symbol in watsapp
select by clicking the document by using click activity
then in use populate text in window activity and give currentitem[filename]
then click on open by using click activity
and click on send by using click activity

this flow already posted in your question before.

you can directly select the file by typing file name
Hope this helps

Was this reply helpful? Yes No
fritserasmus 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@UshaJyothi20 ,

I tried many different things but I just do not understand your instructions.
Attached is a doc with the steps I could take - you will see where I got stuck (#3)
Can you please elaborate on the instructions so I can understand it / or paste screens in the doc and upload the doc?
Sorry for me not getting what you explain

Instructions to s...

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please copy paste the flow in designing panel.

please change file path and URLs as required

Hope this helps
Usha

PAD_Flow.zip

Was this reply helpful? Yes No
fritserasmus 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@UshaJyothi20 ,
Can I check with you, as it seems like I am using something different from what you have:-

I am using Power Automate Desktop
https://learn.microsoft.com/en-us/power-automate/desktop-flows/console?WT.mc_id=powerautomate_inproduct_padconsole#console-settings

and

https://learn.microsoft.com/en-us/training/modules/pad-first-steps/?source=recommendations

In this video, it appears I should be using Flow Online to import.
https://www.youtube.com/watch?v=z7k9Vx4o9L4&ab_channel=BlackbaudSKYDeveloper
I have a Microsoft 365 version, not the school/work version

On my desktop version, there is no "import flow option"
If I go through the Microsoft online route, Microsoft web lets me know I must create a new environment, which I cannot do as I need a work or school account.
Seriously - Microsoft??? Really want to make it too hard for a single person to learn the products!

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I have send you text document
Copy tha text document and paste it in the designer panel of PAD
Open new flow and copy the text in designer panel

Was this reply helpful? Yes No
fritserasmus 28 on at

Like
a
(0)

Report
Copy link

Link copied!

I checked here in the chat for the file, my email, WhatsApp, Power Automate:- I cannot find a text file sent to me

Where to, have you sent the text document?

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I have sent you in this conversation please check full conversation it is named as pad flow text document

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

PAD_Flow.zip

Was this reply helpful? Yes No
fritserasmus 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Usha,

Thanks I managed to solve it

Was this reply helpful? Yes No