cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Kingpin
Kudo Kingpin

Find other items with same SharePoint date column value

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)

 

GetItems.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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:

Capture.PNG

 

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:

Capture.PNG

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
Community Support
Community Support

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:

Capture.PNG

 

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:

Capture.PNG

 

Regards,
Alice Zhang

View solution in original post

Thanks @v-yuazh-msft 

 

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (79,077)