Greetings, fellow canvas app enthusiasts! Today, we embark on a quest to unravel the enigmatic world of delegation workaround. Picture yourself deep in the realm of app creation, when suddenly, a familiar challenge arises – delegation limitations. But fret not, for we have a nifty solution up our sleeves!

The task: we need to visualize tasks created only by us with the option to filter by month (in this case - the due date column) and we also need to add new tasks.

The solution is as simple as a couple of functions and a bit of magic. :)

Data source

Prepare your SharePoint list and add another text column, where we will be storing our month name.

Visualize the column in your Form control

Set the default value of the month name datacard to the following code, where the DataCardValue2.SelectedDate is the date card. Then we only hide the month name data card.

Text(DataCardValue2.SelectedDate,"mmmm")

Create a global variable to store your current user on App Start, so that we can use the already existing Created by column in Sharepoint and have no delegation issues when filtering only the items created by the current user.

Set(userName,User().FullName);

Now unleash free-from-delegation filtering with the function below:

Filter(
Delegation_part2,
StartsWith('Created By'.DisplayName,userName)
&& 
StartsWith(MonthName,TabList1.Selected.Value)
)

I hope this quick trick will help you!

The world of app development is ever-evolving, and our journey doesn't end here - exploring, experimenting, and sharing newfound knowledge with fellow enthusiasts. Together, we can push the boundaries of what's possible and create extraordinary experiences.