web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Using Flows Create a column and po...

Power Automate - Using Flows

Unanswered

Create a column and populate it by concat in excel

Like (0) Share

Report

Report

Posted on 7 Nov 2022 20:44:32 by Community Power Pla...

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

Categories:

Business Process Flows

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

ScottShearer 25,240 Most Valuable Professional on 07 Nov 2022 at 20:51:36

Like (0)

Report

Re: Create a column and populate it by concat in excel

@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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 655 Super User 2025 Season 2

#2

Tomac 371 Moderator

#3

chiaraalina 276

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans