Tag Archives: microsoft
Intune Management Extension not installed on 200+ PC’s
Hi all
We recently moved from LOB apps to W32 to prepare for our upcoming autopilot rollout
While pushing apps out via W32, we noticed that the apps would install on about half of our PC’s but not even report on the other half.
Via some digging, we found that the IME failed to install on these PC’s
Does anyone have a way to install this on 200+ PC’s correctly? The majority of PC’s are hybrid joined and there is no rhyme or reason as to why this is happening
On the PC’s there is no IME records in registry or in file explorer, its as if the PC never had the extension in the first place
Any help is greatly appreciated
Thanks!
Hi all We recently moved from LOB apps to W32 to prepare for our upcoming autopilot rollout While pushing apps out via W32, we noticed that the apps would install on about half of our PC’s but not even report on the other half. Via some digging, we found that the IME failed to install on these PC’s Does anyone have a way to install this on 200+ PC’s correctly? The majority of PC’s are hybrid joined and there is no rhyme or reason as to why this is happening On the PC’s there is no IME records in registry or in file explorer, its as if the PC never had the extension in the first place Any help is greatly appreciated Thanks! Read More
New to excel if formula question
It’s been a few years since I last used formulas in excel and I have a spreadsheet that I want it to automatically output a name if it reads a certain data set. Like for my spreadsheet, I want to automatically assign an employees name based off of what state the property is located in. Any help would be appreciated Thank you.
It’s been a few years since I last used formulas in excel and I have a spreadsheet that I want it to automatically output a name if it reads a certain data set. Like for my spreadsheet, I want to automatically assign an employees name based off of what state the property is located in. Any help would be appreciated Thank you. Read More
Facility Check Time, Shift Time Check Calculated Column
I have a facility check SP List that users, through Power apps log safety checks. They are to complete these checks on each shift and within 1 hour of the shift starting.
I need a calculated column that can look at the the Shift Value and the Time it was logged and change a value in the Calculated column to Say Pass / Fail.
So as an example if the AM shift starts at 06:55:00 then the target time for the check is 07:55:00.
IF (AM – Shift Time>07:55:00,”Fail”, “Pass)
Can this be converted to a calculated column, as well as looking up the multiple shift values?
The last column in my excel example is the time over the target time.
I have a facility check SP List that users, through Power apps log safety checks. They are to complete these checks on each shift and within 1 hour of the shift starting. I need a calculated column that can look at the the Shift Value and the Time it was logged and change a value in the Calculated column to Say Pass / Fail. So as an example if the AM shift starts at 06:55:00 then the target time for the check is 07:55:00. IF (AM – Shift Time>07:55:00,”Fail”, “Pass) Can this be converted to a calculated column, as well as looking up the multiple shift values? The last column in my excel example is the time over the target time. Read More
Is it possible for the dotnet command to not publish some files?
I’ve received an unusual request from some users of an ASP.NET Core app. I’m using the dotnet command to clean and publish the solution, to a server in our network, using a GitHub self-hosted runner on another server. They don’t want the dotnet command to publish the “appsettings.json” and “appsettings.Developer.json” files. Is there a way of preventing dotnet from publishing some files?
Here’s the code snippet I’m using from the YAML file:
– name: Clean build
run: dotnet clean $env:Solution_Name
– name: Publish app
run: dotnet publish -c Release $env:Solution_Name /p:PublishProfile=VaccineRegDevProfile
I’ve received an unusual request from some users of an ASP.NET Core app. I’m using the dotnet command to clean and publish the solution, to a server in our network, using a GitHub self-hosted runner on another server. They don’t want the dotnet command to publish the “appsettings.json” and “appsettings.Developer.json” files. Is there a way of preventing dotnet from publishing some files? Here’s the code snippet I’m using from the YAML file: – name: Clean build
run: dotnet clean $env:Solution_Name
– name: Publish app
run: dotnet publish -c Release $env:Solution_Name /p:PublishProfile=VaccineRegDevProfile Read More
How to verify column contains only digits and space
Hello Folks,
is there an easy way to verify a SP column contains only digits and spaces ?
I want to use “Replace” function to change ” ” (spaces) into “” (empty string) and then verify with “isnumber” but find/replace works only on the first founded space.
Any suggestions will be welcome
Hello Folks, is there an easy way to verify a SP column contains only digits and spaces ?I want to use “Replace” function to change ” ” (spaces) into “” (empty string) and then verify with “isnumber” but find/replace works only on the first founded space.Any suggestions will be welcome Read More
écrire avec le mail d’un groupe
Je veux envoyer un mail avec le mail d’un groupe. Comment faire ?
Je veux envoyer un mail avec le mail d’un groupe. Comment faire ? Read More
Request for Email Activity Report with Internal/External Breakdown
Hi everyone,
Is it possible to generate a report that shows the number of emails sent and received by each user, with a breakdown of internal and external emails?
I understand that we can find some basic metrics in the admin center under Reports > Usage > Exchange > Email activity. However, this does not separate the count of internal and external emails.
Does anyone have any suggestions or know of a way to achieve this?
Thank you!
Hi everyone, Is it possible to generate a report that shows the number of emails sent and received by each user, with a breakdown of internal and external emails? I understand that we can find some basic metrics in the admin center under Reports > Usage > Exchange > Email activity. However, this does not separate the count of internal and external emails.Does anyone have any suggestions or know of a way to achieve this?Thank you! Read More
Sum of calculated Currency column without Power Automate
I have a Microsoft List for our projects with a calculated currency column calculating estimated fee income based on a percentage (from a separate column) of the project value column.
I want to have the Estimated fees column display a sum at the bottom, just like a numeric column can.
I understand that this can’t currently be done with the currency column, but there are apparently workarounds with Power Automate.
I don’t want to disappear down this rabbit hole/time vacuum at least for now, so I’m wondering if there is a simple workaround using a numeric column, with JSON custom formatting to display currency symbols and comma separation to turn number like this 11000 into this £11,000.00.
Is this too simplistic?
I have a Microsoft List for our projects with a calculated currency column calculating estimated fee income based on a percentage (from a separate column) of the project value column. I want to have the Estimated fees column display a sum at the bottom, just like a numeric column can. I understand that this can’t currently be done with the currency column, but there are apparently workarounds with Power Automate. I don’t want to disappear down this rabbit hole/time vacuum at least for now, so I’m wondering if there is a simple workaround using a numeric column, with JSON custom formatting to display currency symbols and comma separation to turn number like this 11000 into this £11,000.00. Is this too simplistic? Read More
Purview DLP policy not applying to meeting requests sent from MS Teams
We have a Purview DLP policy that was originally applied to exchange location and applied to mail enabled security group. The users in these groups get the policy applied successfully and MS Teams meeting invite without classification label gets blocked.
Then we added few more M365 groups to this DLP policy. But the users in these M365 groups are not getting the policy and the MS Teams meeting invite without classification label can still be sent successfully by users in these M365 groups.
I looked at the exchange trace log for invite sent by one of these users and see the invite does not match any DLP rule and is thus sent. For a meeting invite from user in the mail enabled group the rule matches and it is blocked.
Are M365 groups not supported for this type of DLP policy?
What other logs or steps I can take to resolve this?
We have a Purview DLP policy that was originally applied to exchange location and applied to mail enabled security group. The users in these groups get the policy applied successfully and MS Teams meeting invite without classification label gets blocked.Then we added few more M365 groups to this DLP policy. But the users in these M365 groups are not getting the policy and the MS Teams meeting invite without classification label can still be sent successfully by users in these M365 groups.I looked at the exchange trace log for invite sent by one of these users and see the invite does not match any DLP rule and is thus sent. For a meeting invite from user in the mail enabled group the rule matches and it is blocked.Are M365 groups not supported for this type of DLP policy?What other logs or steps I can take to resolve this? Read More
Validate the data logger data
Here the data is downloaded from the data Logger
We want to check the pass or fail Allowable limit is given below the picture
Is it possible to check the readings are within the limit or out of limit
please guide me how to solve
Here the data is downloaded from the data LoggerWe want to check the pass or fail Allowable limit is given below the pictureIs it possible to check the readings are within the limit or out of limitplease guide me how to solve Read More
New on Microsoft AppSource: June 1-6, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 120 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
AIPictoNarrator System: This software-as-a solution offer from GNS Technology uses AI to create videos from text descriptions. It generates images, transforms them into a video, and offers editing tools. The AIPictoNarrator System helps educators, marketing, and social media professionals reduce production time and costs while enhancing their ability to tell compelling stories.
BitFractal AutoQM API for Contact Centers: Automate your call center’s quality management processes and agent evaluations using advanced generative AI with AutoQM API from BitFractal. It supports over 140 languages and transcribes calls, analyzes and summarizes interactions, indexes them to the CRM, and auto scores the entire interaction. The API combines Text to Speech, Language AI, OpenAI on Azure, and Speech to Text with support for voice and text in a single API call.
Clinictrak: Clinictrack Practice Management Software helps medical practitioners increase revenue, reduce costs, and improve operational efficiency while providing high-quality patient care. It offers real-time analytics through customizable reports and dashboards to track, manage, and optimize clinic operations. It also allows for complete record storage and retrieval in a single click, accessible anytime and anywhere.
Data Cloud: Snowflake’s Data Cloud integrates and analyzes data, enabling organizations to unite siloed data, securely share data, and execute diverse analytic workloads. It delivers a single data experience that spans multiple clouds and geographies, with near-unlimited resources and governed, secure collaboration.
DEXBOARD: Developed by Datasource Expert, DEXBOARD aims to democratize information across your organization by enabling more users to access corporate data insights and business reports. It utilizes Microsoft Power BI to connect disparate data sets, transform and clean the data into a data model, and create charts or graphs to provide visuals of the data. This service is available only in Portuguese.
EIRAVATO: Gain complete visibility into your waste management practices with EIRAVATO’s AI-powered automation platform. With EIRAVATO, businesses can enhance their brand reputation, increase operational efficiency, and go beyond basic compliance practices. With standardized, measurable outputs and environmental intelligence, the app can optimize resource usage, reduce costs, and improve sustainability.
FilmEssenceAI: This solution from GNS Technology uses AI to create 30-60 second summary videos of full-length movies. The FilmEssence AI system analyzes the content of the film, extracts significant scenes, and constructs a cohesive summary. Ideal for entertainment, marketing, and social media, it enhances viewer engagement while reducing production time and costs.
Legacy Document Archive: Legacy Document Archive lets businesses import and retain access to historical posted sales and purchase transactions and associated attachments in Microsoft Dynamics 365 Business Central. Documents can be imported from previous legacy system using Microsoft Excel and uploaded into Business Central through configuration packs for convenient long-term access and reporting.
Merox: Merox is a domain-based message authentication, reporting, and conformance (DMARC) compliance tool to improve email deliverability and DNS compliance. The platform provides insights into email traffic and potential threats, and helps implement advanced protocols such as SPF, DKIM, DMARC, and BIMI. Merox offers quick setup and enhances email security and marketing performance.
Notes Consolidator for Dynamics 365: Advaiya Solutions provides users with a single interface to access and manage notes associated with accounts and connected records like opportunities, leads, and contacts within Microsoft Dynamics 365 Sales. The app centralizes and simplifies the note-viewing experience, streamlines workflow processes, and enhances collaboration.
OPS – Customer Portal: The Customer Portal for Microsoft Dynamics 365 Business Central from Intelegain Technologies allows B2B customers to view item availability, place orders, and track dispatches and shipments without human intervention. It solves the challenges of tracking dispatches over call or email, lack of real-time visibility on item availability, and human errors in punching sales orders.
ReachFive: This customer identity and access management (CIAM) hub from ReachFive provides a frictionless and secure customer experience by offering authentication methods, data control, unified profiles, access control, and cloud-native deployment options. The platform connects customers, brands, partners, and applications securely, to deliver always-on customer experiences and flexible options.
Short Video Creative Production System: The Short Video Creative Production System from GNS Technology uses AI and robotics to automate the creation of engaging video content. It generates original scripts, captures high-quality footage, and edits it into polished videos, ideal for e-commerce and social media. This system enhances marketing impact while reducing costs.
SkyArcs Asset Management: Discover QR codes backed by monitoring software for simple asset management. SkyArcs Asset Management from MOKO Solution provides real-time visibility and control over your business’ most important assets, streamlining operations and driving growth.
Snow SaaS Manager: This solution from Flexera helps businesses eliminate redundant applications, negotiate renewals, reduce SaaS vendor sprawl, and identify unsanctioned or risky applications. Unlike other SaaS discovery methods, Snow provides verified usage information, allowing businesses to find allocated but unused licenses, downgrade from expensive premium bundles, and identify security risks.
TMAP Warranty.AI: TMAP provides real-time insights and predictive capabilities that enable you to make proactive and informed decisions. This solution from Tavant Technologies uses AI models to automate warranty claims processing, detect fraud, improve dealer performance, and reduce warranty spend. Gain actionable insights from your warranty data with this AI-powered warranty analytics platform.
Trimble Mapping, Mileage & Routing Services: This suite of development tools for map-centric applications in the transportation industry includes routing, geocoding, location search, and optimization services. Widely used by carriers, shippers, brokers, and other transportation management providers, these services include access to an extensive commercial vehicle road network library with truck restrictions, dimensional restrictions, control zones, access rules, and more.
VoicePing: Effortlessly host multi-language conferences, events and business meetings with VoicePing. This real-time voice translation service, available as a Microsoft Windows desktop application, uses AI to transcribe and translate system audio, making global business communication involving multiple languages smoother.
XTEL AI Enterprise Revenue Growth & Trade Suite: StepUp RGM’s offer harnesses AI-driven technologies with state-of-the-art tools to help you maximize revenue growth and optimize trade promotion effectiveness. These AI-first strategies streamline planning, enhance forecast accuracy, improve promotional performance, and increase profitability through intelligent data use and advanced analytics.
Zenisort: Silver Coast Consulting’s AI-powered solution automates tasks, prioritizes messages, and keeps your inbox organized. As emails arrive, Zenisort immediately categorizes them based on learned patterns and efficiently sorts them to keep your inbox uncluttered and ready for action.
Go further with workshops, proofs of concept, and implementations
Apps and Automation Action Accelerator: 2-Day Workshop: This workshop by eGroup Enabling Technologies will offer a Microsoft 365 and Microsoft Power Platform action accelerator to help you understand Power Apps, Power Automate, Power BI, and Copilot Studio. The workshop prioritizes app and automation initiatives and creates a roadmap for implementation.
Apps and Automation In-A-Day: 1-Day Workshop: eGroup Enabling Technologies will offer an overview of the Microsoft Power Platform, including Power Apps, Power Automate, Power BI, and Copilot Studio. Participants will gain insights into licensing, governance, and applicability, and learn how to modernize their Microsoft 365 data. The workshop also covers low code and citizen development concepts.
Apps and Automation Results-Yielding Implementation: 4-Week Program: With the Result-Yielding Implementation, eGroup Enabling Technologies will provide you a designed, developed, tested, and implemented Microsoft Power Platform technical solution utilizing your Microsoft 365 data. It includes organizational change management and solution support.
Business Central Adventurer Package: 8-Week Fixed Fee Implementation: The experts from TruNorth Dynamics will help you implement Microsoft Dynamics 365 Business Central using a fixed fee pricing model. The Adventurer Package migrates one company and includes AP check printing format for one banking institution, one EFT export mapping, and one .CSV bank statement import mapping. Ten hours of instructor-led training and a user acceptance testing plan are also provided.
Business Central Explorer Package: 8-Week Fixed Fee Implementation: The experts from TruNorth Dynamics will help you implement Microsoft Dynamics 365 Business Central using a fixed fee pricing model. The Explorer Package migrates one company, includes AP check printing format for one bank, one EFT export mapping, and one .CSV bank statement import mapping. One-time data migration imports and eight hours of training are also provided.
Business Central Trailblazer Package: 10-Week Fixed Fee Implementation: The experts from TruNorth Dynamics will help you implement Microsoft Dynamics 365 Business Central using a fixed fee pricing model. The Trailblazer Package migrates one company and includes AP check printing format, EFT export mapping, and .CSV bank statement import mapping. It also provides training and user acceptance testing for general ledger, sales & receivables, purchases & payables, and fixed assets.
Microsoft Copilot: 2-Day Adoption Workshop: INSOMEA helps companies of all sizes and sectors adopt Microsoft Copilot with tailored strategies, change management support, ongoing maintenance, and collaboration with industry experts. This workshop will empower participants and increase productivity, efficiency, and innovation within organizations.
Microsoft Copilot: Rightpoint offers consulting services to help businesses leverage Copilot for Microsoft 365. This AI-driven workflow tool can unlock unprecedented efficiency and innovation. Rightpoint’s human-centered design approach puts employees at the center of the opportunity, focusing on user experience and custom plugins. Industry-specific use cases and solutions are available for various sectors.
Copilot for Microsoft 365 Readiness: 2-Day Workshop: The Copilot for Microsoft 365 Workshop is a two-day program that helps users unlock the full potential of Copilot’s features within the Microsoft 365 suite. The program includes a deep dive assessment, personalized planning, and a clear plan of action for users to make the most of Copilot.
Copilot for Microsoft 365: 4-Week Proof of Value: Reliance Infosystems will offer up to 20 Copilot for Microsoft 365 licenses for 30 days at no cost to businesses with a minimum of 300 Office 365/Microsoft 365 E3 or E5 licenses. The offer aims to demonstrate the benefits of Copilot and pave the way for broader organizational investment in AI adoption. To qualify, businesses must have a cybersecurity and data governance strategy, a digital transformation roadmap, and a future investment budget.
Data Security with Microsoft Purview-4-Hour Assessment: Cluster Reply’s assessment will introduce organizations to Microsoft Purview, a data governance service that helps manage, protect, and maximize the value of data across Microsoft 365, Exchange Online, SharePoint Online, and Microsoft Teams. The assessment includes an overview of Purview, current state analysis, data discovery and classification, stale data identification, a demonstration, customization and integration, and a Q&A session. Benefits include enhanced data protection, improved compliance, informed decision-making, strategic planning, and more.
Dynamics 365: 14-Week Rapid Implementation for Finance: Datacom’s streamlined implementation of Microsoft Dynamics 365 ERP solution offers cost savings, streamlined processes, improved decision-making, enhanced visibility and control, scalability, and compliance and risk management. The implementation agenda includes onboarding, readiness, deployment, testing, training, and go-live support. Partner with Datacom to unlock your business’s potential.
Fiscal Printer for Microsoft Dynamics 365: Retcon enables printing fiscal documents on fiscal devices for Dynamics 365 Finance users without the commerce module. It consists of two components: Receipt handling module and fiscal service. The former defines fiscal printers and their parameters, while the latter communicates with the system and prints receipts/VAT invoices on the first free printer. It also handles non-fiscal printouts and notifies users of printer unavailability.
Microsoft SharePoint Migration: 3-Week Implementation: This service offers a turnkey solution for SMEs/SMIs looking to migrate their data from local file servers to Microsoft SharePoint services. It includes technical activities such as analysis, planning, preparation, migration, integration, and customization, as well as change management activities such as communication, training, support, and continuous improvement. This service is available only in French.
Power Apps Consultancy: 5-Day Flexible Package: Pragmatiq offers a package of consultancy hours for organizations looking to get started with Microsoft Power Apps and need expert help to build and deliver workflow automation solutions. This package allows you to purchase flexible blocks of consultancy hours that includes training, consultancy, and application development.
Power Automate Consultancy: 5-Day Flexible Package: Pragmatiq offers a package of consultancy hours for organizations looking to get started with or improve their use of Microsoft Power Automate. This package allows you to purchase flexible blocks of consultancy hours that includes training, automation of processes, and access to a team of experts.
Power BI Consultancy: Pragmatiq offers a package of consultancy hours for organizations looking to get started with or improve their use of Microsoft Power BI. This package allows you to purchase flexible blocks of consultancy hours that includes training, consultancy, and report/dashboard building services.
Power BI Realization: Build IBCS-Certified Visualization: IT-Logix with help you design customized Power BI reports based on your needs, with the help of visuals from Zebra BI and Inforiver. These tools certified by International Business Communication Standards (IBCS) offer out-of-the-box interactive technology so you can build spectacular Power BI reports and dashboards in just a few clicks. No training, programming, or formulas required.
Readiness Workshop for Copilot for Microsoft 365: This workshop from Lizard Soft is ideal for IT managers and business decision makers and provides an introduction to Copilot for Microsoft 365 licensing requirements, technical assessment, and adoption strategies. Attendees will learn about Copilot’s advantages, a roadmap for activation, data security measures, implementation journey, and next steps.
Secure Identity Workshop with Microsoft 365: Identity and access lifecycles must be automated to maintain up-to-date roles and permissions, and to apply organizational changes. Available in German, this workshop demonstrates how to prevent future data breaches with Microsoft 365 by identifying existing risks, gaining insights into your application landscape, and improving identity management and security.
Trello to Planner Migration: This service, available in German, will migrate your existing Trello boards to Microsoft Planner while taking into account metadata like assigned people, checklists, attachments, and labels. This is ideal if you already use Microsoft 365, Planner Plan 1, or Project Plan 3. Data from Azure Active Directory can be used to grant access to users once migration is complete.
Contact our partners
Annalise Enterprise Radiology AI Solutions
Apps and Automation Design Sprint Services: 5-Day Briefing
Asset Compliance Health Check: 60-Day Assessment
Billing Schedule for Dynamics 365 Business Central
Dynamics 365 Business Central Discovery: 1-Hour Call
Cloud Device Management: 4-Hour Briefing
Connected Scatter Plot Chart for Power BI
Copilot for Microsoft 365 Advantage Readiness by TELUS
Cotafer Spell Checker for Khmer Language
DDA – Data Archiver for Dataverse
DeepL for Microsoft PowerPoint
Devart Connector: Connect Microsoft Excel to Salesforce
Dynamics Navision (Nav) to Dynamics 365 Business Central Migration: 1-Week Assessment
eVri/Orlox Security Audit for Microsoft 365: 3-Day Assessment
Geoson Sport Tracker with Microsoft Power App
ingo365 for Microsoft Dynamics 365 Business Central: 2-Hour Online Demo
KAMI Workforce: SaaS HR Management System
MetaPro for Professional Services
MetaShip – Integrated Business Central Packing & Shipping
Microsoft 365 Copilot Adoption: 2- to 3-Week Assessment
Microsoft 365 Copilot Readiness for Financial Services: 4-Week Assessment
Microsoft 365 Copilot Readiness for Healthcare: 4-Week Assessment
Modern Endpoint Management with Intune for Surface Devices: 2-Hour Briefing
Monta Integration for Microsoft Dynamics 365 Business Central
OptiX – AI-Powered FinOps Platform
Pandai Teacher: AI-Powered Teaching Assistant
Microsoft Power BI: 1-Hour Discovery Call
Microsoft Power BI Starter Package
miniOrange’s Privileged Access Management Solution
QMSpot Quality and Hygiene Management
SumUp Connector for Microsoft Dynamics 365 Business Central
Tipalti Global Finance Automation
Trust.AI (Vision AI) for Airports
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Practical Graph: Find Ownerless and Memberless Groups with Graph APIs
Over time, it’s likely that some of the groups in a Microsoft 365 tenant will fall into either the category of memberless groups or ownerless groups. Microsoft has a solution to manage ownerless Microsoft 365 groups, but not the other group types supports by the Graph. This article explains how to find and report memberless groups using the Get-MgGroup cmdlet.
https://practical365.com/memberless-groups-graph-api/
Over time, it’s likely that some of the groups in a Microsoft 365 tenant will fall into either the category of memberless groups or ownerless groups. Microsoft has a solution to manage ownerless Microsoft 365 groups, but not the other group types supports by the Graph. This article explains how to find and report memberless groups using the Get-MgGroup cmdlet.
https://practical365.com/memberless-groups-graph-api/ Read More
SharePoint List changing percentage value after input
Hi,
We have a SP List incorporated on out SP site to collect data.
Two of the column are formatted as Number columns with “Show as percentage” checked.
For the past two months, input was as expected.
When we enter value: 74, in the Form; 74% is displayed in the list.
As of June 08, 2024 the behavior of the column in the List has changed.
Now, if we enter the same value of: 74, in the Form, it displays as: 0,74%. (or just 0,5% depending on how may decimal places we use)
When we troubleshoot, no explanation can be found for this error.
Also, historical data from previous months is unchanged and still shows a whole number in percent.
We have also tried to add a new Number column, showing as percentage, and the error still prevails.
Footnote: After submitting the Form, for a second only, 74% is shown before it changes to 0,74% in the List. view.
I should mention that the list is used in a PowerBI report.
Have there been any changes to SP List or could the PowerBI formatting override the List column formatting?
Hi, We have a SP List incorporated on out SP site to collect data. Two of the column are formatted as Number columns with “Show as percentage” checked. For the past two months, input was as expected.When we enter value: 74, in the Form; 74% is displayed in the list.As of June 08, 2024 the behavior of the column in the List has changed. Now, if we enter the same value of: 74, in the Form, it displays as: 0,74%. (or just 0,5% depending on how may decimal places we use) When we troubleshoot, no explanation can be found for this error. Also, historical data from previous months is unchanged and still shows a whole number in percent. We have also tried to add a new Number column, showing as percentage, and the error still prevails. Footnote: After submitting the Form, for a second only, 74% is shown before it changes to 0,74% in the List. view. I should mention that the list is used in a PowerBI report. Have there been any changes to SP List or could the PowerBI formatting override the List column formatting? Read More
Problem with “IF” function
Hello,
I would like to calculate the income tax for Greece, which from zero euros to €12,000 has a rate of 15%, from €12,001 to €35,000 has a rate of 35% and from €35,001 and above has a rate of 45%.
Example :
– for an amount of €14,700 the income tax is €2,745
– for an amount of 37,000 the income tax is €10,750
I wrote the function:
=IF(A1<=12000, A1*0.15, IF(A1<=35000, 12000*0.15 + (A1-12000)*0.35, 12000*0.15 + 23000*0.35 + (A1-35000)*0.45))
but it gives me an error.
Can you help me?
Hello,I would like to calculate the income tax for Greece, which from zero euros to €12,000 has a rate of 15%, from €12,001 to €35,000 has a rate of 35% and from €35,001 and above has a rate of 45%.Example :- for an amount of €14,700 the income tax is €2,745- for an amount of 37,000 the income tax is €10,750 I wrote the function:=IF(A1<=12000, A1*0.15, IF(A1<=35000, 12000*0.15 + (A1-12000)*0.35, 12000*0.15 + 23000*0.35 + (A1-35000)*0.45)) but it gives me an error. Can you help me? Read More
Copy Data from First Colum from Active Cell Row
Hi, I am just wondering if someone could please assist me in getting a script working for me as I’ve got a script to insert a new line/row to where the selected cell is and insert shift direction down.
I’m having issues trying to work out how to copy the first column cell example A5 in the screenshot that I have highlighted in green to be copied to the new line/row that is the white empty cell (5) above the highlighted.
Your help will be much appreciated.
My script.
function main(workbook: ExcelScript.Workbook) {
let selectedCell = workbook.getActiveCell();
let selectedSheet = workbook.getActiveWorksheet();
// Inverts a row above the selected cell, or where the curser is.
selectedCell.getEntireRow().insert(ExcelScript.InsertShiftDirection.down);
}
Hi, I am just wondering if someone could please assist me in getting a script working for me as I’ve got a script to insert a new line/row to where the selected cell is and insert shift direction down.I’m having issues trying to work out how to copy the first column cell example A5 in the screenshot that I have highlighted in green to be copied to the new line/row that is the white empty cell (5) above the highlighted.Your help will be much appreciated. My script. function main(workbook: ExcelScript.Workbook) {
let selectedCell = workbook.getActiveCell();
let selectedSheet = workbook.getActiveWorksheet();
// Inverts a row above the selected cell, or where the curser is.
selectedCell.getEntireRow().insert(ExcelScript.InsertShiftDirection.down);
} Read More
Debug macro for importing and graphing currency prices
Hi All,
I am looking to import prices into excel via a userform and then graph the historical prices. I am found some useful code and hints and on the net, however I am still experiencing run errors when run the macro.
Any assistance in how to debug the process would be greatly appreciated.
kind regards,
Callum
Hi All, I am looking to import prices into excel via a userform and then graph the historical prices. I am found some useful code and hints and on the net, however I am still experiencing run errors when run the macro. Any assistance in how to debug the process would be greatly appreciated. kind regards, Callum Read More
Broken MS Teams media preview for my personal account
Hello,
For the past few weeks I’ve had problems loading media in my personal Teams. Other users in our Personal Teams community (of which I am the “owner” user) do not experience it.
The problem strangely happens both on Desktop and on mobile (Android).
This first happened about 1 week ago. At that point, I reached out to MS support who told me that the issue had just been patched on desktop applications and was about to be patched for Android. Moments later, when I checked my Android app, images and video were suddenly loading as expected. I find it strange that this should be related to a “patch” as there were no software update indications visible on any of my devices (Android and Windows). It seems more like a server issue related to my account.
Worse still, the issue has now started occurring again. My family are able to share and view pictures on their devices, but I cannot view them on my laptop or on my Android phone. What could be the issue?
Hello, For the past few weeks I’ve had problems loading media in my personal Teams. Other users in our Personal Teams community (of which I am the “owner” user) do not experience it. The problem strangely happens both on Desktop and on mobile (Android). This first happened about 1 week ago. At that point, I reached out to MS support who told me that the issue had just been patched on desktop applications and was about to be patched for Android. Moments later, when I checked my Android app, images and video were suddenly loading as expected. I find it strange that this should be related to a “patch” as there were no software update indications visible on any of my devices (Android and Windows). It seems more like a server issue related to my account. Worse still, the issue has now started occurring again. My family are able to share and view pictures on their devices, but I cannot view them on my laptop or on my Android phone. What could be the issue? Read More
Purview Insider Risk Management – Site Classification
Hi All,
We use Purview IRM to monitor for data risks. Its tuned and working very well for us. I have a question around the way one of the triggers classifies the activity. I’m sure its easy to change I just cant figure it out so any help appreciated.
We trigger a number of Cumulative exfiltration activity events, with the main trigger being xxx events: Files copied to personal cloud storage: when we look at the activity explorer event we can see that its files being uploaded to either Corporate OneDrive or SharePoint.
My question is I cant find where I can re-classify our SharePoint portals as Corporate and not personal, essentially I don’t care that people are uploading to our corporate portals. Its the D/Ling that’s important.
Its driving me nuts trying to find it! Please help
Hi All, We use Purview IRM to monitor for data risks. Its tuned and working very well for us. I have a question around the way one of the triggers classifies the activity. I’m sure its easy to change I just cant figure it out so any help appreciated. We trigger a number of Cumulative exfiltration activity events, with the main trigger being xxx events: Files copied to personal cloud storage: when we look at the activity explorer event we can see that its files being uploaded to either Corporate OneDrive or SharePoint. My question is I cant find where I can re-classify our SharePoint portals as Corporate and not personal, essentially I don’t care that people are uploading to our corporate portals. Its the D/Ling that’s important. Its driving me nuts trying to find it! Please help Read More
Question on pnp search in sharepoint
Hi Guys,
I need some advice with an issue I am facing when setting up PNP Search.
I have a SharePoint Document library that has :
-Default columns such as TITLE, Modified etc.
-A New “choice” column I created named “Document type”
The purpose behind creating above new column is to automatically be populated with values (Internal or External) Depending on whether the document is dropped into the “internal” or “External” folder in this library. So I have configured this default value setting in the library. So this metadata column is auto tagged with either of these values based on where document is put.
I have then configured a site page (in this site) which is basically a document hub. The purpose of this page is to have pnp search results, pnp search box and pnp search filter webparts.
I am trying to get the “document type” column to show up in the pnp search results webpart (and also the filter webpart). But I am unable to get it to show up. It only shows the default columns available in that library. I tried to edit this webpart and add the column but unable to get it to show.
Any help would be appreciated.
Hi Guys,I need some advice with an issue I am facing when setting up PNP Search. I have a SharePoint Document library that has :-Default columns such as TITLE, Modified etc.-A New “choice” column I created named “Document type”The purpose behind creating above new column is to automatically be populated with values (Internal or External) Depending on whether the document is dropped into the “internal” or “External” folder in this library. So I have configured this default value setting in the library. So this metadata column is auto tagged with either of these values based on where document is put.I have then configured a site page (in this site) which is basically a document hub. The purpose of this page is to have pnp search results, pnp search box and pnp search filter webparts. I am trying to get the “document type” column to show up in the pnp search results webpart (and also the filter webpart). But I am unable to get it to show up. It only shows the default columns available in that library. I tried to edit this webpart and add the column but unable to get it to show. Any help would be appreciated. Read More
What To Do When Getting Quick-Books Error 404 after update?
I’m encountering Quick-Books Error 404 while using my accounting software. It appears as “Quick-Books has encountered a problem and needs to close” or “Page not found.” Can you provide troubleshooting steps to resolve this issue?
I’m encountering Quick-Books Error 404 while using my accounting software. It appears as “Quick-Books has encountered a problem and needs to close” or “Page not found.” Can you provide troubleshooting steps to resolve this issue? Read More