cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SILVIA-T
Helper I
Helper I

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
Helper I
Helper I

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
Helper I
Helper I

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!

alrez
Community Support
Community Support

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (6,284)