web

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

News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows how to create flow of ...

Power Automate - Building Flows

Answered

how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

Like (0) Share

Report

Report

Posted on 6 Oct 2021 06:53:28 by Akashdeep

57

All responses Img

All responses (7)

Answers Img

Answers (2)

Verified answer

VJR 7,635 on 06 Oct 2021 at 12:17:30

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

The entire flow at a glance looks as below

Expression in Compose 1 is
replace(replace(item(),'My name is ',''),'I am from ','')

Expression in Compose 2 is
split(outputs('Compose_1'),'.')

There are 2 Expressions in Compose 3

trim(outputs('Compose_2')[0])
trim(outputs('Compose_2')[1])

Output after running the process

Loop Iteration 1 shows both Name and Place:

Loop Iteration 2:

I have just printed the Name and Place using a Compose statement.
I have used a space in between the above Trim expressions, therefore there is a space in the output above in yellow. You are anyways not going to print it that way. Refer below.

After the above steps you need to write to the excel.
The Excel part should come within the loop.

To write the Name use: trim(outputs('Compose_2')[0])
To write the Place use: trim(outputs('Compose_2')[1])

You will find the ways to write to Excel in this forum itself.

Good luck!

PS: you had marked a different post as a solution.
This is the post that should be marked as a solution so that users of the forum directly jump to this post.
Akashdeep 57 on 06 Oct 2021 at 11:47:54

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

yes i am looking for solution and it contains two strings .
VJR 7,635 on 06 Oct 2021 at 11:23:49

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

Hello @Akashdeep
Are you still looking for a solution on the posted array Or have you figured it out?

If not then please provide a response:
Will this array always contain two strings as shown in your example?
Akashdeep 57 on 06 Oct 2021 at 10:28:13

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

it is an array
Verified answer

VJR 7,635 on 06 Oct 2021 at 10:07:18

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

Hello @Akashdeep

Can you reconfirm that the first brace is a circular brace "(" whereas the ending one is a curly brace "}".
This needs to be clear whether it is an array or a string or json so that readymade built-in functions and actions can be used.

Also will there be always two examples like the one you showed?
Akashdeep 57 on 06 Oct 2021 at 08:35:26

Like (0)

Report

Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

i am passing this from variable and i want only name and place from this variable in compose and that names and places added into excel
VJR 7,635 on 06 Oct 2021 at 07:49:35

Like (0)

Report
Re: how to create flow of add data in row in excel sheet using compose action , In compose action i have used array of string like ("my name is akash. i am from jammu"), i want only name and place added in row from this line used in compose .

Hi @Akashdeep

Could you please share what is the exact output from the compose. Is it a string or an array, json, etc?
The text content of your output would help.

What are the dynamic content returned from the Output of Compose?

Also is this format always going to be fixed?
my name is <Name>. i am from <Place>

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 2

#2

David_MA 436 Super User 2025 Season 2

#3

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans