cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SILVIA-T
Frequent Visitor

Send alert when a text in email is found in a sharepoint list

Hi,

 

I'm building a flow to send a message in teams to users for tenders they're working on, when we receive an email for that tender; and I'm having some problems to match email to the right item in the list:

 

- I've got a sharepoint list for all our public tenders, with fields "title" (for the tender number) and "gcservicios" with the user working on that tender.

 

- When we receive an email in an specified folder, I want to find in subject or body the "title", and then send a message in teams to the user specified in "gcservicios" field

 

- I've tried differents ways, but I copy the one i feel is the closest, because when I filter manually the value the flow works fine!

 

For example I've got this item in the list, with title "123456":

SILVIA-T_0-1623681842946.png

 

I may receive an email in a selected folder that contais "123456" in subject or in body.

This is the trigger:

SILVIA-T_1-1623681943032.png

 

I've built a variable "Expediente" in which I have both subject and body text:

 

SILVIA-T_2-1623682006793.png

I've opted out some emails from an account I'm not interested, and for the rest I get the items of the list:

SILVIA-T_3-1623682065253.png

 

Up to this point everything works fine. The issue is with the Filter Query, that doesn't get any results. A peek of the code:

SILVIA-T_4-1623682180202.png

SILVIA-T_7-1623682873857.png

 

And then the result, that is not achieved because the filter query doesn't get any item:

 

SILVIA-T_5-1623682291577.png

 

As i said before, if I filter the get items like this the flow works fine!

SILVIA-T_6-1623682476406.png

 

I've also tried without filtering the items: I get all items and built a condition whenever subject or body contains "Title", or whenever "Expediente" contains "Title" (I've tried both). This also works when I filter manually the get items to "123456", but doesn't work when none filter is set in get items. So I feel I must filter the items before setting the condition, but I can't figure out how.

 

Thanks a lot for your help

1 ACCEPTED SOLUTION

Accepted Solutions
SILVIA-T
Frequent Visitor

Hi,

 

Forget it, I've found the issue! I didn't know get items was limited to 100 items, so the item I was looking for didn't showed up, only when I filtered it. I've changed the limitations.

 

Now when I got all the items, I can filter later on conditions, and I don't really need to filter the query.

Thans a lot anyway, sorry for the trouble!

View solution in original post

2 REPLIES 2
SILVIA-T
Frequent Visitor

Hi,

 

Forget it, I've found the issue! I didn't know get items was limited to 100 items, so the item I was looking for didn't showed up, only when I filtered it. I've changed the limitations.

 

Now when I got all the items, I can filter later on conditions, and I don't really need to filter the query.

Thans a lot anyway, sorry for the trouble!

View solution in original post

Hi,

 

Thanks for your follow up post! Hopefully this will prove useful for future communities users who are having similar issues.

 

Regards,

 

Alex

 

-------

 

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,989)