Power Automate

3 Key Combination is Not Working

(1) Share

Report

Posted on by AP-13091506-0

hey there,

I am trying to send Control+Shift+~ in excel to change the cell format to General. I have tried:

{Control}({Shift}(~))

{Control}({Shift}({~}))

{LControlKey}({LShiftKey}({~})) --- per another help article

{Control}({Shift~}))

None of these are working, they either do nothing, bring up a weird paste menu or type in { or ( { in to the cell.

thanks for your assistance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Sih,

Did you use magic or did you use a SQL connector, or did you send email to it?

I don't know as i dont see anything but words :-(.

Sorry its late and 95% of people do not share when its clear sharing the flows etc so we can see them makes the most sense.

Was this reply helpful? Yes No
Suggested answer

Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
As far as I am aware these type of keys need to be nested within the Power Automate Desktop flow Send keys action.

Also tilde should be a special OEM key called Oemtilde

https://learn.microsoft.com/en-gb/power-automate/desktop-flows/actions-reference/mouseandkeyboard#valid-keys

Can you try the below?

{Control}({Shift}({Oemtilde}))

Was this reply helpful? Yes No
Suggested answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

,Hi AP-13091506-0

Just try to keep this formula in some notepad then open notepad and select this notepad text(forumala) in clipboard then you can paste the values into excel using clipboard values.

Try this approach and let me know if you face any issues.

Thanks,

Deenu

Was this reply helpful? Yes No
AP-13091506-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus YES! thank you. I had nested, in the second attempt, but didn't know I had to write out the OEM command. Thanks so much! I am trying to select your as the solution, but the page is being stubborn. I will try again in a bit

Was this reply helpful? Yes No