Hi All, I am a beginner in Power Automate and have received a requirement to provide open arrival purchase orders every 7 days. These will be used by a third-party application for our client. Here is the requirement I need help with:
The query must filter purchase order headers where the Order Status is "Open Order" and the Document Approval Status is "Confirmed".
The corresponding Purchase Order Lines data must be complete and aligned with the filtered Purchase Order Headers.
A batch job must automatically sync the open arrival purchase order information for the upcoming 7 days into the PurchaseHeader and PurchaseLines tables.
I would really appreciate any guidance or support on how to implement this in Power Automate. Thanks in advance!
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.