Wednesday, June 30, 2021

PowerApps: Sequence Function

 Hello Friends,

Welcome back with another post of PowerApps. today, we will learn something new. Guess What? Have you ever faced any situation, where you have to create a collection of some sequential numbers - let's say from 1 to 10 or 24 to 35 or a date range? Do you know that we can achieve this in PowerApps. For this, PowerApps has provided a very powerful function named "Sequence". Let's see, how we can use this function-

  1. Getting Collection for 01-10 numeric values.
  2. The code is-
  3. ClearCollect(
    SequenceCollection,
    Sequence(10)
)
  4. The output is-


  6. Getting Collection for 24-33 numeric values-
  7. The code is-
  8. ClearCollect(
    SequenceCollection,
    Sequence(10,24)
)
  9. The output is-


  11. Getting Collection starting from 11 with an interval of 2-
  12. The code is-
  13. ClearCollect(
    SequenceCollection,
    Sequence(10,1,2)
)
  14. The output is-


  16. Getting Collection for next 10 days-
  17. The code is-
  18. ClearCollect(
    SequenceCollection,
    ForAll(
        Sequence(10),
        DateAdd(
            Today(),
            Value,
            Days
        )
    )
);
  19. The output is-


  21. The objective of this post is that most of the times, we need to apply loop in PowerApps for some N times. But as there is no loop function in PowerApps, we have to do some manipulation. We have ForAll function to achieve the loop functionality but it takes a collection as first parameter upon which it works. So, we have to create a collection on runtime using that we can achieve loop functionality.
  22. The use of Sequence with ForAll is explained in my below post-
  23. PowerApps: Getting More Than 2000 Items (Using Sequence)
  24. Visit the post and on point 10 & 11, I had used Sequence and ForAll respectively to fetch all items from data source.
  25. Visit below article by Microsoft on Sequence for further reading-
  26. Sequence function in Power Apps

With this, I am concluding this post.
Happy Coding !!!
Will see you again with some new topics.

Stay Safe !
Stay Healthy !

at No comments:
Labels: ,

PowerApps: Getting More Than 2000 Items (Using Sequence)

Hello Friends,

Welcome back with another post on PowerApps. As all we know that PowerApps fetches only 500 items from data source at a time. This limit can be enhanced up to 2000 through File >> Settings >> General >> Data row limit. In real scenario, the total number of items in any data source can be more than 2000 usually. Then how can we get all items in PowerApps?

To resolve the above issue, we can do some manipulation to get all the data from data source as we have discussed in our previous article.

PowerApps: Getting More Than 2000 Items From SharePoint List


Above code logic works on static mode where we implement logic on a pre assumption of number of items. But the logic will get fail once the number of items increases beyond that limit. We have to change the logic again and again and republish the app in above logic model to overcome this situation. So, in order to overcome this situation, we have derived a dynamic model to get all items from data source. Let's see, how-


  1. Create a blank canvas app.
  2. Add 2 Gallery controls and name them-
    1. GalleryDailyTasks_1 - It will be used to display all items from data source. Bind "AllTasksCollection" collection to the items property.
    2. GalleryTotalIterations_1 - It will be used to display the Iterations of min-max created dynamically. Bind "TotalIterations" collection to the items property.


  4. Now, we will add code on "OnVisible" action of Screen "ScreenAllRecWithSequence_1"
  5. First of all, we will create a blank collection which will be used to store all items from data source-
    1. ClearCollect(
    AllTasksCollection,
    []
);
  6. Then we will add code to get the first item from data source. It will be used to get the ID of first record. Then we will store its ID in a local variable. (Don't get confused from RecordID column used here. It is nothing but replica of ID column filled using Power Automate on ItemCreate. An index is created on this column.)-
    1. Set(
    FirstRecord,
    First(
        Sort(
            DailyTaskSheetForPowerApps,
            RecordID,
            Ascending
        )
    )
);
UpdateContext({FirstRecordID: FirstRecord.RecordID});
  7. Now, we will get the last record of data source. This will be used to get the last ID of item in data source so that we can calculate total number of records in data source and will iterate accordingly-
    1. Set(
    LastRecord,
    First(
        Sort(
            DailyTaskSheetForPowerApps,
            RecordID,
            Descending
        )
    )
);
  8. Now we will find out how many iterations, we have to do in order to get all records from data source. For this, we are assuming that in one iteration, we will fetch 500 items.
    1. Set(
    MaxIteration,
    RoundUp(
        (LastRecord.RecordID - FirstRecord.RecordID) / 500,
        0
    )
);
  9. We have rounded up the result to next value as in case, if there is any reminder of "(LastRecord.RecordID - FirstRecord.RecordID) / 500", then it will be left from fetching in case if we do not round up.
  10. Now, we will create a collection which will contain 2 column "min" and "max". This collection will have total number of items equal to the total number of iterations we have calculated in previous step "MaxIteration". This "min" and "max" value of each item will be used to filter items from data source and in order to make calculations simple, we have added the FirstRecordID here already-
    1. ClearCollect(
    TotalIterations,
    AddColumns(
        AddColumns(
            ForAll(
                Sequence(MaxIteration),
                Value
            ),
            "min",
            (FirstRecordID + (Value - 1) * 500)
        ),
        "max",
        (FirstRecordID + Value * 500)
    )
);
  11. The last part of the code logic where we will use above collection to fetch items from data source. Here we are using TotalIterations collection to perform Filter action on data source and storing the result in AllTasksCollection-
    1. ForAll(
    TotalIterations,
    Collect(
        AllTasksCollection,
        Filter(
            DailyTaskSheetForPowerApps,
            RecordID >= min && RecordID < max
        )
    );
    
);
  12. This way, we have to not define any static ID or any static logic to get all items from data source. By increasing number of items in data source, this logic will handle those things automatically.
  13. You may refresh the data source on App OnStart.
  14. There will be some warnings of Delegation. This is because, we have used First function which does not support delegation. But we have no other option to get the first record. You may ignore it.



  1. Below is the complete code-
  2. ClearCollect(
    AllTasksCollection,
    []
);
Set(
    FirstRecord,
    First(
        Sort(
            DailyTaskSheetForPowerApps,
            RecordID,
            Ascending
        )
    )
);
UpdateContext({FirstRecordID: FirstRecord.RecordID});
Set(
    LastRecord,
    First(
        Sort(
            DailyTaskSheetForPowerApps,
            RecordID,
            Descending
        )
    )
);
Set(
    MaxIteration,
    RoundUp(
        (LastRecord.RecordID - FirstRecord.RecordID) / 500,
        0
    )
);
ClearCollect(
    TotalIterations,
    AddColumns(
        AddColumns(
            ForAll(
                Sequence(MaxIteration),
                Value
            ),
            "min",
            (FirstRecordID + (Value - 1) * 500)
        ),
        "max",
        (FirstRecordID + Value * 500)
    )
);
ForAll(
    TotalIterations,
    Collect(
        AllTasksCollection,
        Filter(
            DailyTaskSheetForPowerApps,
            RecordID >= min && RecordID < max
        )
    );
    
);
  3. Below is the screenshot to show the entire data fetched from data source and the iterations collections data-


  5. Please remember that- 
    1. Getting all records from SharePoint in PowerApps may lead to performance degrade (if number of records are quite large).
    2. Every call to SharePoint takes some time so as the number of calls gets increase, it will take more time to get the data loaded and hence will put your action in hang mode.
  6. So, please try to avoid as much as possible to get all records in PowerApps. Review your process to avoid such workarounds.
  7. That's all for this topic.

With this, I am concluding this post.
Happy Coding !!!
Will see you again with some new topics.

Stay Safe !
Stay Healthy !

at 1 comment:
Labels: , ,

Thursday, June 3, 2021

DateTime Issue In PowerApps

 Welcome back with another post on PowerApps. We all face DateTime issue when using PowerApps with Power Automate and SharePoint. The reason is that time zone of all these portal is different due to which when we send DateTime value from PowerApps to SharePoint, it gets changed according to the time zone.

The possible solution provided by PowerApps is to set Date time zone to Local as shown in screen below-



But it also not works well. See how-

I had created a list having 2 columns-

  1. Title - Single line of text
  2. WorkDate - DateTime (include time also)
Now, I had created a simple PowerApp using SahrePoint default feature Integrate >> PowerApps >> Create an app. Now, I submitted one record from PowerApp to SharePoint as below-



Clearly, there is a difference in both datetime even I had set the Date time zone to Local.

Therefore, I came up with another workaround. Suppose we have to capture InDateTime. Let's see-

  1. Instead of creating a DateTime column, create 2 columns-
    1. "InDate" - Single line of text
    2. "InTime" - Single line of text
  2. Now in PowerApps, use Date picker as date column "dpInDateEdit". Set Date time zone to Local.


  3. Use drop down to create Hours (ddlInTimeHoursEdit) & Minutes (ddlInTimeMinutesEdit).

  4. This way you can create your own DateTime picker.
  5. Now the question is how to bind current value on screen load in New Entry Form and the default value in Edit Form. For this- 
  6. New Form -
    1. Choose the DefaultDate property of "dpInDateNew" control and set it to -
      1. Today()
    2. Choose the Default property of "ddlInTimeHoursNew" control and set it to -
      1. If(Hour(Now()) < 10,Concatenate("0",Text(Hour(Now()))),Hour(Now()))
    3. Choose the Default property of "ddlInTimeMinutesNew" control and set it to -
      1. If(Minute(Now()) < 10,Concatenate("0",Text(Minute(Now()))),Minute(Now()))
  7. Edit Form - 
    1. Choose the DefaultDate property of "dpInDateEdit" control and set it to -
      1. BrowseGalleryListItems.Selected.InDate
    2. Choose the Default property of "ddlInTimeHoursEdit" control and set it to -
      1. First(Split(BrowseGalleryListItems.Selected.InTime,":")).Result
    3. Choose the Default property of "ddlInTimeMinutesEdit" control and set it to -
      1. Last(Split(BrowseGalleryListItems.Selected.InTime,":")).Result
  8. You will be surprising that why I am splitting the time. The reason is that while saving the data from New/Edit form to SharePoint, I am concatenating the Hours & Minutes value to save in list.
    1. UpdateContext({varInTime:Concatenate(ddlInTimeHoursEdit.SelectedText.Value,":",ddlInTimeMinutesEdit.SelectedText.Value)});
  9. Before saving the date, I am changing it to DatePicker format so that next time, when I will bind it to this control on Edit Form, it will create any issue-
    1. UpdateContext({varInDate:Text(dpInDateEdit.SelectedDate,"mmmm d, yyyy")});
  10. This way, we can resolve the DateTime issue of timezone.
  11. In case, if you wish to save the complete datetime in one column, you may concatenate all 3 values as per the required format and save in single column.
  12. While fetching, you need to split the same and fetch the desired value from the array accordingly.
  13. That's all for this topic.


With this, I am concluding this post.
Happy Coding !!!
Will see you again with some new topics.

Stay Safe !
Stay Healthy !
at No comments:
Labels: , ,

Getting More Than 2000 Items In PowerApps

 Hello Friends,

Welcome back with another post on Power Automate. Today, we will try to read more than 2000 records in PowerApps from SharePoint list. The reason for this article is that, PowerApps, by default read only first 500 records from SharePoint. This can be extend up to 2000 through File >> Settings >> General >> Data row limit. Beyond 2000, PowerApps doesn't support by default. Also, PowerApps do not provide any looping functionality like For loop, For-Each loop, Do-While loop, Do-Until loop. So, we have to play some tricks to achieve this. However this could not be said as best practice but in view of non availability of any looping functionality, we have to use it sometimes to achieve the desired result. There are lots of similar posts / blogs / example available online. All those are also good, The only difference between them any my example is that, I had managed to reduce the number of calls to SharePoint in case if there are no records returned in the previous call. Let's see how-

First, I will give you the scenario and after then we will perform the activity. I have a list named "DailyTaskSheetForPowerApps" where each member of my team put his/her daily task entry. On an average daily around 25 entries got inserted in list which in around 500 per month (averaging 20 working days in a month) or 6000 per year. Now if I want to check the task details of any team member for 2 years back, it would not be possible. So what I will do is-

  1. Create a numeric column named "FormattedInDate" which will hold the task date in YYYYMMDD format.
  2. Create this column as Index column through List Settings >> Indexed columns >> Create a new index.
  3. Now in PowerApps, on button click, I will perform below activity-
    1. Define a variable "varRowsCountInPreviousCall" and set it to 0. This variable will help us to check if my previous call attempt returned records or not.
    2. Define a temporary blank collection "DailyTaskSheetAllItemsCollectionTemp" which will hold the result returned for each call.
    3. Define a blank collection "DailyTaskSheetAllItemsCollection". It will hold all the result returned by each call.
    4. (Optional) Define a variable "varExecutionParts" to show how many execution calls were went to SharePoint.
  4. The code is-
    1. UpdateContext({varRowsCountInPreviousCall: 0});
ClearCollect(
    DailyTaskSheetAllItemsCollectionTemp,
    []
);
ClearCollect(
    DailyTaskSheetAllItemsCollection,
    []
);

UpdateContext({varExecutionParts:""});
  5. Now, I have to bring all records on the basis of "FormattedInDate".
  6. I had set "Data row limit" as 2000 already as mentioned above.
  7. My first call will be for the first 2000 records from 2000 days back to today and for current logged in user.
  8. The code is-
    1. //Execution #1
ClearCollect(
    DailyTaskSheetAllItemsCollection,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20151212 && FormattedInDate <= 20210603 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollection)});
UpdateContext({varExecutionParts:"#1"});
    2. Here I am making a call to SharePoint for return data from 12-Dec-2015 to 03-Jun-2021 for current logged in user.
    3. The result returned is counted and count of total number of rows are saved in "varRowsCountInPreviousCall".
    4. The result set is directly added in "DailyTaskSheetAllItemsCollection" as this is my first call.
    5. Lastly, I had updated the variable "varExecutionParts" with "#1" as this is my first call.
  9. Now I will make my second call for next 2000 records from 21-Jun-2010 to less than 12-Dec-2015 for current user.
  10. The code is-
    1. //Execution #2
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20100621 && FormattedInDate < 20151212 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #2")});
);
  11. See, here I am first check if my previous call has returned the records. If yes, I am making my call to SharePoint for next 2000 records. This resultset is stored in my temporary collection "DailyTaskSheetAllItemsCollectionTemp".
  12. The result returned is counted and count of total number of rows are saved in "varRowsCountInPreviousCall".
  13. The result set is now added in "DailyTaskSheetAllItemsCollection".
  14. Then reset the temporary collection "DailyTaskSheetAllItemsCollectionTemp' to blank.
  15. Lastly, I had updated the variable "varExecutionParts" with appending " #2" as this is my second call.
  16. Now, the steps 9 - 15 have been repeated for next 3 times for each next 2000 records-
    1. //Execution #3
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20041229 && FormattedInDate < 20100621 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #3")});
);

//Execution #4
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 19990709 && FormattedInDate < 20041229 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #4")});
);

//Execution #5
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 19940116 && FormattedInDate < 19990709 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #5")});
);
  17. Lastly, I will print the total number of records returned by all my previous calls and the number of iteration being executed.
    1. Notify(
    Concatenate(
        "DailyTaskSheetAllItemsCollection Items Count- ",
        Text(CountRows(DailyTaskSheetAllItemsCollection)), "  ~~  ",varExecutionParts
    ),
    Success
);
  18. My SharePoint list is having total 4793 records in which 15 records were for other users and rest 4778 are of mine.
  19. Let's see the result displayed as notification-
  20. As you can see, I had written 5 iterations. But out of these first 4 calls brought data from SharePoint while the last one was skipped. The reason is that in 4th iteration, the result count was 0 due to which my 5th iteration condition was not met and hence it saved my 1 call to SharePoint.
  21. The complete code is-
    1. UpdateContext({varRowsCountInPreviousCall: 0});
ClearCollect(
    DailyTaskSheetAllItemsCollectionTemp,
    []
);
ClearCollect(
    DailyTaskSheetAllItemsCollection,
    []
);

UpdateContext({varExecutionParts:""});

//Execution #1
ClearCollect(
    DailyTaskSheetAllItemsCollection,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20151212 && FormattedInDate <= 20210603 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollection)});
UpdateContext({varExecutionParts:"#1"});

//Execution #2
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20100621 && FormattedInDate < 20151212 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #2")});
);

//Execution #3
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 20041229 && FormattedInDate < 20100621 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #3")});
);

//Execution #4
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 19990709 && FormattedInDate < 20041229 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #4")});
);

//Execution #5
If(varRowsCountInPreviousCall > 0,
Collect(
    DailyTaskSheetAllItemsCollectionTemp,
    Filter(
        DailyTaskSheetForPowerApps,
        FormattedInDate >= 19940116 && FormattedInDate < 19990709 && 'Created By'.Email = User().Email
    )
);
UpdateContext({varRowsCountInPreviousCall: CountRows(DailyTaskSheetAllItemsCollectionTemp)});
Collect(DailyTaskSheetAllItemsCollection,DailyTaskSheetAllItemsCollectionTemp);
ClearCollect(DailyTaskSheetAllItemsCollectionTemp,[]);
UpdateContext({varExecutionParts:Concatenate(varExecutionParts, " #5")});
);

Notify(
    Concatenate(
        "DailyTaskSheetAllItemsCollection Items Count- ",
        Text(CountRows(DailyTaskSheetAllItemsCollection)), "  ~~  ",varExecutionParts
    ),
    Success
);
  22. As, currently there is no looping functionality provided by PowerApps, we have to use this workaround.
  23. The next question arises is that, here I am using Date Stamp to filter the data but the date changes every day then how can we manage.
  24. The answer is, when you are creating a list is SharePoint-
    1. Create one more column named "ReplicaID" of numeric type.
    2.  Create this column as Index column through List Settings >> Indexed columns >> Create a new index.
    3. Create a "Automated cloud flow" in Power Automate for "When an item is created (SharePoint)".
    4. In this flow, choose "Update item" action and update the ReplicaID with ID (ItemID of that list item) of list item.
    5. Now, in PowerApps, use the above logic. the only change you need to do is start filtering on this ReplicaID from value 1 to 2000, then 2001 to 4000 and so on up to a certain number of Item ID that you assume to be sufficient for next N number of years.
  25. This way, we can get all records from SharePoint in PowerApps.
  26. You can also customize the DateStamp variables to make it dynamic and assign them the value in YYYYMMDD format starting from current date and then subtracting 2000 from the first variable and so on.
  27. Let me show you, how-
    1. Define a variable varDateNow and assign the value of Now() to it using UpdateContext.
      1. UpdateContext({varDateNow:Now()});
    2. Now convert it to date stamp in format "YYYYMMDD" as below and assign to another variable varDateStamp01-
      1. UpdateContext(
    {
        varDateStamp01: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);
    3. Now subtract 2000 days from varDateNow-
      1. UpdateContext({varDateNow:DateAdd(varDateNow,-2000,Days)});
    4. Repeat Step 26 >> 2 >> 1 to convert it to date stamp in format "YYYYMMDD" and assign to variale varDateStamp02-
      1. UpdateContext({varDateNow:DateAdd(varDateNow,-2000,Days)});
UpdateContext(
    {
        varDateStamp02: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);
    5. Repeat Steps 26 >> 3 and 26 >> 4 two times for assign value to varDateStamp03 and varDateStamp04 in similar manner.
    6. Not print the values using Notify-
      1. Notify(
    Concatenate("V01:- ",
        Text(varDateStamp01),
        "  ~~  ",
        "V02:- ",
        Text(varDateStamp02),
        "  ~~  ",
        "V03:- ",
        Text(varDateStamp03),
        "  ~~  ",
        "V04:- ",
        Text(varDateStamp04)
    ),
    Success
);
    7. The output will be-


    8. If you compare, values in both logic are same-
      1. The process defined earlier in the post where we had put static values in filter.
      2. The process defined just above where we had made these values dynamically.
    9. The complete code for this dynamic value set-
      1. UpdateContext({varDateNow:Now()});
UpdateContext(
    {
        varDateStamp01: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);


UpdateContext({varDateNow:DateAdd(varDateNow,-2000,Days)});
UpdateContext(
    {
        varDateStamp02: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);

UpdateContext({varDateNow:DateAdd(varDateNow,-2000,Days)});
UpdateContext(
    {
        varDateStamp03: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);

UpdateContext({varDateNow:DateAdd(varDateNow,-2000,Days)});
UpdateContext(
    {
        varDateStamp04: Value(
            Concatenate(
                Text(Year(varDateNow)),
                If(
                    Month(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Month(varDateNow))
                    ),
                    Text(Month(varDateNow))
                ),
                If(
                    Day(varDateNow) < 10,
                    Concatenate(
                        "0",
                        Text(Day(varDateNow))
                    ),
                    Text(Day(varDateNow))
                )
            )
        )
    }
);



Notify(
    Concatenate("V01:- ",
        Text(varDateStamp01),
        "  ~~  ",
        "V02:- ",
        Text(varDateStamp02),
        "  ~~  ",
        "V03:- ",
        Text(varDateStamp03),
        "  ~~  ",
        "V04:- ",
        Text(varDateStamp04)
    ),
    Success
);
  28. Please remember that- 
    1. Getting all records from SharePoint in PowerApps may lead to performance degrade (if number of records are quite large).
    2. Every call to SharePoint takes some time so as the number of calls gets increase, it will take more time to get the data loaded and hence will put your action in hang mode.
  29. So, please try to avoid as much as possible to get all records in PowerApps. Review your process to avoid such workarounds.
  30. Please read Delegation in PowerApps to understand why I had not used the default ID column for filtering and created a custom column to achieve the goal. The column ID is not delegable. 
  31. That's all for this topic.

With this, I am concluding this post.
Happy Coding !!!
Will see you again with some new topics.

Stay Safe !
Stay Healthy !

at No comments:
Labels: , ,