Help! Power Apps Patch function giving error on first two lines — need advice

(0) Share

Report

Posted on by CU08081305-6

Hey folks,

I’m trying to use this Patch function in Power Apps to create new time entry records in a TimeEntries data source, but I keep getting errors on the first two lines (Patch(TimeEntries, Defaults(TimeEntries), {...})).

Patch( TimeEntries, Defaults(TimeEntries), { 'Project Selected': ProjectDropdown.Selected.Value, MonInput: Value(Coalesce(MonInput.Text, "0")), TueInput: Value(Coalesce(TueInput.Text, "0")), WedInput: Value(Coalesce(WedInput.Text, "0")), ThurInput: Value(Coalesce(ThurInput.Text, "0")), FriInput: Value(Coalesce(FriInput.Text, "0")), SatInput: Value(Coalesce(SatInput.Text, "0")), SunInput: Value(Coalesce(SunInput.Text, "0")), 'Total Hours': Sum( [ Value(Coalesce(MonInput.Text, "0")), Value(Coalesce(TueInput.Text, "0")), Value(Coalesce(WedInput.Text, "0")), Value(Coalesce(ThurInput.Text, "0")), Value(Coalesce(FriInput.Text, "0")), Value(Coalesce(SatInput.Text, "0")), Value(Coalesce(SunInput.Text, "0")) ] ), Stage: StageDropdown.Selected.Value, Comments: CommentsInput.Text } )

The error specifically points at these two line.

I’m pretty sure my data source is correctly connected, and I’ve checked the control names (ProjectDropdown, MonInput, etc.) multiple times.

Has anyone seen this kind of error before? What could be causing it?

Any help or pointers would be super appreciated! Thanks!

Categories:

Using Apps Using Formulas

I have the same question (1)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @CU08081305-6

Are you trying to Sum multiple values for just that Week itself (based on individual columns) Sum all Mondays and All Tuesuday etc?

Either way remove the [ ] brackets please.

ClearCollect(TimeEntries, { MonInput: 1, TueInput: 2, WedInput: 3, ThurInput: 4, FriInput: 5, SatInput: 1, SunInput: 1, 'Total Hours': 7 } ); Patch( TimeEntries, Defaults(TimeEntries), { MonInput: 1, TueInput: 2, WedInput: 3, ThurInput: 4, FriInput: 5, SatInput: 6, SunInput: 7, 'Total Hours': Sum( First(TimeEntries).MonInput, First(TimeEntries).TueInput, First(TimeEntries).WedInput, First(TimeEntries).ThurInput, First(TimeEntries).FriInput, First(TimeEntries).SatInput, First(TimeEntries).SunInput ) } )

however, if you are trying to ADD together the current Rows items thats an Add thing not necessarily a Sum thing. It can depend.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
#Jahanvi Arora on at

Like (0)

Report
Copy link

Link copied!

hi @Jahanvi @Jahanvi

Was this reply helpful? Yes No