Split DevOps query value by delimiter and enter data into excel

(0) Share

Report

Posted on by hjoshi4u26

Hi. I am new to power automate. I have a task to fetch the data from DevOps Queries and then enter it into an online excel file. When I fetch the data from DevOps Queries the output is something like as shown below:

The "System.AssignedTo" contains "Name Surname <Email>"
for eg., "System.AssignedTo": "Name Surname <abc@xyz.com>"

I need to split the data by a (space) into 2 outputs i.e Output 1 = Name Surname and Output 2 = abc@xyz.com.

Enter the data of Output 1 in 'Name' excel column and Output 2 in 'Email' excel column.

I have created flow as shown below:

But I am facing the error as shown below:

I do not know what I am doing wrong here. Can anyone please help me in this..? Any help will be much appreciated.

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Chriddle 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

item() is null there because you are not in a loop.
Use the output of "Get query results" ("body/values") as input for an "Apply to each" loop, place the compose action inside and try again.

Was this reply helpful? Yes No
hjoshi4u26 93 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

Sorry if I sound like a noob but can you please share the screenshot here..? I am getting confused a lot here 😞

Was this reply helpful? Yes No
Verified answer

Chriddle 8,339 Super User 2025 Season 2 on at

Like (1)

Report

Re: Split DevOps query value by delimiter and enter data into excel

here you go

Was this reply helpful? Yes No
Chriddle 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

By the way, if you're not sure if there might be a middle name, title etc. in the name,
I would rather split the string at " <" (and remove ">" from [1]).

Was this reply helpful? Yes No
hjoshi4u26 93 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

Got the output as showed in the screenshot. But how do I get it into excel..?

Was this reply helpful? Yes No
Chriddle 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

E.g. with the Excel Online action "Add row into a table".

Was this reply helpful? Yes No
hjoshi4u26 93 on at

Like (0)

Report

Re: Split DevOps query value by delimiter and enter data into excel

Ok got it. Thanks 🙂

Was this reply helpful? Yes No