Dynamics Community Forum Thread Details

Vendor creation flow in FO from Power automate

Hi Folks,

I need to create a flow for a Vendor creation through Power Automate in D365 FO, using a SharePoint list.

Could you please help me to understand I need to add the PAN account number during vendor creation. However, I am unable to find this field in the VendorsV3 entity, which I am using for creating vendor records in the "All Vendors" form. I have checked the VendorsV3 entity in Data Management, and it contains this field, but it is not visible in Power Automate.

Additionally, how to create a GST number for the vendor, as it exists in a different entity and not able to get updated for same vendor which I am creating In below image

Power automate flow :
Creation of item using share point

Then getting approval

After approval

It is creating record in all vendor for (create record)

And after that I have used create record one for creating GST

so it is creating a new GST but its not updated in the newly created vendor automatically

Thanks in advance!!

Categories:

Dynamics 365 Finance

Hey,

I used the same entity.

Can you check if this is your field you are looking for?

Regarding GST, my idea would be the following in Power Automate:

1. Create a GST number with Create Record step with according entity
2. Use "List items present in table" step and filter by the latest vendor record created or by any id from your sharepoint list.
3. Use step "Update record" in order to update the newly created vendor account. In this step you need to reference to a vendor record. The reference to this object is to be pulled from step 2 "List items present in table".

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Quick Links