Unanswered

Problems with Send Keys when there are new lines

(0) Share

Report

Posted on by zkcid

hi, I have a problem that is quite confused. When I take data from Excel with a long sentence, then I use "Send Keys" The result is that every new line will turn into? But when I use the Display Message it does not appear. Does anyone know my problem here?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Why do you want to use send hot keys...if you want to split the text you can use split text and populate text on field.
otherwise please explain the scenario little bit more.
Hope this helps
Usha

Was this reply helpful? Yes No
Lateef 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zkcid ,

i would really suggest to use "Read from Excel Worksheet " Actions form Excel activities instead send keys and you can play around with the output data from " Read from Excel Worksheet " like : ExcelData such as spliting text, joining text etc etc , send keys always gives negative error on excel.

hope this make sense,
Lateef

Was this reply helpful? Yes No
zkcid 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I just want to copy text from Excel to Word. Every time there is a new line a "?" sign will appear. and until now have not found a solution. but there is another alternative by editing the format in Excel.

Was this reply helpful? Yes No
zkcid 8 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the advice. I'll try later

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

Like
a
(0)

Report
Copy link

Link copied!

Could you please share a sample excel and mention what text you want to copy
so that I just give a try and get back to you.

Was this reply helpful? Yes No
zkcid 8 on at

Like
a
(0)

Report
Copy link

Link copied!

The file is no longer there, because my hard disk was damaged a few days ago. 😅

Was this reply helpful? Yes No