Update dates of all rows in PowerApp

(1) Share

Report

Posted on by muzzamal

102

Hi,

my sharepoint data is:

TaskPhaseID	TaskNameID	StartDate	Duration	EndDate
1	1001	10/1/2023	2	10/3/2023
1	1002	10/3/2023	3	10/6/2023
1	1003	10/6/2023	1	10/7/2023
2	2004	10/7/2023	1	10/8/2023
2	2005	10/8/2023	2	10/10/2023
2	2006	10/10/2023	1	10/11/2023
2	2007	10/11/2023	3	10/14/2023
2	2008	10/14/2023	4	10/18/2023
2	2009	10/18/2023	1	10/19/2023
3	3010	10/19/2023	1	10/20/2023
3	3011	10/20/2023	2	10/22/2023
3	3012	10/22/2023	1	10/23/2023
3	3013	10/23/2023	3	10/26/2023

In powerapp, I have the following fields.
PowerApp Field Sharepoint column name
popupStartDate_1 StartDate
popupDuration_1 Duration
popupEndDate_1 EndDate

in the power app, if i set the start date of the first row or any row and click the update button (btnsubmit), the code should update all the following rows of Gallery.Selected as the table above.

EndDate is = StartDate + Duration

EndDate of a row is the StartDate of the next row.

Similarly changing the duration of any row should also update the dates of the following rows.

How can I acheive this? I tried using forAll and patch but it is not working.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @muzzamal ,
Try Like This ,
ForAll( Filter(YourSPList, TaskPhaseID >= Gallery.Selected.TaskPhaseID), Patch( YourSPList, ThisRecord, { StartDate: /* logic to calculate new start date based on previous row's EndDate */, EndDate: DateAdd(StartDate, Duration, Days) } ) );
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No
muzzamal 102 on at

Like
a
(1)

Report
Copy link

Link copied!

Patch(
ProgressTracker,
tasksGallery.Selected,
{
Duration: Value(popupDuration_1.Text),
StartDate: popupStartDate_1.SelectedDate,
EndDate: popupEndDate_1.SelectedDate
}
);
// Create a collection of subsequent rows to update
ClearCollect(
RowsToUpdate,
Filter(
ProgressTracker,
TaskPhaseID = tasksGallery.Selected.TaskPhaseID &&
Created > tasksGallery.Selected.Created
)
);
// Update subsequent rows based on Created date and store in a collection
ClearCollect(
UpdatedRows,
ForAll(
RowsToUpdate,
{
ID: ThisRecord.ID,
StartDate: DateAdd(tasksGallery.Selected.EndDate, 1, TimeUnit.Days),
EndDate: DateAdd(
DateAdd(tasksGallery.Selected.EndDate, 1, TimeUnit.Days),
ThisRecord.Duration,
TimeUnit.Days
)
}
)
);
// Patch the updated collection back to the data source
ForAll(
UpdatedRows,
Patch(
ProgressTracker,
LookUp(ProgressTracker, ID = ThisRecord.ID),
{
StartDate: ThisRecord.StartDate,
EndDate: ThisRecord.EndDate
}
)
);

This is updating the first row only. code keeps running but no date is changed after the first one

Was this reply helpful? Yes No
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
@muzzamal ,
Try This code let me
// Assume StartDate has been set for a row and we need to update subsequent rows // Create a variable to hold the initial start date Set(varStartDate, Gallery.Selected.StartDate); // Update subsequent rows ForAll( Filter(YourSPList, TaskPhaseID = Gallery.Selected.TaskPhaseID && ID > Gallery.Selected.ID), Patch( YourSPList, LookUp(YourSPList, ID = ThisRecord.ID), { StartDate: varStartDate, EndDate: DateAdd(varStartDate, ThisRecord.Duration, Days) } ); // Update varStartDate for the next iteration Set(varStartDate, DateAdd(varStartDate, ThisRecord.Duration, Days)) );
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No