I have a SQL server which is connected through Gateway to Azure. I am trying to insert the data using PowerAutomate to the dynamics finance and operation. I am trying to use the Customer data entity to perform this. However, there are certain fields such as Customer Account number which need to be generated automatically by the system as I don’t know what would be the next sequence of customer account number that needs to be generated. Is there Anyway that I can assign a customer account number to the flow when inserting data? Can anyone Please help with this?
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.