Answered

OnSelect Patch Issue

(0) Share

Report

Posted on by jasperxx

Need help.

Below is my patch code. Seems has no issue but it shows error. The sharepoint list is a choice type. Not sure which part went wrong.

OnSelect =
Patch(
'Planned Leave Submission',
Defaults('Planned Leave Submission'),
{
LeaveStartDate: StartDateInput.SelectedDate,
LeaveEndDate: EndDateInput.SelectedDate,
LeaveType: LeaveDropDown.Selected.Value,
DayType: DayDropDown.Selected.Value
}
);
Navigate(SuccessfulPage, ScreenTransition.Fade)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jasperxx , Try this:

DayType: {Value:DayDropDown.Selected.Value }

Check this: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-choices-column/

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

It is choice column. Both "LeaveType" and "DayType " are choice type but when I used your code:

OnSelect =
Patch(
'Planned Leave Submission',
Defaults('Planned Leave Submission'),
{
LeaveStartDate: StartDateInput.SelectedDate,
LeaveEndDate: EndDateInput.SelectedDate,
LeaveType: {Value:LeaveDropDown.Selected.Value},
DayType: {Value:DayDropDown.Selected.Value}
}
);
Navigate(SuccessfulPage, ScreenTransition.Fade)

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jasperxx ,
SharePoint choice fields need to be handled differently in Power Apps. When you're patching a choice field, you need to provide a record, not just a value. For a choice field like LeaveType, the syntax should be:

LeaveType: {Value: LeaveDropDown.Selected.Value}

Patch Code:

Patch( 'Planned Leave Submission', Defaults('Planned Leave Submission'), { LeaveStartDate: StartDateInput.SelectedDate, LeaveEndDate: EndDateInput.SelectedDate, LeaveType: {Value: LeaveDropDown.Selected.Value}, DayType: {Value: DayDropDown.Selected.Value} } ); Navigate(SuccessfulPage, ScreenTransition.Fade)

If you think my solution is helpful for you, then please accept it. 😊

Was this reply helpful? Yes No
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

Tried the same but showed a different error.

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx, Are both column are multi select? The code is pretty straight forward. Please check another blog from Matthew Devaney. He has covered all type of column for Patch. https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

Everything followed but still showed

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx , Can you share the screenshot of code with error message? This could be for some other column then.

Thanks,
ANB

Was this reply helpful? Yes No
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

OnSelect =
Patch(
'Planned Leave Submission',
Defaults('Planned Leave Submission'),
{
LeaveStartDate: StartDateInput.SelectedDate,
LeaveEndDate: EndDateInput.SelectedDate,
LeaveType: {Value:LeaveDropDown.Selected.Value},
DayType: {Value:DayDropDown.Selected.Value}
}
);
Navigate(SuccessfulPage, ScreenTransition.Fade)

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx , Apologies but I dont see any red cross on Submit button. Can you confirm that this error is coming from the same submit button? For example, if there is any error on code, then this is how it will look:

Expand the formula bar where you have written the code and try to get this screenshot that I gave in above example.

Thanks,
ANB

Was this reply helpful? Yes No
Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx , One more thing I noticed with whatever screenshot you gave, in the formula bar you have add "OnSelect="

You do not have to add that, simply the Patch code will work for you.

Thanks,
ANB

Was this reply helpful? Yes No