Hi guys,
I tried this quite a few times and I can't make it work! Please help.
Situation:
Table A: 'Opportunities'
Table B: 'Activities'
Connected via a one-to-many relationship via the 'Opp ID' field.
Basically, one Opportunity can have zero, one, or more Activities.
In table B, there is this Lookup column called 'Milestone'. There's also a column called 'End Date'.
In table A, I've created a column called 'Latest Milestone' (also a Lookup to the same table).
What I need:
Every time a row in table B is updated or modified or deleted, the 'Latest Milestone' column gets updated with the Milestone with the latest 'End Date'.
Like, Opp 123 has two activities, one with Milestone 'Started' on 'End Date' 1-Jan-26', and another with Milestone 'Working' on 'End Date' 1-May-26', I'd like the 'Latest Milestone' to be 'Working'.
What I tried:
Cloud flow with:
- 'When a row is added, modified or deleted',
Table name, 'Activities'
- 'List rows',
Table name, 'Activities',
Filter rows, _iu_oppid_value eq '@{triggerOutputs()?['body/_iu_oppid_value']}'
Sort By uu_enddate desc
Row count 1
- Condition
empty(outputs('List_rows')?['body/value'])
- If no: Update a row
Table name, 'Opportunities'
Row ID: @{triggerOutputs()?['body/_iu_oppid_value']} (so from the List Rows step above)
Outputs:
outputs('List_rows')?['body/value'][0]['_uu_onboardingmilestones_value']
I keep getting errors for the last step. URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment '2f2....' provided in the URL.
What's goin on?
