JSON filtering & Conditions Question(s).

(1) Share

Report

Posted on by CU04101917-0

Hi All,

I am trying to setup a flow that works a two step proces.

Step 1 is to get the current employees from our CRM system using a HTTP request, to filter this JSON Array and then proceed to,

Step 2 which, should be iterating through the items and do another HTTP request to get the status of their hours reporting.

So-far I am able to filter the output of the first HTTP request with a condition (the CRM System has some system users) to filter only users with a name. (length(items('Apply_to_Each')['name']) > 0) as this is a array PowerAutomate does create a 'Apply to each'. The 'True' section thus leads to the second phase of the puzzle where I lose the understanding and therefore have my questions.

1. The JSON output of the 'Parse JSON - Fetches hours submission status, by date, for an employee' does not contain the Name nor E-mail which I need for the Teams bit, how do I forward that on?

2. The JSON output of the 'Parse JSON - Fetches hours submission status, by date, for an employee' contains 7x a 'submitted' leading to 7x a 'thanks' or 'action please' message, how can I limit it to one time?

Thanks in advance for your feedback.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi

Can you share what your JSON looks like so its easier to answer.

Thanks

Was this reply helpful? Yes No
CU04101917-0 4 on at

Like (0)

Report
Copy link

Link copied!

Ok, so I managed to solve no. 1 by adding a compose action. (see the updated flow here:) (added some comments hence no new desiger ;-))

The JSON / Output the HTTP action provides is:

{

  "data": [

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-09-30",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-01",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-02",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-03",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-04",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-05",

      "status": "submitted"

    },

    {

      "employee_id": "employee:4e4584c93e7e2bf1",

      "date": "2024-10-06",

      "status": "submitted"

    }

  ],

  "errors": null,

  "debug": null

}

The JSON, Compose 3 (in the apply to each), provides to solve no 2. is the following:

{

  "id": "employee:4e4584c93e7e2bf1",

  "label": "",

  "work_email": "first.last@domain.com",

  "employment_status": "active",

  "name": "First Last",

  "status": "submitted"

}

So now I am trying to get the 7x submitted to be limited to one, any suggestions?

Was this reply helpful? Yes No