web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Lookup query between Purchase order Header V2 and Purchase order lines V2 in the power automate

(0) ShareShare
ReportReport
Posted on by
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:
  1. The query must filter purchase order headers where the Order Status is "Open Order" and the Document Approval Status is "Confirmed".
  2. The corresponding Purchase Order Lines data must be complete and aligned with the filtered Purchase Order Headers.
  3. 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!
 
Power automate configuration details

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 242

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 83 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 68 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans