SharePoint Archives - Software Zone 365

Mastering SharePoint List Formulas: Step-by-Step Guide to Calculating and Storing Values

Leave a Comment / Power-Apps / Ali Haroon / December 1, 2023 / Aesthetics Enhancement, App Creation, Automatic Computation, Data Repository, data storage, Edit Form Setup, Field Computing, Form Calculations, Input Data Processing, List Formulas, Patch Function, Price Quantification, Sales Tax Calculation, SharePoint, SharePoint Integration, SubmitForm Function, Total Price Computation, Usability Improvement, User Inputs, User-Friendly Methods

Introduction: Working with SharePoint often involves calculating fields. This guide shows a simple method using forms to do this. If this query resonates with you, this guide will illuminate a straightforward method, utilizing forms, to achieve this task seamlessly. Understanding Field Calculations and Data Storing Calculations on input data are common. This guide offers […]

Mastering SharePoint List Formulas: Step-by-Step Guide to Calculating and Storing Values Read More »

Guide to Resolving Time Mismatch in Power Apps and SharePoint: How to Change SharePoint Timezone

Leave a Comment / Power-Apps / Ali Haroon / December 1, 2023 / Data Accuracy, data alignment, data consistency, Date & Time, global regions, Power Apps, Power Apps interface, regional settings, settings modification, SharePoint, SharePoint Administration, SharePoint discrepancy, SharePoint list, site settings, synchronization, time management, time values, timezone, user browser, UTC

Introduction: Encountering date-time discrepancies in Power Apps due to SharePoint timezone settings can be challenging. This guide focuses on resolving these issues by changing the SharePoint timezone, ensuring that date-time values align accurately between Power Apps and SharePoint. Dissecting the Date-Time Discrepancy Managing date-time values within Power Apps can sometimes be intricate. Particularly when interfacing

Guide to Resolving Time Mismatch in Power Apps and SharePoint: How to Change SharePoint Timezone Read More »

Generating Random Numbers in Power Apps: Best Practices & Solutions

Leave a Comment / Power-Apps / Mudassar Mazhar / December 1, 2023 / App Design, App Development, App Formula, best practices, dashboard design, data delegation, data row limit, Data Source, formula efficiency, gaming applications, numeric identity, Power Apps, property records, Rand function, random data, random records, SharePoint, Shuffle function, task allocation, unique numbers

Randomly selecting records or rows from a data source is a frequent requirement in app development. Whether you’re building a game, a dashboard, or a task allocation app, being able to fetch random data comes in handy. In Power Apps, there are specific functions designed for this purpose. However, understanding their strengths and limitations is

Generating Random Numbers in Power Apps: Best Practices & Solutions Read More »

Utilizing export-pnplisttositetemplate for SharePoint List Transfer with Lookup Data Maintenance

Leave a Comment / Power-Apps / Mudassar Mazhar / December 1, 2023 / Add-PnPDataRowsToSiteTemplate, Connect-PnPOnline, data integrity, Data Management, data migration, Export-PnPListToSiteTemplate, field definitions, Invoke-PnPSiteTemplate, IT administration, List Transfer, lookup data, Microsoft 365, PnP Framework, PowerShell, script automation, SharePoint, SharePoint Lists, SharePoint Migration, SharePoint Sites, XML template

Introduction: With SharePoint becoming an integral part of businesses, a frequent challenge faced by many is exporting and importing sets of SharePoint lists while maintaining their lookup data. With the advent of the PowerShell commands and especially the export-pnplisttositetemplate, this task has been streamlined. In this guide, we’ll dive deep into how to seamlessly perform

Utilizing export-pnplisttositetemplate for SharePoint List Transfer with Lookup Data Maintenance Read More »

Best Practices: Copying PowerApps Screens Across Different Environments

Leave a Comment / Power-Apps / Ali Haroon / November 30, 2023 / App Customization, App Development, App Integration, app migration, Canvas Apps, data connections, data transfer, efficient copying, Fluent UI, Model-Driven Apps, Power BI, Powerapps, PowerApps Guide, PowerApps Techniques, screen replication, screen transfer, SharePoint, Teams Integration, User Interface

Transferring data across multiple platforms can sometimes be daunting, especially in PowerApps. One recurring query that we come across is the copying of PowerApps from one environment to another, particularly when dealing with screens. This guide will walk you through an efficient technique to achieve this, ensuring a seamless experience for your app development

Best Practices: Copying PowerApps Screens Across Different Environments Read More »

Efficiently Count Non-Blank and Blank Rows in Power Apps using IsBlank

Leave a Comment / Power-Apps / Mudassar Mazhar / November 30, 2023 / CountA Function, Data Analysis, Data Counting Techniques, Data Evaluation, Data Management, Data Source Delegation, Efficiency in Power Apps, IsBlank Function, Microsoft Dataverse, Microsoft PowerFX, Parent-child data, Power Apps, Power Apps Configuration, Power Apps Formula Language, Power Apps Galleries, Property types, Records Management, SharePoint, TaxBand Counting

Efficiently Count Non-Blank and Blank Rows in Power Apps using IsBlank Introduction: In the world of data management, it’s often essential to quickly evaluate and count non-blank records. For those using Microsoft’s Power Apps, there’s a specific function designed for this exact purpose: CountA. This blog will provide an in-depth look at how to effectively

Efficiently Count Non-Blank and Blank Rows in Power Apps using IsBlank Read More »

Mastering the ‘123 Patch’ Technique: Updating SharePoint Columns with Power Apps

Leave a Comment / Power-Apps / Sheraz Manzoor / November 30, 2023 / 123 Patch Technique, Client Locations, Data Management, Data Modification, Dropdown Patch, Efficient Patching, Patch Function, Power Apps, Power Apps Functions, Power Apps Guide, SharePoint, SharePoint Data Update, SharePoint Integration, SharePoint list, SharePoint Tutorial, Single Line Text, Text Column Update, Text Input Patch, Update Columns

How to PATCH a SharePoint Single Line Text Column using Power Apps When working with Power Apps, often the need arises to modify data in a SharePoint list. This guide will walk you through the simple process of updating a SharePoint Single Line Text column using the “123 patch” in Power Apps. Whether you’re a

Mastering the ‘123 Patch’ Technique: Updating SharePoint Columns with Power Apps Read More »

How to Update a SharePoint List Lookup Column in Power Apps

Leave a Comment / Power-Apps / Ali Haroon / November 28, 2023 / Business Process, Business Solutions, Cloud Services, Collaboration, customization, Data Management, Data Manipulation, Digital Transformation, efficiency, Integration, IT Solutions, Lookup Column, Microsoft, Office 365, Patch Function, Power Apps, SharePoint, Technical Skills, Update, Workflow

How to Update a SharePoint List Lookup Column in Power Apps Welcome to this comprehensive guide on how to effectively change the values of a SharePoint list lookup column using Power Apps. As businesses expand, the need for efficient data management grows. Utilizing SharePoint and Power Apps together is a powerful combination for such

How to Update a SharePoint List Lookup Column in Power Apps Read More »

Filter A SharePoint Multiple Person Type Column With No Delegation Warning

Leave a Comment / Power-Apps / Ali Shahzad / November 27, 2023 / App Development, cloud flow, collaboration tools, customization, Data Management, department lookup, efficient processing, filter action, Integration, JSON parsing, multiple selections, Power Apps, Power Automate, Power BI, Power Virtual Agent, project team, SharePoint, SharePoint list, User Interface, Workflow Automation

Filter A SharePoint Multiple Person Type Column With No Delegation Warning Setup The SharePoint List Create a SharePoint list named Projects Backlog with the following columns: ID – autonumber column Title – text column ProjectTeam – person column with allow multiple selections set to true ID Title Project Team 1 Time Off Request App Ali Shahzad 2

Filter A SharePoint Multiple Person Type Column With No Delegation Warning Read More »

Power Apps People Picker Delegation Workaround

Leave a Comment / Power-Apps / Ali Shahzad / November 27, 2023 / App Development, Data Integration, Data Management, Efficiency Boost, Employee Selection, Form Customization, Form Submission., IT Hardware Requests, Microsoft Power Platform, Office 365, Organizational Tools, People Picker, Power Apps, SharePoint, Technology Solutions, User Interface, User Search, User-Friendly Apps, Workaround, Workflow Improvement

Power Apps People Picker Delegation Workaround Introduction: The I/T Hardware Request App The I/T Hardware Order Tool allows managers to acquire new computer devices for their team members. The manager chooses an employee from the dropdown menu, picks the desired hardware, and forwards the request to the I/T department. Setup The SharePoint List Set up

Power Apps People Picker Delegation Workaround Read More »