Power Platform Community Forum Thread Details

Building a power app that connects via the Fin & Ops Apps (Dynamics 365) connector to Dynamics 365 Finance and operations.

What I am trying to do.
Pull out a list of all sales orders from the last 2 days that have a certain item in them.

Use that list to create a temporary collection.

Push that collection as a csv file to a network folder where another (non powerapp) program picks the csv file up and uses it to produce packing labels.

Change the 'Shipment Status' of that order to Shipped.

What I have achieved
Pulled the orders.
Found the items.
created a csv
pushed it to network folder.

BUT
I did that using the connector and connecting to the 'D365SalesOrderHeaders' and the 'SalesOrderLines' tables (which, it turns out, just to confuse matters are not tables but actual D365 entities!!... but, that doesnt matter, I got there 🙂

I suspect to get the shipping details I shouldnt be connecting to the Sales order headers and lines but to Warehouse tables.
Trouble is ...
Using the power apps Fin & Ops Apps (Dynamics 365) connector I cant see any 'table' that represents the warehouse header or line info.

so...
I thought, maybe once I have my list of Sales orders that I want to change the shipping status to 'shipped' I could use a flow but.... am relatively new to flows, I wrote one to do the 'Export a CSV to a network folder' bit but, I dont know where to start to be able to 'take a sales order number, go in to FinOps and change the shipping status to shipped'..

Apologies for the lengthy 'what I want to do' question..... 🙂
Hope someone out there has a few pointers.
thanks in advance.

Categories:

Building Power Apps