Posts

Generic Design Powerapps, Sharepoint and flow

  1. Backend: SharePoint You will use SharePoint to store all the data required for the event management system. Create the following SharePoint lists for different entities: Event List : Stores event details (e.g., Event Name, Date, Location, Description, Organizer, Capacity, Registration Deadline). Columns: Title, EventDate, Location, Description, Organizer, Capacity, RegistrationDeadline, etc. Attendees List : Tracks attendees for each event. Columns: AttendeeName, Email, Event (Lookup to Event List), RegisteredDate, Status (Registered, Waitlisted), etc. Feedback List : Captures feedback from attendees post-event. Columns: Event (Lookup), Attendee (Lookup), Rating, Comments, etc. Notification Settings List : Manages notification triggers and timing for automated emails. Columns: NotificationType (e.g., Reminder, Registration Confirmation), TimeBeforeEvent (in hours/days), EmailTemplate, etc. 2. Front End: Power Apps The Power Apps application will serve as the main interface for bot

Dev ops Board

  Epic: Enhance SharePoint Landing Page (General Users) Feature 1: Intelligent Question Answering User Story 1: User asks a question As a general user, I want to be able to ask a question related to the organization, so that I can get a quick and accurate answer. Acceptance Criteria: User can input a question in a text box. System displays a loading indicator while processing the query. System displays the answer generated by Azure OpenAI based on Azure Search results. System displays a notification if no answer is found. Tasks: Create a text input field for the user to enter their question. Implement a loading indicator to display while processing the query. Integrate Azure Search to retrieve relevant documents based on the question. Integrate Azure OpenAI to generate an answer based on the retrieved documents. Display the generated answer to the user. Implement a notification system to display when no answer is found. Handle potential errors during search, AI processing, or answer

Us Time Handle

let newDate ; // 1. Determine User's Time Zone (if possible) if ( langCode ) {   try {     newDate = moment . utc ( date ). tz ( langCode );   } catch ( error ) {     console . error ( "Error converting date to user's time zone:" , error );     // Handle the error (e.g., use UTC time or display an error message)   } } else {   // 2. Handle Unknown Time Zone (improved heuristic)   const offset = moment . utc ( date ). utcOffset () / 60 ; // Get UTC offset in hours   // Consider a mapping of offsets to time zones (replace with your data)   const timeZoneMapping = {     '-4' : 'US/Eastern' , // Eastern Time (DST)     '-7' : 'US/Pacific' ,   // Pacific Time (DST)     // Add other time zones as needed   };   const potentialTimeZone = timeZoneMapping [ offset . toString ()];   if ( potentialTimeZone ) {     newDate = moment . utc ( date ). tz ( potentialTimeZone );   } else {     // Handle cases where no matching offset

Pnp to reterive all pages

  Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/YourSite" -Credentials ( Get-Credential ) # Get the site pages library $sitePagesLibrary = Get-PnPList -Identity "Site Pages" # Query for pages where "isincludeinnews" is "yes" $pagesToUpdate = Get-PnPListItem -List $sitePagesLibrary -Query "<View><Query><Where><Eq><FieldRef Name='isincludeinnews' /><Value Type='Boolean'>1</Value></Eq></Where></Query></View>" # Update the specific column for each page foreach ( $page in $pagesToUpdate ) { # Set the value of the target column (e.g., "YourTargetColumn") $page [ "YourTargetColumn" ] = $false # Set to false to match your condition $page .Update() } # Execute the changes Invoke-PnPQuery

URS, FS and DS Documents layout in Software Development

  User Requirement Specification (URS) : Objective : Create an SPFx extension for news notifications on the home page. Scope : Display two types of news: “My News” (from an SQL table) and “Corporate News” (from a different site collection’s Site Pages library). Implement read/unread functionality (gray for read, yellow for unread). Mention the SharePoint list library names where you’ll store data (e.g., “My News” and “Corporate News”). Technical Specifications : Use SPFx framework, React, and REST API for SharePoint data retrieval. Integrate with SQL data using a console application. Specify the SharePoint lists and SQL tables you’ll interact with. Commercial Terms : N/A (since it’s an internal project). Functional Specification (FS) : Design and Construction : SPFx web part layout: Top right corner of the home page. UI design: Display news items with read/unread indicators. Functional Requirements : Fetch data from SQL table and SharePoint list. Implement read/unread logic. Handle dis

Bulk Rollback of SharePoint Items Version using Power Automate

Image
  In this video, we will demonstrate how to use #PowerAutomate to perform a bulk rollback of #SharePoint items versions. We will walk you through the process of setting up a flow that can restore previous versions of multiple SharePoint items at once. This can be useful in situations where changes have been made to a large number of items and need to be reverted quickly. Join us as we explore this powerful feature of #PowerAutomate and #SharePoint.

Power Up Your Workflows: Latest Updates and Features in Power Automate 2023 wave 2

Image