We are excited to see the continuous growth on the submissions of the SharePoint Framework (SPFx) solutions to the app source and on the usage of the SharePoint store for extending experiences for SharePoint and Microsoft Viva. Here are the top 10 most wide used ISVs based on the solution installations from the store and/or from Microsoft AppSource during July 2024.

SharePoint Framework is extensibility model for Microsoft Viva, Microsoft Teams, Outlook, Microsoft 365 app and SharePoint. It enables the same code to be used easily across the Microsoft 365 with this widely adopted tooling which uses industry standard tech with easy and automatic SSO and hosting. Usage of SPFx is growing steady and we have currently tens of millions of monthly active users in Microsoft 365 on custom extensibility build with SPFx.

Here are the latest roadmap items around SharePoint Framework and store:

Chart card support for the Viva Connections with the SPFx 1.19 release – more options in upcoming 1.20 release (beta in August 2024)
Deprecation of SharePoint add-in and Azure ACS authentication models – UX powered extensibility should be transformed to us SharePoint Framework powered implementations. Add-in model was introduced back in 2012 and has not really evolved since. This deprecation does not impact SharePoint Framework (SPFx) solutions.
Additional capabilities and features for SharePoint Framework solutions in Microsoft 365 as part of the SPFx 1.18 release.
Enabling Microsoft Viva Connections targeted solutions, powered by SharePoint Framework, in the app source and store – Will be automatically set for suitable SPFx solutions as part of the submission pipeline
Extending SharePoint Framework solutions across the Microsoft 365 with support for Microsoft Teams, Microsoft Viva, Outlook, Microsoft 365 app (Office), SharePoint and more – see the v1.16 release announcement for more details
Alignment of SharePoint Framework solution packaging model with the Microsoft Teams packages – include the best of both worlds and enable SPFx powered solutions across the Microsoft 365
Support for SharePoint Framework solutions in the Microsoft Teams store – no exact schedule, dependent on the previous bullet point
Support SharePoint Framework extensibility for list and library new, edit and view panels 
and more to come…

What about AI extensibility story with SPFx? – Yes. Please see following session from Build 2024 for the preview of the upcoming extensibility options with the SPFx in the context of AI – Integrating your bots and Copilot experiences natively into SharePoint and Viva Connections. These will be also covered in our public community calls in autumn 2024.

We are looking forward to more great solutions that enable innovation, and help our customers get more done with Microsoft Viva, Microsoft Teams, SharePoint and more.

These are the ISVs which has the most usage from the SharePoint store during last month:

Accelerator 365 by Reply

Solution details:

Solutions at app source / store
Solution provider:  Accelerator 365 by Reply

Sprinklr, Inc.

Solution details:

Solutions at app source / store
Solution provider: Sprinklr, Inc.

Achievers

Solution details:

Solutions at app source / store
Solution provider: Achievers

Ichicraft

Solution details:

Solutions at app source / store
Solution provider: Ichicract

Lightning Tools Ltd

Solution details:

Solutions at app source / store
Solution provider: Lightning Tools

Envoqon Software

Solution details:

Solutions at app source / store
Solution provider: Envogon Software

SharePoint|sapiens

Solution details:

Solution at app source / store
Solution provider: SharePoint | sapiens

Bloch Engineering

Solution details:

Solutions at app source / store
Solution provider: Bloch Engineering

Plumsail Inc

Solution details:

Solutions at app source / store
Solution provider: Plumsail Inc

Sharepointalist

Solution details:

Solutions at app source / store
Solution provider: Sharepointalist

Resources

Please see following resources around getting started on building extensibility for Microsoft Teams, Microsoft Viva and SharePoint using SharePoint Framework. 

Announcing SharePoint Framework 1.19 with updates on building enterprise extensibility within Microsoft 365
Announcing SharePoint Framework 1.18 with updates for Microsoft Teams, Microsoft Viva and SharePoint
Announcing general availability of SharePoint Framework 1.16 – Enabling SPFx across Microsoft 365 platform
Explore and deploy SharePoint Framework solutions from partners in SharePoint (Microsoft 365)
Overview of the SharePoint Framework
Publish SharePoint Framework applications to the marketplace
Overview of Viva Connections Extensibility
Guidance for implementing partner offerings for Viva Connections with ACEs and custom APIs
Microsoft Learn – Extend Microsoft Viva Connections
SharePoint Framework samples to get started from Microsoft and community – Microsoft 365 & Power Platform Unified Sample Gallery

Happy coding! 🧡

​Microsoft Tech Community – Latest Blogs –Read More 

Hello, I am trying to make my code automatically paste data on all relevant dates. My issue is that it does no do this due to how my code currently works.

When the dates in C33:C59 cross over from 2025 to 2026 and beyond it should paste on the relevant dates but all I get is “Object variable or With block variable not set” because worksheet 2026 or 2027 is not set. So, is there a way for it to dynamically select the relevant worksheet using the date in C33:C59?

My current code for more context:

Option Explicit

Sub ValidateExportData()
Static LastProcessedRow As Long ‘ Static variable to keep track of the last processed row
Dim RequestForm As Workbook
Dim TaskCalendar As Workbook
Dim DataSource As Worksheet
Dim DataDestination As Worksheet

Dim TrialOwner As Range
Dim TrialTitle As Range
Dim TrialDate As Range

Dim LastRowDate As Long
Dim CurrentDate As Date
Dim OrangeColor As Long
Dim TargetRow As Long
Dim DateRange As Range
Dim Cell As Range
Dim DateCell As Range
Dim isWeekend As Boolean
Dim msg As String
Dim InsertRow As Long

On Error GoTo ErrorHandler ‘ Basic error handling

‘ Initialize variables and open workbooks
Set RequestForm = ThisWorkbook
Set TaskCalendar = Workbooks.Open(“S:SiteDepartmentPerson1Person2Task Management Calendar SystemTask Calendar.xlsx”)
Set DataSource = RequestForm.Worksheets(“Analysis Request Form”)
Set DataDestination = TaskCalendar.Worksheets(“2025”)

Set TrialOwner = DataSource.Range(“E11”)
Set TrialTitle = DataSource.Range(“E12”)
Set TrialDate = DataSource.Range(“E14”)

OrangeColor = RGB(255, 165, 0) ‘ Color code for orange

LastRowDate = DataDestination.Range(“B” & DataDestination.Rows.Count).End(xlUp).Row

‘ Set the range of dates to match
Set DateRange = DataSource.Range(“C33:C59”)

‘ Initialize the LastProcessedRow if it’s the first run
If LastProcessedRow = 0 Then
LastProcessedRow = 2 ‘ Assuming data starts from row 2
End If

‘ Disable screen updating for performance
Application.ScreenUpdating = False

‘ Check if there are rows left to process
If LastProcessedRow <= LastRowDate Then
‘ Process the current row
CurrentDate = DataDestination.Range(“B” & LastProcessedRow).Value

‘ Ensure CurrentDate is a date before proceeding
If IsDate(CurrentDate) Then
‘ Check if the cell color is not orange
If DataDestination.Range(“B” & LastProcessedRow).Interior.Color <> OrangeColor Then
‘ Loop through each date in the range C33:C59
For Each Cell In DateRange
If IsDate(Cell.Value) Then
‘ Check if the date is a Saturday or Sunday
isWeekend = Weekday(Cell.Value, vbSunday) = vbSaturday Or Weekday(Cell.Value, vbSunday) = vbSunday

If isWeekend Then
msg = “Weekend date found: ” & Cell.Address & ” with value ” & Cell.Value
MsgBox msg

‘ Insert a new row based on the weekend date
InsertRow = LastProcessedRow
If Weekday(Cell.Value, vbSunday) = vbSaturday Then
‘ Insert a new row below Friday
InsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value – 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1
DataDestination.Rows(InsertRow).FormatConditions.Delete
ElseIf Weekday(Cell.Value, vbSunday) = vbSunday Then
‘ Insert a new row below Monday
InsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value + 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1
DataDestination.Rows(InsertRow).FormatConditions.Delete
End If

‘ Insert new row and paste data
DataDestination.Rows(InsertRow).Insert Shift:=xlDown
DataDestination.Rows(InsertRow).FormatConditions.Delete
DataDestination.Cells(InsertRow, 4).Value = TrialOwner.Value
DataDestination.Cells(InsertRow, 5).Value = TrialTitle.Value

Else
‘ Find the row matching the date in C33:C59
Set DateCell = DataDestination.Range(“B:B”).Find(What:=Cell.Value, LookIn:=xlValues, LookAt:=xlWhole)
If Not DateCell Is Nothing Then
TargetRow = DateCell.Row

‘ Check if data already exists in the target row
If Application.WorksheetFunction.CountA(DataDestination.Range(“B” & TargetRow & “:B” & TargetRow)) > 0 Then
‘ Insert a new row below the matched row
DataDestination.Rows(TargetRow + 1).Insert Shift:=xlDown
TargetRow = TargetRow + 1 ‘ Update TargetRow to the new row
‘ Clear conditional formatting in the new row
DataDestination.Rows(TargetRow).FormatConditions.Delete
End If

‘ Paste the data into the correct row
With DataDestination
.Range(“D” & TargetRow).Value = TrialOwner.Value
.Range(“E” & TargetRow).Value = TrialTitle.Value
End With
End If
End If
End If
Next Cell
End If
End If

‘ Move to the next row
LastProcessedRow = LastProcessedRow + 1
Else
MsgBox “All rows have been processed.”
End If

Application.ScreenUpdating = True
Application.CutCopyMode = False ‘ Clear the clipboard

TaskCalendar.Save
‘ TaskCalendar.Close SaveChanges:=True

Exit Sub

ErrorHandler:
MsgBox “An error occurred: ” & Err.Description
If Not TaskCalendar Is Nothing Then
TaskCalendar.Close SaveChanges:=False
End If
Application.ScreenUpdating = True

End Sub

​Hello, I am trying to make my code automatically paste data on all relevant dates. My issue is that it does no do this due to how my code currently works. When the dates in C33:C59 cross over from 2025 to 2026 and beyond it should paste on the relevant dates but all I get is “Object variable or With block variable not set” because worksheet 2026 or 2027 is not set. So, is there a way for it to dynamically select the relevant worksheet using the date in C33:C59?  My current code for more context:Option ExplicitSub ValidateExportData()Static LastProcessedRow As Long ‘ Static variable to keep track of the last processed rowDim RequestForm As WorkbookDim TaskCalendar As WorkbookDim DataSource As WorksheetDim DataDestination As WorksheetDim TrialOwner As RangeDim TrialTitle As RangeDim TrialDate As RangeDim LastRowDate As LongDim CurrentDate As DateDim OrangeColor As LongDim TargetRow As LongDim DateRange As RangeDim Cell As RangeDim DateCell As RangeDim isWeekend As BooleanDim msg As StringDim InsertRow As LongOn Error GoTo ErrorHandler ‘ Basic error handling’ Initialize variables and open workbooksSet RequestForm = ThisWorkbookSet TaskCalendar = Workbooks.Open(“S:SiteDepartmentPerson1Person2Task Management Calendar SystemTask Calendar.xlsx”)Set DataSource = RequestForm.Worksheets(“Analysis Request Form”)Set DataDestination = TaskCalendar.Worksheets(“2025”)Set TrialOwner = DataSource.Range(“E11”)Set TrialTitle = DataSource.Range(“E12”)Set TrialDate = DataSource.Range(“E14”)OrangeColor = RGB(255, 165, 0) ‘ Color code for orangeLastRowDate = DataDestination.Range(“B” & DataDestination.Rows.Count).End(xlUp).Row’ Set the range of dates to matchSet DateRange = DataSource.Range(“C33:C59”)’ Initialize the LastProcessedRow if it’s the first runIf LastProcessedRow = 0 ThenLastProcessedRow = 2 ‘ Assuming data starts from row 2End If’ Disable screen updating for performanceApplication.ScreenUpdating = False’ Check if there are rows left to processIf LastProcessedRow <= LastRowDate Then’ Process the current rowCurrentDate = DataDestination.Range(“B” & LastProcessedRow).Value’ Ensure CurrentDate is a date before proceedingIf IsDate(CurrentDate) Then’ Check if the cell color is not orangeIf DataDestination.Range(“B” & LastProcessedRow).Interior.Color <> OrangeColor Then’ Loop through each date in the range C33:C59For Each Cell In DateRangeIf IsDate(Cell.Value) Then’ Check if the date is a Saturday or SundayisWeekend = Weekday(Cell.Value, vbSunday) = vbSaturday Or Weekday(Cell.Value, vbSunday) = vbSundayIf isWeekend Thenmsg = “Weekend date found: ” & Cell.Address & ” with value ” & Cell.ValueMsgBox msg’ Insert a new row based on the weekend dateInsertRow = LastProcessedRowIf Weekday(Cell.Value, vbSunday) = vbSaturday Then’ Insert a new row below FridayInsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value – 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1DataDestination.Rows(InsertRow).FormatConditions.DeleteElseIf Weekday(Cell.Value, vbSunday) = vbSunday Then’ Insert a new row below MondayInsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value + 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1DataDestination.Rows(InsertRow).FormatConditions.DeleteEnd If’ Insert new row and paste dataDataDestination.Rows(InsertRow).Insert Shift:=xlDownDataDestination.Rows(InsertRow).FormatConditions.DeleteDataDestination.Cells(InsertRow, 4).Value = TrialOwner.ValueDataDestination.Cells(InsertRow, 5).Value = TrialTitle.ValueElse’ Find the row matching the date in C33:C59Set DateCell = DataDestination.Range(“B:B”).Find(What:=Cell.Value, LookIn:=xlValues, LookAt:=xlWhole)If Not DateCell Is Nothing ThenTargetRow = DateCell.Row’ Check if data already exists in the target rowIf Application.WorksheetFunction.CountA(DataDestination.Range(“B” & TargetRow & “:B” & TargetRow)) > 0 Then’ Insert a new row below the matched rowDataDestination.Rows(TargetRow + 1).Insert Shift:=xlDownTargetRow = TargetRow + 1 ‘ Update TargetRow to the new row’ Clear conditional formatting in the new rowDataDestination.Rows(TargetRow).FormatConditions.DeleteEnd If’ Paste the data into the correct rowWith DataDestination.Range(“D” & TargetRow).Value = TrialOwner.Value.Range(“E” & TargetRow).Value = TrialTitle.ValueEnd WithEnd IfEnd IfEnd IfNext CellEnd IfEnd If’ Move to the next rowLastProcessedRow = LastProcessedRow + 1ElseMsgBox “All rows have been processed.”End IfApplication.ScreenUpdating = TrueApplication.CutCopyMode = False ‘ Clear the clipboardTaskCalendar.Save’ TaskCalendar.Close SaveChanges:=TrueExit SubErrorHandler:MsgBox “An error occurred: ” & Err.DescriptionIf Not TaskCalendar Is Nothing ThenTaskCalendar.Close SaveChanges:=FalseEnd IfApplication.ScreenUpdating = TrueEnd Sub   Read More

​

La computación en la nube está revolucionando diversas áreas de la tecnología, incluyendo programación, datos, inteligencia artificial (IA) y seguridad. Para ayudar a los profesionales a especializarse en esta área en constante evolución, Microsoft está lanzando la iniciativa Azure Infra Girls. Este programa ofrece una serie de cuatro clases en vivo, gratuitas y en español, que se llevarán a cabo del 3 al 24 de septiembre, a las 12:30pm (GMT-6, Ciudad de México).

Para aquellos que desean profundizar en la computación en la nube y prepararse para la certificación AZ-900 Azure Fundamentals, tenemos una ruta de aprendizaje completa disponible en Microsoft Learn. Esta ruta aborda las principales áreas de la certificación, permitiéndote estudiar de forma gratuita y a tu propio ritmo. Además, al completar los cursos, podrás obtener certificados que pueden ser añadidos a tu perfil de LinkedIn, destacando tus nuevas habilidades y conocimientos.

Los módulos de Microsoft Learn para la certificación AZ-900 incluyen:

Descripción de los conceptos de la nube (25-30 %)
Descripción de la arquitectura y los servicios de Azure (35-40 %)
Descripción de la administración y la gobernanza de Azure (30-35 %)

Práctica para el examen:

Evaluación de sus conocimientos: estas evaluaciones le proporcionarán una infomacion general del estilo, la redacción y la dificultad de las preguntas que probablemente verá en el examen. A través de estas valoraciones, puede evaluar su preparación, determinar dónde necesita preparación adicional y llenar los vacíos de conocimiento para aumentar la probabilidad de aprobar el examen.
Demostración de experiencia: aquí puede experimentar con el aspecto del examen antes de realizarlo. Podrá interactuar con diferentes tipos de preguntas en la misma interfaz de usuario que usará durante el examen.

​Microsoft Tech Community – Latest Blogs –Read More 

Ok, I thought I could just do this via vlookup, but I’m having trouble figuring out all the logic and syntax to it. Can I create a pivot table based on multiple tables? Automatic Data Analysis (that’s something I haven’t looked into, yet, and don’t know much about)?

Here’s what I have:

Two tables – 

1. Employee data in columns A:R (showing alpha column and column reference for vlookup)

    Date in col A (column ref 1)

    Name in col C (column ref 3)

    Emp ID in col D (column ref 4)

    Cost Center in col F (column ref 6)

    Work Center in col G (column ref 7) – may be blank or no matching value found

    Hours in col M (column ref 13)

    Hours type (Regular Hours, Overtime, etc.) in col O (column ref 15)

2. Work center and gang times (standard hours for day)

    Row 7 column C through column H has dates of the week (i.e. 8/5/24, 8/6/24, etc.)

    starting in Row 8 through row 50 column A has a Work center

    columns C through H has the daily gang time for that work center

What I need to compare and data I need at the end:

Basically, I need to check if an employee has more regular hours than what the gang time shows. I’ll need to return the Date, Employee Name, Emp ID, Cost Center, Work Center and regular hours worked plus the static gang time for that work center for the day in order to visually show the variance.

So, output should just be a table of those employees whose timesheet has more hours than the standard for that day. no blank lines – not wanting to just look at the same row each time.

Here’s an example of the output

I’ve attached a sample doc for your visualization of the input data. 

Thank you, in advance, for any help you can provide.

​Ok, I thought I could just do this via vlookup, but I’m having trouble figuring out all the logic and syntax to it. Can I create a pivot table based on multiple tables? Automatic Data Analysis (that’s something I haven’t looked into, yet, and don’t know much about)? Here’s what I have:Two tables – 1. Employee data in columns A:R (showing alpha column and column reference for vlookup)    Date in col A (column ref 1)    Name in col C (column ref 3)    Emp ID in col D (column ref 4)    Cost Center in col F (column ref 6)    Work Center in col G (column ref 7) – may be blank or no matching value found    Hours in col M (column ref 13)    Hours type (Regular Hours, Overtime, etc.) in col O (column ref 15) 2. Work center and gang times (standard hours for day)    Row 7 column C through column H has dates of the week (i.e. 8/5/24, 8/6/24, etc.)    starting in Row 8 through row 50 column A has a Work center    columns C through H has the daily gang time for that work center What I need to compare and data I need at the end:Basically, I need to check if an employee has more regular hours than what the gang time shows. I’ll need to return the Date, Employee Name, Emp ID, Cost Center, Work Center and regular hours worked plus the static gang time for that work center for the day in order to visually show the variance. So, output should just be a table of those employees whose timesheet has more hours than the standard for that day. no blank lines – not wanting to just look at the same row each time.Here’s an example of the output I’ve attached a sample doc for your visualization of the input data. Thank you, in advance, for any help you can provide.   Read More

​