web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split DevOps query val...
Power Automate
Unanswered

Split DevOps query value by delimiter and enter data into excel

(0) ShareShare
ReportReport
Posted on by 93

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:

hjoshi4u26_0-1675246136512.png

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:

hjoshi4u26_1-1675246586794.png

But I am facing the error as shown below:

hjoshi4u26_2-1675246656289.png

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

Categories:
I have the same question (0)
  • Verified answer
    Chriddle Profile Picture
    8,416 Super User 2025 Season 2 on at
    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.

  • hjoshi4u26 Profile Picture
    93 on at
    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 😞

  • Verified answer
    Chriddle Profile Picture
    8,416 Super User 2025 Season 2 on at
    Re: Split DevOps query value by delimiter and enter data into excel

    here you go

    Chriddle_0-1675251043632.png

     

  • Chriddle Profile Picture
    8,416 Super User 2025 Season 2 on at
    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]).

     

  • hjoshi4u26 Profile Picture
    93 on at
    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..?

    hjoshi4u26_0-1675253510425.png

     

  • Chriddle Profile Picture
    8,416 Super User 2025 Season 2 on at
    Re: Split DevOps query value by delimiter and enter data into excel

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

  • hjoshi4u26 Profile Picture
    93 on at
    Re: Split DevOps query value by delimiter and enter data into excel

    Ok got it. Thanks 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard