web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Pasting data in Excel

Power Automate

Answered

Pasting data in Excel

(1) Share

Report

Report

Posted on by KS-20011436-0

2

I am copying and pasting data from one Excel-file to another using PAD.

The second Excel-file is formatted, and I therefore want to paste the data as values.

Giving that I have a Danish version of Excel, I normally have to use the letter 'Æ' for inserting the values.

This is not working with PDA.

Any suggestions?

Kind regards

Klaus Juul Soerensen

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

When pasting Æ in other excel - how does it appear ?

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @KS-20011436-0,

For Pasting Data as Values using Power Automate Desktop doesnot have direct action.To achieve this you can follow these below method.

You need to write or use this below macro in Excel to acheive this.

Sub APasteAsValues() ' ' APasteAsValues Macro Range("A6").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No

Join the conversation