As I went through the academy, I got more familiar with the tools, and tried it out. The courses are really helpful. I’ve learned a lot more but can’t say I’m an expert or anything so I could be presenting a less than optimal solution. I’ve added my blueprint which includes some extra steps because I was testing to see where the sorting would work.
The flow goes as:
monday - watch groups items
Array aggregator (mapped to JSON data structure)
JSON - Create JSON (array aggregator array)
JSON - Parse JSON
Tools - Set multiple variables (sorting happens here)
Iterator
Router
Microsoft Excel grabbing fields from the iterator
The sorting works this way and it made sense to me. I’ve tried doing the sorting in the iterator or JSON and thus saving some operations but it hasn’t worked for me. At least it would be something for reference.
Also the updating of the Excel rows is very sluggish. Not sure how to get around that.
blueprint (3).json (83.9 KB)