Patching collection to Sharepoint list. Last entry overwrites the others

(0) Share

Report

Posted on by ConnM

260

Hello

I'd like it if someone would look at my code.

I have a gallery showing colTimesheetLines. It is a dropdown and some text boxes for time entry.

I have a save icon with this in the onSelect

ForAll(
 colTimesheetLines,
 Patch(
 EstimatingTime,
 Defaults(EstimatingTime),
 {
 Week: Text(DateLabel),
 Project: ProjectDropdown.Selected.Title,
 MonHour: Value(inputMon.Text),
 TueHour: Value(inputTue.Text),
 WedHour: Value(inputWed.Text),
 ThurHour: Value(inputThur.Text),
 FriHour: Value(inputFri.Text),
 SatHour: Value(inputSat.Text),
 SunHour: Value(inputSun.Text),
 TotalHours: Value(inputTotal.Text),
 Percent: Value(inputTotalPercentage.Text),
 WeekStart: varDate,
 Collated: 0
 }
 )
);
Clear(colTimesheetLines);

If I run it with just one entry it is perfect. If I have more than one, three for example, the last record is saved three times, overwriting the earlier ones

Thank you for your time

Conn

Additionally I would like the ability to edit these, which causes odd problems, but that is totally an extra problem

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ConnM 260 on at

Like (0)

Report
Copy link

Link copied!
Patching in the gallery Items instead of the collection sorted it out
ForAll( GalleryMain.AllItems, Patch( EstimatingTime, Defaults(EstimatingTime), { Week: Text(DateLabel), Project: ProjectDropdown.Selected.Title, MonHour: Value(inputMon.Text), TueHour: Value(inputTue.Text), WedHour: Value(inputWed.Text), ThurHour: Value(inputThur.Text), FriHour: Value(inputFri.Text), SatHour: Value(inputSat.Text), SunHour: Value(inputSun.Text), TotalHours: Value(inputTotal.Text), Percent: Value(inputTotalPercentage.Text), WeekStart: varDate, Collated: 0 } ) ); Clear(colTimesheetLines);

Was this reply helpful? Yes No
ConnM 260 on at

Like (0)

Report
Copy link

Link copied!
This project took inspiration from Matthew's guide, which was a bit beyond my skill level.
Make A Power Apps Timesheet App - Part 2 (matthewdevaney.com)

After gaining a bit of knowledge, and adaption to my needs, this is working to allow updating
ClearCollect( colUpdateLines, ForAll( GalleryMain.AllItems, { Week: Text(DateLabel), Project: ProjectDropdown.Selected.Title, MonHour: Value(inputMon.Text), TueHour: Value(inputTue.Text), WedHour: Value(inputWed.Text), ThurHour: Value(inputThur.Text), FriHour: Value(inputFri.Text), SatHour: Value(inputSat.Text), SunHour: Value(inputSun.Text), TotalHours: Value(inputTotal.Text), Percent: Value(inputTotalPercentage.Text), WeekStart: varDate, Collated: 0 } ) ); ClearCollect( colTimesheetLines, Patch( EstimatingTime, GalleryMain.AllItems, colUpdateLines ) );

Was this reply helpful? Yes No