cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamieVS
Frequent Visitor

Match 2 Items in the same SharePoint List

Hello all,

 

This may be an easy one but I'm stuck. I've been asked to build something in PowerApps that will randomly introduce two people in the business based on their location and availblity in order to foster closer working relationships. I have setup a SharePoint List with the following columns: Created by, Created, Location, Week commencing (and maybe Assigned to). Bascially, if the Location and Week fields match, I want an automated email to go out to both users giving them the contact details of each other. I am thinking that i may need the Assigned to field for this.

 

Is this possible at all or am I going down the wrong path?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

You are welcome 🙂

 

Please try it without the "<" and ">". It was just to quickly show where the values should have been. 😉

Please surround your values with a ' like that: 

Location eq 'Midwest'

It was a dirty description of a quick hack. Sorry!

 

The ",Top: 1" means that you should put a "1" into the field "top count".

 

Sometimes it's a bit tricky to produce a well formed query filter...

Maybe this source will help you:

https://www.chakkaradeep.com/2018/05/01/deep-dive-into-get-items-and-get-files-sharepoint-actions-in...

 

Best regadrs

Stefan

View solution in original post

5 REPLIES 5
StefanR
Advocate IV
Advocate IV

Hi @JamieVS ,

 

This a raw structured idea that comes to my mind.

 

1. try to trigger the flow when an ShrePoint listitem is created or modified.

2. get the location and Week from that outcome 

3. Get all listitems filtered by the location "Location eq <Your Value> and Week eq <Week>", Top: 1

4. Send an email to the Person that is in the triggered SP ListItem and the one, you have got from the request of step 3.

 

I hope that will fit your needs!

If you still stuck on creating the flow, i will try to deliver a more detailed description.

 

Best regards

Stefan

 

 

JamieVS
Frequent Visitor

Hi @StefanR ,

 

Thanks for the quick suggestion; I follow what your logic but I can't get the filter to work. I think that I may be misunderstanding/oversimplyfying Steps 2-3: 

 

test.png

You are welcome 🙂

 

Please try it without the "<" and ">". It was just to quickly show where the values should have been. 😉

Please surround your values with a ' like that: 

Location eq 'Midwest'

It was a dirty description of a quick hack. Sorry!

 

The ",Top: 1" means that you should put a "1" into the field "top count".

 

Sometimes it's a bit tricky to produce a well formed query filter...

Maybe this source will help you:

https://www.chakkaradeep.com/2018/05/01/deep-dive-into-get-items-and-get-files-sharepoint-actions-in...

 

Best regadrs

Stefan

View solution in original post

 

Hi @JamieVS ,

 

Like:

71.PNG

Also please check this blog and get more details about Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @StefanR & @v-bacao-msft ! All working now. Appreciate the help

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,120)