Power Platform Community Forum Thread Details

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

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

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Telen Wang – Community Spotlight

Announcing our 2025 Season 2 Super Users!

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates