Fetch Auto Number Sequence From D365 F&O to PowerApps

[Manikanta1231]

Hi Everyone,

I have created a Purchase order Application that is connected to my D365 Finance and Operations instance. 

I want to fetch my automatic number sequence from D365 onto my powerapp while creating Purchase Order Header however, i have no idea how to do it.

Thanks in Advance.

[v-siky-msft]

Hi @Manikanta1231 ,

Could you please share more detail about your need? Do you mean want show the Autonumber in the form when creating a new record?

The Autonumber field is generated when the record has been created, so when form turns to be in New mode, the Autonumber won't show.

The workaround is to create a blank record by patch function, and then use Form to edit that record you just created, then the Autonumber will show.

Set the OnSelect of button: 

Set(VarA,Patch('Entity Name',Defaults('Entity Name'),{'The Required Fields':""}).'Unique Identifier field');EditForm(FormName) // create a new record with the required fields and save the GUID to VarA

Set the Items property of Form:

LookUp('Entity Name','Unique Identifier Field'=VarA)

 Sample:

Hope this helps.

Sik

[Manikanta1231]

Thank you for respond. My requirement is like in D365FO whenever we create purchase order it follows number sequence same as it I need to implement in PowerApps.

[v-siky-msft]

Hi @Manikanta1231 ,

Are there any examples?

Sik

[Manikanta1231]

Hi @v-siky-msft ,

For example, In D365FO if new create new purchase order it generates new purchase order number like "PO-000001",  for next purchase order it generates "PO-000002". Same as we need to fetch from D365FO in powerApps 

[v-siky-msft]

Hi @Manikanta1231 ,

If you configure the order number field to Autonumber type, it will be auto-generated with the Prefix when the record is created.

I think this can achieved your need. Does it make sense for your case?

Sik

[AMoon]

Hi @Manikanta1231, I'm not sure about exactly how your process needs to occur, but could you create the purchase order in F&O as a first step in order to have F&O generate the number and any other defaults? Then you could refresh and pull that new Purchase Order back into your Power App with the PO # from F&O. 

[Manikanta1231]

Hi @AMoon ,

 Thank you for respond ,as you said we can do first step in F & O but our intention is to create Purchase order in PowerApps with number sequence. Is there any possibility that we can achieve. ?

[AMoon]

Sorry if wasn't clear, below are the steps I was envisioning

1. Use Power App to create Purchase Order Header in F&O (When the PO is created F&O will generate the PO #)

2. Use Power App to refresh and retrieve the new Purchase Order Header including the generated PO #

3. Use Power App to edit the Purchase Order Lines, etc.

Is there something preventing you from following the above process? 

[leonevesm]

Hi all, I was facing the same issue.

Unfortunately @AMoon  for F&O the Patch approach won't solve in this situation, it works only for Dataverse/CRM side.

Instead, for F&O use Power Automate flows to create/update/delete the F&O records passing the needed parameters. Also is possible to receive the return data from the flow, it's very important to enable the creation of child transactions based on the header ids.

More details: https://docs.microsoft.com/pt-br/powerapps/maker/canvas-apps/using-logic-flows

My Power Automate flow:

Calling the flow in my app passing some parameters:

Hope it could helps.