Power Platform Community Forum Thread Details

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.

Categories:

Building flows

Hi BD-13120527-0 ,

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