
Announcements
Hi All,
how do I create a column and then populate it by concatenation in Power Automate?
for example, the excel sheet has First Name and Last Name . How do I create a new column called “Full Name” and then populate it by joining the First Name column and Last Name column for each row?
your help would be greatly appreciated.
Thanks
@Anonymous
There is no Power Automate action that does what you are asking. However, you can use an Office Script for Excel to add and populate the column.
Once you have the script, you can call/execute the script using the Excel Online Power Automate connector.