cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dogemaster
Level: Powered On

Save Email strings and send approval

hello Cat Happy

 

I'm building a Flow that get elements from a list from a URL, and therefore I can't access the column fields automatically. The list I'm trying to access contains a Title(name) and a Person field. I need to access each of the persons email and use this email in an approval.

111111.PNG

 

The "get elements" returns a big JSON, and I need to parse this in a smart way, and maybe save the emails to a variable. I only need each mail under each Person "object".

 

[
  {
    "@odata.etag": "\"3\"",
    "ItemInternalId": "1",
    "ID": 1,
    "Title": "Person",
    "Person": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Person",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Person#Claims": "i:0#.f|membership|email",
    "Modified": "2018-11-30T07:51:00Z",
    "Created": "2018-11-29T12:41:31Z",
    "Author": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "name",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Author#Claims": "i:0#.f|membership|email",
    "Editor": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Person",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Editor#Claims": "i:0#.f|membership|email",
    "{Identifier}": "Lists%252fGodkjennere%252f1_.000",
    "{IsFolder}": false,
    "{Link}": "www.somelink.com",
    "{Name}": "Name",
    "{FilenameWithExtension}": "Name",
    "{Path}": "Lists/Godkjennere/",
    "{HasAttachments}": false
  },
  {
    "@odata.etag": "\"2\"",
    "ItemInternalId": "2",
    "ID": 2,
    "Title": "Name",
    "Person": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Name",
      "Email": "email",
      "Picture": "www.somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Person#Claims": "i:0#.f|membership|email",
    "Modified": "2018-11-30T07:51:17Z",
    "Created": "2018-11-29T12:41:52Z",
    "Author": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "name",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Author#Claims": "i:0#.f|membership|email",
    "Editor": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Name",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Editor#Claims": "i:0#.f|membership|email",
    "{Identifier}": "Lists%252fGodkjennere%252f2_.000",
    "{IsFolder}": false,
    "{Link}": "https://somelink.com",
    "{Name}": "Name",
    "{FilenameWithExtension}": "Name",
    "{Path}": "Lists/Godkjennere/",
    "{HasAttachments}": false
  },
  {
    "@odata.etag": "\"2\"",
    "ItemInternalId": "3",
    "ID": 3,
    "Title": "Person 2",
    "Person": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Person 2",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Person#Claims": "i:0#.f|membership|email",
    "Modified": "2018-11-30T07:51:27Z",
    "Created": "2018-11-30T07:18:01Z",
    "Author": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Name 1",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Author#Claims": "i:0#.f|membership|email",
    "Editor": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
      "Claims": "i:0#.f|membership|email",
      "DisplayName": "Name 1",
      "Email": "email",
      "Picture": "https://somelink.com",
      "Department": null,
      "JobTitle": null
    },
    "Editor#Claims": "i:0#.f|membership|email",
    "{Identifier}": "Lists%252fGodkjennere%252f3_.000",
    "{IsFolder}": false,
    "{Link}": "https://somelink.com",
    "{Name}": "Name 1",
    "{FilenameWithExtension}": "",
    "{Path}": "Lists/Godkjennere/",
    "{HasAttachments}": false
  }
]

 

My Flow:

flow.PNG

 

Hopefully someone can help me, appreciate any help I can get Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
dogemaster
Level: Powered On

Re: Parse JSON - get elements from link

UPDATE

 

Now I get the Emails, but now I overwrite the variable with a new email everytime, is there a way to save the email strings into an array and then use the array in the approval?

 

 

overwrite.PNG

View solution in original post

1 REPLY 1
dogemaster
Level: Powered On

Re: Parse JSON - get elements from link

UPDATE

 

Now I get the Emails, but now I overwrite the variable with a new email everytime, is there a way to save the email strings into an array and then use the array in the approval?

 

 

overwrite.PNG

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 482 members 6,403 guests
Please welcome our newest community members: