Corporate Programming

 Patch( Questions,  LookUp(Questions, ID = 329),// Find the specific record to update { DuplicateOf: Filter( DuplicateOf, // Existing lookup values ID <> 123 // Replace 123 with the ID of the item you want to remove ) } )

  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...

  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 an...

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 ( pot...

  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

  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...

  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 Apps June 2023 Updates Power Apps June 2023 Updates Enhanced Component Properties Enhanced component properties are a new feature for Microsoft Power Apps that provide clearer and simpler concepts for properties. They are now divided into four types: Data properties: Simple properties that provide input or output data. Function properties: Properties that can accept arguments and return a value, but do not support data flow yet. Events and Actions: Behavior properties that can change the state of the app, such as updating a variable or manipulating a data source. The feature aims to make properties more intuitive and flexible, and to support more scenarios and behaviors. The team has updated the experimental feature and added support for SetFocus() and Select() in the existing. Read more: Enhanced Component Properties Blog Introducing an Easier Than Ever Experience to Import Data from Excel The document announces ...

Welcome to Mastering Power Apps! In this beginner's course, you will learn how to build custom solutions using the Power Apps platform. Whether you're new to Power Apps or have prior experience, this course is designed to help you acquire the necessary knowledge, resources, and skills for creating effective and efficient solutions for your business needs. Introduction Hi everyone, my name is Raj Parihar, and I'm excited to be your guide in this journey of mastering Power Apps. In this course, we'll be covering everything you need to know to get started with building custom solutions using Power Apps. We'll explore the basics of designing and developing apps, connecting to data sources, and other essential skills for creating effective solutions for your business needs. Module 1: Get Started with Power Apps Canvas Apps We will kick off our journey by diving into module 1: Get started with Power Apps Canvas Apps. Here, you'll learn the fund...

As a freelance Power Apps and Power Automate developer, I have extensive experience in creating custom solutions for businesses using SharePoint as the backbone. My Fiverr profile showcases my ability to transform complex business processes into streamlined, user-friendly apps and automations. From automating repetitive tasks to creating custom forms and workflows, I can help your business increase productivity and efficiency. I am well-versed in all aspects of Power Apps and Power Automate development, including data integration, custom connectors, and SharePoint customization. I pride myself on providing high-quality, reliable services to my clients. I have a strong track record of delivering projects on time and within budget. I am also dedicated to ongoing support and maintenance, ensuring that my clients' solutions continue to meet their evolving needs. If you're looking for a freelance Power Apps and Power Automate developer with ...

Question Answer Can you explain the basic concepts and functionality of Power Apps? Power Apps is a low-code platform that allows users to create custom business applications for various purposes such as data collection, automation, and workflow management. It allows users to create mobile and web applications using pre-built templates, drag-and-drop controls, and a visual interface. How do you use Power Apps to create custom business applications? To create a custom business application using Power Apps, one can start by selecting a template or creating a blank app. Then, the user can add various controls such as text boxes, buttons, and labels to the app. The user can also connect the app to various data sources, such as SharePoint or Excel, to populate the controls with data. The user can also add custom logic and formulas to the app to control its behavior. How do you integrate Power Apps with other Office 365 or Microsoft ...

Discover the key to acing Power Apps interviews with our comprehensive video guide. Get ready to tackle the toughest interview questions with confidence and ease as we walk you through the answers to the most commonly asked Power Apps questions. Stay ahead of the competition and take your Power Apps skills to the next level with this must-watch video series.   Check out the playlist: Video Link - Youtube Playlist

Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide Importing data into SharePoint can be a time-consuming and complex task, but with Power Automate Flow, you can easily import JSON data into SharePoint with just a few clicks. In this post, we'll show you how to do just that with a step-by-step guide. Why Import JSON Data into SharePoint with Power Automate Flow? JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. It's a popular format for exchanging data between different systems and applications, and it's often used to store and transfer data over the web. By importing JSON data into SharePoint, you can make this data easily accessible and manageable in SharePoint. How to Effortlessly Import JSON Data into SharePoint with Power Automate Flow Here's a step-by-step guide to effortlessly importing JSON data into SharePoin...

Unleash the Power of Power Automate: Fetch Over 50,000 Records from a SharePoint List with Ease Power Automate is a powerful tool that can help streamline your data management process and make it easier to work with large amounts of data. In this post, we will show you how to fetch over 50,000 records from a SharePoint List using Power Automate flow. This solution is quick, efficient, and extremely easy to implement. Why Fetch Over 50,000 Records from a SharePoint List with Power Automate Flow? SharePoint lists are a great way to store and organize data, but working with large amounts of data can be challenging. Manual data entry and updates can be time-consuming and error-prone. That's where Power Automate flow comes in. By automating the process of fetching data from SharePoint lists, Power Automate flow makes it possible to quickly retrieve large amounts of data and keep it up to date with minimal effort. How to Fetch Over 50,000 Records from a SharePoint List with Power Automat...