Hi there,
I have a flow that gets information from a SharePoint list where I am managing an onboarding tracker. The flow sends an individual email to each of the hiring managers once per week with status updates and it's been working fine. Please see the flow below:
This week it's been failing on one record though everyone elses appears to have been sent successfully and the only difference I can see is the manager has an email address with an apostrophe in it.
This is the step it's failing at and the error (with the email address changed for privacy)
Action 'Get_items_Filtered_List' failed: The expression "(LineManager/EMail eq 'Edward.O'Callaghan@powerautomate.com') and ((Status eq '1. Welcome e-mail sent (candidate to complete backchecks)') or (Status eq '2. Candidate completing consent forms') or (Status eq '3. Candidate completed consent forms, checks in production') or (Status eq '4. Backchecks complete, awaiting start date') or (Status eq '5. Start date confirmed, awaiting induction')) and ((BusinessArea eq 'London') or (BusinessArea eq 'Leeds'))" is not valid. Creating query failed.
Any help you can offer would be much appreciated
