Patching as Default into a OptionSetValue Dataverse Field

(1) Share

Report

Posted on by PowerApp_Chaos

Hello,

I am having trouble trying to patch new (default) values into a timetracking table called 'Timesheet'. One of the fields in the table is a Choices type (or OptionSetValue) for Resource_Type with the options included of Contractor or Employee.

In the form I have a patch statement that creates the timesheet, before rows of activities are added. Below you can find the details. I have tried different methods to get the value to patch, but it continues to throw an error that the type doesn't match the dropdown it is pulling from.

//Add Data from above collection into the Dataverse Timesheet Table
Patch(
            Timesheet,
            Defaults(Timesheet),
            {
                //included fields from the form
                Timesheet_WeekStartDate_ID: ddTSStartDate.Selected.crb01_dateid,
                Timesheet_StartDate: DateValue(ddTSStartDate.Selected.WeekStartDate),
                Resource_Name: ddEmployeeSelection.Selected.'Last Name, First Name',
                Resource_ID: ddEmployeeSelection.Selected.'Network ID',
                Resource_Email: ddEmployeeSelection.Selected.Email,
                Resource_ManagerName: ddEmployeeSelection.Selected.Manager,
                Timesheet_Approval_ApproverName: ddEmployeeSelection.Selected.Manager,
                Resource_CostCenter: ddEmployeeSelection.Selected.'Home Cost Center',
                Resource_Vendor: ddEmployeeSelection.Selected.Vendor,
                Resource_Role: ddEmployeeSelection.Selected.Role.Value,
                //custom fields with static values relating to timesheet processing
                Resource_Rate: 50.00,
                Resource_Type: ddEmployeeSelection.Selected.'Resource Type'
            }
        );
 
I have attempted the line using:
 
Resource_Type: ddEmployeeSelection.Selected.'Resource Type'
Resource_Type: {Value: ddEmployeeSelection.Selected.'Resource Type'}
The first one indicates that OptionSetValue is expected and type is text.  The second indicates OptionSetValue is expected and type is record.
 
 
Here is the field, from the Timesheet table, it needs to patch to, for reference.  I have external values for the options also set to Contractor and Employee respectively.
 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

scalca 243 Moderator on at

Like (1)

Report

can you pls share the items property of ddEmployeeSelection dropdown ?

Was this reply helpful? Yes No
Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (1)

Report

your ddEmployeeSelection is not a list of choice of the type 'Resource Type'. it is looking that are you set a custom collection of another type of record and after set the property resource type.

Try the following

Resource_type: Lookup(Choices('Name of optionset'), Value = ddEmployeeSelection.Selected.'Resource Type')

or

Resource_type: Lookup(Choices('Name of optionset'), Value = Value(ddEmployeeSelection.Selected.'Resource Type'))

Was this reply helpful? Yes No
PowerApp_Chaos 42 on at

Like (0)

Report

@Scalca

The employee dropdown pulls from one of two collections which are established when the user enters the timesheet page.

One of the collections (colAllEmployeesFormData) is an extraction of a timetracking employees table (which includes the field 'Resource Type'), this one would be used when the user is a manager or app admin, and needs access to create a timesheet for various employees.

The other option (colUserFormData) is a collection extracted from the same dataset, but limited to only the current users info, enabling the timetracking employee to only see their name in the list.

The patch statement OnSelect of a button labeled [Start Timesheet] gets the associated 'Resource_type' value from the name selected in these collections.

If(varUserAdministrator=true||varUserManager=true,colAllEmployeesFormData,colUserFormData)

Was this reply helpful? Yes No
PowerApp_Chaos 42 on at

Like (0)

Report

@MichaelFP, your solution (with a slight tweak in the exact scripting) worked!

I keep trying to mark your solution as the answer but it starts loading in the browser and never stops. I have tried like 5 times now.

I essentially pulled the choices for the lookup from the database field, and then found the value within using the dropdown, as suggested. Thank you so so so so much! I cannot explain how long I spent researching this issue without results!!!

Here is the final update to that part of the script which enabled it to recognize the loaded dropdown value as a choice.

Patch(

Timesheet,

Defaults(Timesheet),

{

//included fields from the form

Timesheet_WeekStartDate_ID: ddTSStartDate.Selected.crb01_dateid,

Timesheet_StartDate: DateValue(ddTSStartDate.Selected.WeekStartDate),

Resource_Name: ddEmployeeSelection.Selected.'Last Name, First Name',

Resource_ID: ddEmployeeSelection.Selected.'Network ID',

Resource_Email: ddEmployeeSelection.Selected.Email,

Resource_ManagerName: ddEmployeeSelection.Selected.Manager,

Timesheet_Approval_ApproverName: ddEmployeeSelection.Selected.Manager,

Resource_CostCenter: ddEmployeeSelection.Selected.'Home Cost Center',

Resource_Vendor: ddEmployeeSelection.Selected.Vendor,

Resource_Role: ddEmployeeSelection.Selected.Role.Value,

//custom fields with static values relating to timesheet processing

Resource_Rate: 50.00,

Resource_Type: LookUp(

Choices(Timesheet.Resource_Type),

Value in ddEmployeeSelection.Selected.'Resource Type',

Value

)

}

);

Was this reply helpful? Yes No
scalca 243 Moderator on at

Like (0)

Report

you could pull the data directly into the dropdown with required record type

Choices(TimeSheet.ResourceType)

meaning that the patch function would work without to lookup

in case the dropdown needs to be adjusted based on the user you can add an appropriate filter to the dropdown formula.

that's just one more option

Was this reply helpful? Yes No