Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 118

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!

Categories:
Other
Inventory and warehouse management
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,477 Moderator 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 118 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,718 Moderator 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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans