how i can extract the email address from the claim field inside the response message from "Get Items" action

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following Get Items action:-

where the response body will be as follow:-

now i need to extract the email address from the claim field as follow, where i need the email to be added inside "Grant access to item or file"? any advice how i can do such an extract?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Initialize the string variable. In it's value give "Email" from previous get items. It will store the email id in that variable and you can use this anyway you like

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@zmansurii can not directly get the email from the previous get items.. it will be empty, i need to get it from the response.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this, might need a bit of tweaking. Add a select action after get items. Then put it into text mode, in the from use the expression:

outputs('Get_items')?['body/value']

In the map use expression:

split(item()['ResponsiblePerson']['Claims'], '|')[2]

To put select into text mode, you need to press the little button next to the map section.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Paulie78 can you please provide a screen shot?
Thanks

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Looks like this:

Was this reply helpful? Yes No