Dynamics Community Forum Thread Details

Hello

I'd really appreciate your insight how to achieve in power auotmate.

I am trying to create an automated flow to move away from manual work for the business. I encountered three problems. If you could refer below current practice steps:

1. Automate flow works to write item batches, this has no problem.

2. Couldn't figure out the way to reset those dates using cloud flow. The logic is to simply override with null values for those dates from "Item batches" data entity when update a record in cloud flow. It does not accept null value. Error msg attached.

3. To create a header record, I have to ensure the next number of the journal number sequence. "Number sequence code V2" data entity has the information, but it is not found in power automate. I can only find it in DMF.

4. "InvenotryMovementJournlaEntriesV4" does not accept null value

In power automate, it seems following fields are required: Configuration, Color, Size, Version, License plate, GTD number, Owner, Inventory profile, Line number (I would hope it would auto increment)

We enter nothing in "Inventory movement journal headers and lines V4" data entity template if were to import via DMF.

Current practice

1. Import "Item batches" data entity via DMF

2. Manually Reset shelf-life dates (for particular items)

*Understand Mfg. date is a required field in Item batches and Expiration date auto-calculated in the back end by adding "Shelf life period in days" from Released product.

Case 1) Manufacturing date not needed: remove Manufacturing date

Case 2) Expiration date not needed: Removed Best before date and Expiration date

Case 3) Both Manufacturing date and Expiration date not needed: Remove all