Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

In Power Automate Desktop, how would I do a right click in an Excel cell and select a menu item?

(0) ShareShare
ReportReport
Posted on by 2

I'm trying to build a flow that copies data from one sheet to another sheet. The data that is being copied is a calculated formula. I'd like to copy the values and not to formula for various reasons.

I have figured out how to copy the data in Power Automate. However, when I paste it in, it comes in with the formula.

I was thinking I could do a UI automation and do a right click on the excel and select the option to paste in text.

However, I'm not sure how to do that.

  • Suggested answer
    Robu1 Profile Picture
    Robu1 996 on at
    In Power Automate Desktop, how would I do a right click in an Excel cell and select a menu item?
     
    Thank you for choosing Microsoft Community.
     
    Copying values instead of formulas in Power Automate can be a bit tricky, but it's definitely doable. 
    Here are a couple of approaches you can consider:
     
    Using Power Automate Actions

    Get the Data: Use the "Get a row" or "Get rows" action to retrieve the data from your source sheet.
    Compose Action: Use the "Compose" action to store the values. This will strip out the formulas and keep only the values.
     
    Insert Data: Use the "Add a row" or "Update a row" action to insert the values into the destination sheet.
     
    Using UI Automation

    If you prefer to use UI automation to handle this, you can simulate the right-click and paste as values.
     
    Here’s a basic outline of how you can achieve this:
    Launch Excel: Use the "Launch Excel" action to open your Excel file.
    Select Cell: Use the "Select Cell" action to navigate to the cell you want to copy.
    Copy Data: Use the "Send Keys" action to simulate pressing Ctrl+C to copy the data.
    Right-Click and Paste: Use the "Send Keys" action to simulate a right-click and navigate the context menu to select "Paste Special" and then "Values".
     
    If this fixes the issue, please mark as resolved to help others with find it.
     
    Happy to help 
     
    Robu 1

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard