How can it be shorter? Flow goes through far too many attachments to choose from.
The flow below sends a preparation assignment to the student 14 days before the start of the exam.
The Excel is first filtered (Filter Query in List rows) on exam date + 15 days.
Then it is filtered (Control) in the Apply to each on whether an Attachment is present (and therefore an email must be sent)
Then in the next Apply to each it is searched for the correct Attachment (Names are compared in Excel and File name in SharePoint).
The latter causes a problem: at the moment the folder only contains 22 Attachments, but that will eventually become about 150.
Can this be done more effectively and therefore faster?
