Code Snippets: // With( { varStartDate: dpStartDate.SelectedDate, varDuration: Value(txtinpDuration.Text) }, DateAdd( varStartDate, Value(varDuration) + RoundDown( (Weekday( varStartDate, StartOfWeek.Monday ) + Value(varDuration) - 1) / 5, 0 ) * 2, TimeUnit.Days ) ) Change the following parts: 1. dpStartDate - replace this with your date picker name 2. txtinpDuration - replace this with your text input control name.
@RafsanHuseynov Thank you for your feedback regarding my error. I have six task lists in a SharePoint list to create in Apps, and I need to duplicate one home task screen and task detail form to another task list. When I changed the data source from the SP list, the VarRecord showed an error. I will send you a preview of the error. I love this video; it's easy to learn and understand.
It’s not finished yet. We have a few more sessions remaining. Once they are all completed, I will compile them into a solution and explore methods to share it with the community. Thanks for your patience!
Code Snippets:
//
With(
{
varStartDate: dpStartDate.SelectedDate,
varDuration: Value(txtinpDuration.Text)
},
DateAdd(
varStartDate,
Value(varDuration) + RoundDown(
(Weekday(
varStartDate,
StartOfWeek.Monday
) + Value(varDuration) - 1) / 5,
0
) * 2,
TimeUnit.Days
) )
Change the following parts:
1. dpStartDate - replace this with your date picker name
2. txtinpDuration - replace this with your text input control name.
Thank you again, I can't wait for next step
Thanks for your feedback. Next is going to be about search and filter in power apps.
Love the content. Thanks for sharing.
Thank you Roma.
When I duplicate the screen for use in creating another task from "varRecord" in the form screen, there was an error, and I can't view it.😢
Hi @BoyZaap. Could you please elongate on that? Can you check App Checker in Power Apps Studio and share the error message with me please?
@RafsanHuseynov Thank you for your feedback regarding my error. I have six task lists in a SharePoint list to create in Apps, and I need to duplicate one home task screen and task detail form to another task list. When I changed the data source from the SP list, the VarRecord showed an error. I will send you a preview of the error. I love this video; it's easy to learn and understand.
@@BoyZaap do your field names in the form control match with the new SP list?
Possible to share your application
It’s not finished yet. We have a few more sessions remaining. Once they are all completed, I will compile them into a solution and explore methods to share it with the community. Thanks for your patience!