I have a list with the following information and I have a form where I want the flow to check if the email and Date in office = true, I will return the 'sign-in' value. Tried using 'filter query' in get items. Always encountered 'bad request'.
My guess is the format for both email and date. The date in list is mm/dd/yyyy, but the flow return is yyyy-mm-dd
Sharepoint list:
Name (as per AD work name), Email (as per AD work email), Date in office, Sign-in.
Form field:
Name, Email, Date in office, Sign-in
Flow:
