I have an excel online file with the following columns. There are 10 clients and 7 tasks for each client.
ClientName
ProjectStartDate
In PowerApp, create a table with the following columns.
TaskName
Duration (in days)
Start Date (ProjectStartDate)
End Date (ProjectStartDate + Duration)
Status (completed, in progress, pending)
I want to generate a table in the app where I can store separate tasks for each client. When the task is complete, I can select "completed" from the drop-down and the next task is auto-selected to "In progress" and can send this table in the email using outlook connector? The table to be sent in the email contains (the previous status with duration and date) and the upcoming tasks.
Something like in the image. This table should store data for all clients and send in an email when required.

Report
All responses (
Answers (