I have a SharePoint list of jobs to be completed. The list contains columns for requested date, requestor, and status, among additional details for the job. I would like to send an email to each requestor the day after the job is scheduled to ask if the job was completed, partially completed, or cancelled. I created a flow looking for any job with a request date less than today. I added a send email with options and an update to the list recording the status supplied in the email. However, this will only work if there is only one job requested/day. There could be multiple jobs each day for several requestors. Is there a way to send the email with options to all requestors that had a job that day without waiting for the first person to respond? Is there a different process in Power Automate that should be considered, a different way to look at this? I also looked at using the approval process, but that seems to wait for a response as well before sending the next email.
Thank you!