Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Power Automate - filte...
Small and medium business | Business Central, N...
Suggested answer

Power Automate - filter on received items : How to?

(0) ShareShare
ReportReport
Posted on by LizHK 132

Hi,

I apologize ahead of time for such a simple question but I am having difficulty finding right info.

I'm trying to send a simple email notification when an item of interest is received in our company.

I believe I have managed to create one with below trigger - but I don't want all the received items but only the ones that I am waiting for :

pastedimage1673896785555v2.png

For example:

1st time receiving  or OOS items

If this is not achievable I would like to have some updated excel or list in Teams and hope the power automate to match up with the list and only pull these.

Is there a good way to achieve this filtering?

Thank you so much!

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: Power Automate - filter on received items : How to?

    Hi, as far as I know, generally you should add Condition after this step to determine whether to execute it or not.

    More details: https://learn.microsoft.com/en-us/power-automate/add-condition

    pastedimage1673913247095v1.png

    Hope this helps.

    Thanks.
    ZHU

  • LizHK Profile Picture
    LizHK 132 on at
    RE: Power Automate - filter on received items : How to?

    I think I missed in my original post but

    first,filter:   

    linetype:  SHOULD BE Item

    Second filter : lineobjectnumber SHOULD BE either OOS items or list we have in SP or excel file or some list.

    When wee have the first shipment after item creation that'll be one (1st time receiving) or overall currently Out of Stock items.  (so basically current qty is 0). Otherwise we do send out OOS reports with regularly so we can update a list in SP if we can pull some filtering just from that list that matches item no. Thanks,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Power Automate - filter on received items : How to?

    How do you define the items you are waiting for?

    Is that f.ex. the purchase orders where the expected delivery date is exceeded ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans