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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (28,486)