We have a number sequence set up for new Vendor accounts which works fine when used within the application.
Currently, we are creating new Vendor accounts manually for new employees who require expenses. This is then linked to their employee record.
I am looking into automating this process using the Business Events trigger in Power Automate to trigger when a new record is created in the Workers table - use that information to create a Vendor record.
The problem I am having is that I cannot find a way to use the number sequence already set up in the application with Power Automate and not sure if this is possible currently.
Everything is working so far and I have been able to create the Vendor record using free text in the Vendor account field but I need this to use the number sequence in the application if this is going to work.
I also cannot query the Vendor table, find the newest number and just add 1 to it then use this because it will not increment the value stored against the number sequence in the application and would break things if someone was to create an account manually (as the number would get reused).
Anybody tried this previously and had any luck?
