Unanswered

Filtering D365 FinOps data by time/date

(0) Share

Report

Posted on by MaxNicholas

Hi All,

I'm attempting to make a flow to retrieve data from D365, filter the results to return only entries from the last 7 days, then update rows in an Excel file. I'm halfway there, but I'm struggling to filter the content.

In the filter data operation I have set up (as per the attached screenshot) uses the CreatedDateTime field, then should be refined to the last 7 days as per the expression 'formatDateTime(addDays(utcNow(), -7))'. Running the flow presents an error message (as per seconds screenshot). What is a better way to go about this?

Thanks for any help!

Categories:

Building flows

Error details.png

Filtering.png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tj8000 21 on at

Like (1)

Report

Hello,

there was a similar issue raised here: https://powerusers.microsoft.com/t5/Building-Flows/Error-during-flow-Number-of-foreach-items-limit-exceeded-for/m-p/557313#M72702

The solution suggests that this is a limitation based on your licencing plan and you have to change your filter to get less results. Is there a way to reduce your result array by adding another filter? Or maybe you check for the size and if it is over 5000 then you can "split" the array? (A combination of take and skip might be an option here https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#take, https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#skip)

Was this reply helpful? Yes No
MaxNicholas 5 on at

Like (0)

Report

Hi there,

Thanks very much for the advise, I'll be sure to apply that as it seems like the perfect fit. Also thank you for the links, they're very helpful.

Was this reply helpful? Yes No