Debugging 101: A SharePoint Developer's Guide to Learn and Prepare for interviews

To use the Common Data Service (CDS) in the Power Platform, follow these steps: Go to the Power Platform admin center ( https://admin.powerplatform.microsoft.com/ ) and sign in using your credentials. Click on the 'Environments' option in the left-hand menu and select the environment where you want to create the CDS. Click on the 'Settings' icon at the top right-hand corner of the screen and select 'Power Platform Admin Center'. In the Power Platform Admin Center, click on 'Common Data Service' in the left-hand menu. You can now create a new CDS database by clicking on the 'New' button. Choose a display name for the CDS database and click on the 'Create' button. Once the CDS database is created, you can start adding entities to it. Click on the 'Entities' option in the left-hand menu and then click on 'New Entity'. Fill in the entity details such as the entity name, display name, and description. You can then add attribute...

Steps to create your first canvas app in Power Apps: Go to the Power Apps website (https://powerapps.microsoft.com/) and sign in with your Microsoft account. If you don't have an account, you can create one for free. Click on the "Create" button in the left-hand menu and select "Canvas app". Choose a blank app or a pre-built template for your canvas app. If you choose a blank app, you will have to build the app from scratch. If you choose a template, you will have a pre-built app that you can customize. Give your app a name and select a screen size. You can choose from different sizes for phone, tablet, or computer screens. Once your app is created, you will see the Power Apps Studio. This is where you will build your app by adding screens, data sources, and controls. To add a new screen, click on the "Add screen" button in the left-hand menu and select the type of screen you want to add. To add a data source, click on the "Data sources" butt...

Sure, here's a brief overview of initializing a list and collection in C#: Initializing a List: A list is a collection that can be modified. Here's how you can initialize a list in C#: List<string> names = new List<string>(); // create an empty list names.Add("John"); // add items to the list names.Add("Mary"); Initializing a Collection: A collection is a grouping of objects of the same type. Here's how you can initialize a collection in C#: Collection<string> names = new Collection<string>(); // create an empty collection names.Add("John"); // add items to the collection names.Add("Mary"); Note that both lists and collections can be of different types, depending on what you need them for.  Also, there are other ways to initialize lists and collections in C#, but these are the most basic methods.

Let's say you have some rich textbox columns in Sharepoint online, when we create a default canvas app the columns will show as a plain multiline text field. when we view this content in view mode the content of the Richtext field with HTML added to it.  So to correct this remove the multiline field and add a rich textbox  To replace a multiline text field with a Rich Text Box in Power Apps, you can follow these steps: Delete the multiline text field from the screen by selecting it and pressing the "Delete" key. Insert a new Rich Text Box control onto the screen by selecting it from the "Insert" menu. In the right-hand pane, under the "Data" tab, Change some properties as Default is set to Parent.default and DisplayMode as Parent.DisplayMode. These fields are needed to be set as the value sync automatically with the parent.  Configure the appearance of the Rich Text Box control, such as the font size and color, by selecting the control and using the fo...

 To change the default choice-value in a Power Apps canvas app, you can follow these steps: Select the control that contains the choice field in which you want to change the default value. In the right-hand pane, under the "Data" tab, locate the "Default" property. Click on the "Default" property to open the formula bar. To change the default value of a choice field, you will need to provide the formula that specifies the value. For example, if you have a choice field with the options "Red," "Green," and "Blue," and you want to set the default value to "Green," you can enter the following formula:                     "Green" Alternatively, you can use the "First" or "Last" functions to set the default value to the first or last option in the list. For example:                     First([@Choices].Value)                ...

 Power BI is a business analytics service developed by Microsoft that allows users to analyze data and share insights using interactive dashboards, reports, and data visualizations. The service is part of the Microsoft Power Platform, which also includes Power Apps and Power Automate. With Power BI, users can connect to a wide range of data sources, such as Excel spreadsheets, SQL databases, and cloud-based services such as Microsoft Azure and Dynamics 365. Once connected, Power BI provides a range of tools for creating interactive dashboards, reports, and data visualizations that can be shared with others. Power BI provides a user-friendly interface that allows users to easily create, modify, and share their data visualizations. The service includes a wide range of pre-built visualizations, such as charts, maps, and gauges, as well as custom visualizations developed by the Power BI community. Power BI also includes built-in AI capabilities, such as natural language query, which al...

 Power Automate is a cloud-based service developed by Microsoft that allows users to create automated workflows between different applications and services. The service was previously known as Microsoft Flow, but was rebranded as Power Automate as part of the Microsoft Power Platform. With Power Automate, users can create custom workflows that can integrate with various services, including Microsoft Office 365, Dynamics 365, SharePoint, OneDrive, and many others. These workflows can be triggered automatically based on certain events, such as receiving an email or a new file being added to a SharePoint document library. Power Automate provides a range of pre-built templates and connectors that can be used to create workflows quickly and easily. Users can also create their own custom workflows using a drag-and-drop interface, with no coding required. Workflows can include a wide range of actions, such as sending email notifications, creating new files or records, or updating data in ...

Power Query is a data transformation and cleaning tool developed by Microsoft, which is available as an add-in for Microsoft Excel and as part of the Microsoft Power BI suite. Power Query allows users to import, transform, and cleanse data from various sources in order to create clean, organized data tables that can be used for analysis and reporting. With Power Query, users can connect to a wide range of data sources, including databases, spreadsheets, text files, and web pages. Once connected, Power Query provides a range of tools for transforming the data, such as filtering, sorting, grouping, pivoting, and merging. Users can also create custom calculations and transformations using the M language, which is the scripting language used by Power Query. Power Query has a user-friendly interface that allows users to easily navigate through the various data transformation steps. It also provides a preview of the transformed data, allowing users to see the changes in real-time. Power Quer...

 Power Apps is a low-code platform developed by Microsoft that allows users to build custom applications without needing extensive coding knowledge. With Power Apps, users can create mobile and web applications that can integrate with various data sources such as Excel spreadsheets, SharePoint lists, or SQL databases. Power Apps provides a range of pre-built templates and connectors that can be used to create apps quickly and easily. The platform uses a drag-and-drop interface that allows users to add visual elements such as buttons, forms, and charts to their apps. Users can also customize the layout and functionality of these elements to fit their specific needs. Power Apps also provides built-in security and compliance features to ensure that data is protected and meets regulatory requirements. Users can control access to their apps and data sources using role-based security and multi-factor authentication. In addition to building custom applications, Power Apps can also be used...