Unanswered

Model driven app onload event to create ID directly through the New button

(0) Share

Report

Posted on by Community Power Pla...

Hi guys, I'm currently on Dataverse and building a Model Driven App (MDA). Let's say I have a table named Customer Feedback and the primary column is Feedback ID with Autonumber data type, and already properly configured into a MDA.

By default, the homepage will be the View page. Whenever the user wants to create a new record, the user will have to click on New button on the View page which leads to the main form. The user will then fill up the form and click on Save. A new record is then created and a new Feedback ID being generated after clicking on the Save button.

The question is: Can I create a new record and generate a new Feedback ID right after I click on the New button? Without having to click on the Save button.

I'm thinking of using the Onload Event Handler in form configuration by bringing in javascript. If this is a feasible way can any one of you help to provide the javascript code to perform this action? Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous,

The AutoNumber column won't show its generated value until the record is saved. You can use JavaScript to save OnLoad using formContext.data.entity.save() ., or you could create a custom Command Button and use a PowerFX formula to create the new record then Navigate to the form.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi,

Auto number column value generated on Save because it runs server side.

I don't think using javascript you will be able to generate this field value unless you write your own code to generate the Sequence using Cutom action c# code and call Custom action from Javascript onload. However OOB Auto number column value it will be difficult to retrieve/generate using javascript.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @ChrisPiasecki,

Thanks for the solution. I have tested the Javascript method and it works. However, it has some interference with another OnSave function that I have.
Can you show me the PowerFX formula to achieve the said objective?

Was this reply helpful? Yes No