Power Platform Community Forum Thread Details

Hello - I'm stuck on one line in a formula to create recurring appointments to a SharePoint calendar based on a selection of the day of week. The formula logic is from the YouTube video: https://www.youtube.com/watch?v=yGvehOu-oZ8

When I used the date from a date picker, the formula worked, but when I use the same formula with my date variable based on the day of week, I am getting wonky results.

Below are snippets. Any help is greatly appreciated!

OnVisible property of the screen sets date variables for the current week:

User Interface:

User selects a day from gallery - it then offers user ability to select start and end times.

Test label of the Sunday variable:

Variables look correct:

Step 1 of the OnSelect property of my button is to Switch the value from the gallery selection of a day name to an actual date using the date variables above and save as variable varweekday. The ultimate goal is to gather all the available times into a collection and then do one patch to a SharePoint list.

Test of the variable is correct after I selected Wednesday and it is stored as a date:

Step2 of my button:

In a ForAll loop calculated with number of weeks in the time frame start and time frame end date pickers to create a collection of appointments. The part of the formula marked with an arrow is returning incorrect results. (The same formula worked when using a date from a date picker.)