Share
ReportIn Dynamics 365 I have a "financial target" entity. It allows me to create a target for income against a person for a set year. i.e. against John Smith, create an income target of £10,000 for FY2020 and £12,000 for FY2021 (Financial years match calendar years). The fields are contact (lookup), financial year (option set), target (currency) and current total (currency).
I am then using a flow to populate the current total by looking for all income records associated with the same contact and dated in the relevant financial year.
To do this I am looking for all financial target records. Then, in an apply to all stage I am looking for all income records where the donor is the contact from the financial target record and where the income date has the same year as the financial year from the target. That is where I am having an issue. The financial year is expressed as "FY2020" and income date is a completed datetime field. I seem to be struggling with it. I know I need to use an expression but I struggle with using an expression in an odata filter. I need to match on the contact from the current item (i.e. the financial target record we are looking at) AND on all income records where the year of the income date matches the year from FY2020. This would then allow me to create another apply to all step where I can then go through all these income records to Sum them before moving onto the next financial target record and repeating.
Is this the best approach to do this? How can I list records comparing the year from a datetime to a string?
All responses (
Answers (
67
