Grant-Archibald-MS
commented
11 months ago Consider the following approach for copying data from one Business Approval workflow to another using Power Automate and assuming the given assumptions:
- Create a Power Automate Cloud flow that is triggered from a Power App.
- Add an input parameter for the ID of the workflow to copy, which can be either a published or draft version.
- Use the Dataverse connector to retrieve the data from the tables you mentioned: Business Approval process, Business Approval Data, Business Approval Stage, Business Approval Node, and Business Approval Condition.
- Use a loop in Power Automate to copy the data for each table.
- For the Business Approval process table, use a conditional statement to check whether the workflow is a draft or published version. If it's a draft version, copy the data to the draft version of the new workflow. If it's a published version, copy the data to the published version of the new workflow.
- For the other tables, copy the data to the new workflow regardless of whether it's a draft or published version.
- Provide a user experience to select whether to copy the draft or published version of the workflow.
Is your feature request related to a problem? Please describe.
Currently, there is no function to copy and save an existing workflow as a new workflow in the Business Approvals Kit. This can be frustrating and time-consuming for users who want to create a new workflow based on an existing one.
Describe the solution you'd like
Would like to have a function to copy and save an existing workflow as a new workflow in the Business Approvals Kit.
This function should add an item to the ribbon to allow the workflow to be copied. When the workflow is copied, all the child steps, notifications, and other relevant data should be copied to new Dataverse rows. This would save time and improve efficiency for users who want to create new workflows based on existing ones.
Describe alternatives you've considered
No response
Additional context?
No response
AB#693