Power Platform Community Forum Thread Details

Hi All

Context

I appreciate this is kind of cross forum as it relates to Power Automate aswell as Power Apps

I have a model driven app and i have two tables, one for enquiries and one for projects.
a new entry is created in the enquiry table
goes through an approval flow (when a new record is created)
marks the record as approved (or rejected!)
creates a new record in the project table (if approved of course)

Simple stuff!

What i want to do

When the record is created in the enquiry table it marks the owner as the person creating the record (as expected)
During the approval flow i would like to select the owner of the record to be created in the project table
how can i achieve this?

Cheers all

Dan

Categories:

Building flows

Hi @danny90.

Here is the Step-by-Step Flow Design at the first place:

Trigger: When a new record is created in the Enquiry table: Use the Dataverse trigger: When a row is added, modified or deleted (select "Added" for creation). Scope it to the Enquiry table.
Start an Approval Action: Use the Start and wait for an approval action. Configure approval type (e.g., Approve/Reject – First to respond). Include relevant details from the enquiry record in the approval request.
Condition: Check Approval Outcome: After the approval action, add a Condition to check if the response is "Approve". If Rejected, update the enquiry record status to "Rejected" (optional).
If Approved: Update Enquiry Record: Use the Update a row action to mark the enquiry as "Approved" or set an approval status field.
Create a New Project Record: Use the Add a new row action to create a record in the Project table. Map fields from the approved enquiry to the new project record as needed.
Optional: Notifications or Logging: Send an email or Teams notification about the approval and project creation.

What i want to do

When the record is created in the enquiry table it marks the owner as the person creating the record (as expected)
During the approval flow i would like to select the owner of the record to be created in the project table

To achieve your goal:

Add a step in your approval process or form to select the Project owner: For example, include a field in the approval request or a separate input where the approver can specify the owner (e.g., a person picker or email address).
Capture the selected owner value in the flow: Store the selected owner’s identifier (usually their User Principal Name/email or system user GUID) in a variable or directly from the approval response.
When creating the Project record, set the Owner field explicitly: In the Create a new row (Dataverse) action for the Project table, set the Owner (usually the ownerid field) to the selected user. The owner field expects a reference to a system user entity, so you typically provide it as an object with @odata.type and the user’s GUID, for example: "ownerid@odata.bind": "/systemusers(<UserGUID>)" , Or if using email or UPN, you may need to resolve the user GUID first (e.g., via a List rows action filtering system users).
If you want to default to the Enquiry owner when no selection is made: Retrieve the Enquiry owner from the trigger data (usually ownerid or ownerid@odata.bind) and use it as fallback.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!