Power Automate

New to PA and lost with parse JSON for retrieve various data from Outlook shared mailbox

(0) Share

Report

Posted on by HW-20101722-0

Hello Community,

Im new to PA world and i'm having hard time to make my first flow.

The plan is to automate reporting from shared mailbox. The metrics that i need are :

For the inbox :

Total number of mails
Number of unread mails
Number of flagged mails
Number of mail categorized 1, 2, 3...
Number of mail received today...

For the sent item box :

Total number of daily sent
Number for mail sent by worker 1, 2, 3...

Lot of metrics.

For now i have various Outlook HTTP requests on the mailbox and it work to get almost all details but i'm stuck to get the proper details with parse JSON.

My idea is to make only 1 request on inbox and 1 on sent box to cover all my needs without multiplying requests...

Is it possible to count this values without array filter ? What will be the easiest method to do that ? All advices are welcome.

(for the record, i use Workflow from Teams)

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

David_MA 15,144 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I am not sure I understand what you need. You ask about a count, yet your initial question is about parsing JSON, but I don't see any Parse JSON action in your workflow. Do you just need to know the number of values returned from each of your HTTP requests? If so, that is relatively easy. For each one, you can use the length expression to find out how many items were returned. This is a good post that illustrates how to use the length function: Power Automate length() Function [How to Use] - Enjoy SharePoint

If that is not what you're asking, please clarify and show in your workflow where you are using Parse JSON and the problem you are having.

Was this reply helpful? Yes No
HW-20101722-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply,

The picture was for informal. Im actually multiplying the HTTP requests.

I Kept the Parse JSON in line but not use it as i dont know how to.

Multiplying request is not a good thing to me and i would rather use JSON.

My idea is : Get HTTP request -> Parse JSON to make data from request clean -> Counting items directely from that with lenght() fonction or something similar. (ex : lenght(filter(body('Parse_JSON')?['value'], item()?['isRead'] == false))

All i see is the array filter but just can make various array filter. Each time it offer me to use the "apply to each" fonction.

Was this reply helpful? Yes No