Vendor creation flow in FO from Power automate

(4) Share

Report

Posted on by D365FO Avatar

502

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

All responses (5)

Answers (1)

Adis 2,941 Super User 2025 Season 1 on at

Like (0)

Report

Vendor creation flow in FO from Power automate

Hi,

I did understand that you need another entity to create the GST number thats fine, when you select the step Create a record, in order to create the GST, number you can select the entity you need.

In order to update the vendor record, you need to select "Update a record", use entity VendorsV3 and you can reference for the GST number to the number you created in step "Create a record" (GST).

However, before we dig into it how to execute the above steps, is there a field in VendorsV3 that you can use to update the record with the GST number?

In order to test this, I would select Update a record and put it any GST number, just to figure out if the vendor is being updated with the correct field, because if that doesnt work, then you need to customize the entity or create a new one.

Regarding Action 'Update_a_record' failed: An error has occurred. No resources were found when selecting for update.

It may be an issue to the parameter "Cross company" - there is a blog to this issue

Multiple legal entities issue with the Fin & Ops Apps connector in Power Automate

Kind regards, Adis
Verified answer

D365FO Avatar 502 on at

Like (0)

Report

Vendor creation flow in FO from Power automate

Hi, thanks for your reply,

But I need to transfer the GST number that I created for a vendor different entity not in VendorV3, and the field name is also different. Essentially, I need to link the created GST number of that vendor to a different entity. Could you please let me know what steps I need to follow for this?

Also, when I use the "Update a record" step for that entity, I receive the following error:

Action 'Update_a_record' failed: An error has occurred. No resources were found when selecting for update.
Adis 2,941 Super User 2025 Season 1 on at

Like (1)

Report

Vendor creation flow in FO from Power automate

Hi,

I would try "Update a record".

ad 1:

The fields here come from the step that you used to create the vendor

ad 2:

The field for the GST number you need to reference from the step that you used to create the GST number

Please try and give feedback, 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
D365FO Avatar 502 on at

Like (0)

Report

Vendor creation flow in FO from Power automate

Thanks if I have use created a record step for creating GST no in d365 f&o using power automate it is working fine and creating a record in enitity, now I have to flow tha GST No to different entity field with different name which step should I use in power automate
Adis 2,941 Super User 2025 Season 1 on at

Like (1)

Report

Vendor creation flow in FO from Power automate

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