Unanswered

Send keys not keys in all characters in my variable

(0) Share

Report

Posted on by Community Power Pla...

I am performing a action for keying some text in a excel restricted access popup when I enter text using send keys PAD misses out few characters while typing. Is there any workaround for this issue ?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

VJR 7,635 on at

Like (0)

Report

- Check with "Delay between keystrokes"

- another option to enable "Send Text as hardware keys"

- try with either separately or a combination of the above two

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have already tried all the options available but no use

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Please share what are you referring to as "excel restricted access popup".

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Steps as follows :

open any excel > click File > click info > click prohibited access > select restricted access > you will get a popup to enter names to allow access to. I am facing send keys issue here I tried all the options available in it but still it’s randomly missing characters to key in

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

You can try various options but if they do not work also take a look at doing it via VBA. Something like this

https://docs.microsoft.com/en-us/office/vba/api/office.permission.add

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

I have managed to resolve this by using Focus text feild to focus the text feild i wish to key-in for and then setting value to clipboard and writing it back in text feild by using send keys as '{Control}({V})'.

Thanks all for your help on this issue.

1 people found this reply helpful.

Was this reply helpful? Yes No