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.
