Answered

How to check if an email and date exist in Sharepoint list from form submission

(0) Share

Report

Posted on by teoooo

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:

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report

Re: How to check if an email and date exist in Sharepoint list from form submission

Hi @teoooo ,

Please try to run the Get items action without configuring Filter Query and get the field name in the Body.

Then configure these field names to Filter Query. This method only works if the type of the Email field is single line of text.

Regarding the format of the Date filed, the format in Forms and SharePoint List are the same, it seems that we do not need to format again.

Best Regards,
efialttes 14,756 on at

Like (0)

Report

Re: How to check if an email and date exist in Sharepoint list from form submission

Hi!

Is your flow trigger 'When a response is submitted in Forms'?

Can you share a screenshot from your trigger design?

As a general suggestion since we do not have your Flow details, you can use the Date Time connector and convert the UTC time from forms to your timezone and then use that value in your Sharepoint "Create item" action block

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

Please note 'Convert time zone' also offers Data Format maipulation options

Also as a general suggestion, formatDateTime() function can be used for Date format manipulations, as explained in this thread

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-change-Flow-date-from-YYYY-DD-MM-to-DD-MM-YYYY/td-p/183106

Thanx!