Find other items with same SharePoint date column value

[PhilD]

Flow triggered by for selected item. Would like to perform actions on items in list that have the same meeting date as the item the flow was triggered on. Every combination I tried does not work but I'm not sure why, either no items are returned or it retries and says bad gateway or bad request. The dates must be in the same format as both sides of the comparison reference the same column... why is this so hard?

Below shows what I would like to do but it can't work (Meeting_x0020_Date and 'Meeting Date' are both the same date column in the SP list)

[v-yuazh-msft · Accepted solution]

Hi @ PhilD,

Please take a try to add an apply to each and a condition to achieve your needs.

I have made a test on my side,I have created a sharepoint list with a singleline type column Council Committee and a date type column Meeting Date.

The screenshot of my flow as below:

The expression in the Condition as below:

@and(equals(items('Apply_to_each')?['Council_x0020_Committee'], body('Get_item')?['Council_x0020_Committee']),equals(items('Apply_to_each')?['Meeting_x0020_Date'], body('Get_item')?['Meeting_x0020_Date']))

The flow would run successfully as below:

Regards,
Alice Zhang

[PhilD]

Thanks @v-yuazh-msft 

This works as expected. I'm sure I wouldn't have gotten here without your help!