Within Power Automate I am trying to make SINGLE(paginated) call to Dataverse to get the list of Work Orders with the particular status linked to Account but not directly but via extra layer. Also, I can retrieve extra lookup tables which are required by logic.
All in a single call because making extra API calls is expensive and evil!
The FetchXML query looks like one below:

Continue Reading Olena Grischenko (she/her)’s Article on their blog
Power Automate with Dataverse: Saving API calls to Dataverse. Expand or Link-Entity?
Within Power Automate I am trying to make SINGLE(paginated) call to Dataverse to get the list of Work Orders with the particular status linked to Account but not directly but via extra layer. Also, I can retrieve extra lookup tables which are required by logic. All in a single call because making extra API calls…
Blog Syndicated with Olena Grischenko (she/her)’s Permission
More About This Author
Array
YouTube2022.11.275 reasons to love Power Pages – Sydney Microsoft BizApps Women November 2022 – YouTube
Power Automate2022.11.20Generating simple and complex documents with just Power Platform, no add-ons.
Power Automate2022.09.28Power Automate w Word Online: generate document updates
YouTube2022.09.23BizApps Women August event Meeting Recording – Re-start Your Career w Power Platform – YouTube