@Hu_Li-_-  most likely a CORS issuehttps://stackoverflow.com/questions/77279755/office-script-in-excel-365-failed-to-fetch-for-some-urls While hitting the API with a browser works, it does not when you e.g. use javascript to make the API call...  Best I got is to use Fusion as your endpoint for Offi...

You could use the user collection workitems and sort them by task:actualCompletionDate

Lol MAP!! Brilliant - I guess it was too late for me last night  My only thought is that if you modify the object like I described, you do it once, and then reference any property downstream.But if your solution works - awesome. Much more elegant than my ugliness. 

Hi @Nevalee_Hedges That does sound klunky.  I'm curious: If the Ops team assigns their desired resources - why wouldn't the team lead just use the Workload Balancer to reshuffle work?  

Hi @FranciscoRuiz It's doable but it's ugly. In short: Don't use field names that contain periods....Due to the limited tools available in Fusion, if you want to access a property on an object you'll need to convert the collection to a JSON stringreplace the keys so they don't contain a periodconver...

Hi @LukaszMatyszewski I can replicate that - apparently external lookups cannot be bulk-edited  without Fusion.I would raise a ticket for that. 

One thought: You can do one search instead of first parent task and then children: search for tasks where DE:PSRA_Mod=notblank and parent:name=CPS But my question remains - how do you define "the most recent projects that user/contact has worked on"?the projects user/contact has worked on - that are...

Hi @LauraCr  So there are cases where a task may be assigned to multiple people, e.g. "do prep for presentation". You do this to let anyone who contributes log their time. When they say "Work on it" it doesn't affect other assignee's Work Lists. On the other hand a Team assignment is used when you h...

Hi @OmahaOmaha  I think you mean "Module" where you say "scenario" right? I don't see anything that tells me how you're getting the list of projects. The key will be how you define "10 most recent projects a user worked on"We can use assignments - but that's the "most recent tasks" a user was assign...

Hi @Mylah The only simplification i can think of is to use the length() function in fusion. On the filter you could say  length( { the approvals array from the readRecord module } )Numeric: equals0 (zero)-----Or, use the status value: Check the module that gets the event: You can filter for status n...