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