Forum Discussion
Have Excel substitute text with as the text is added to a sheet
I have a Power automate converting my emails into an excel file. The email alert gives me my employee in a username format, the power automate just reads the email, captures what it needs too and add...
Try use Power Query in Excel. Maybe this aproach will be better for your case.
You could put your data from Power Automate into a Named Table, then read this table to Power Query, replace user.names and then finishing load ETL Data into another Spread Sheet.
You could put your data from Power Automate into a Named Table, then read this table to Power Query, replace user.names and then finishing load ETL Data into another Spread Sheet.