Error connecting Sharepoint (excel) file to PowerBI desktop file
Hi, on Friday I connected this excel file in Sharepoint to a PowerBI desktop report I am developing. No errors. Today, Monday, as soon as I opened the PBI desktop file, I got the error (1st screenshot attached) which I didn't have on Friday and nothing has changed regarding file connections. Then, as a test, I opened a new blank Power BI desktop file, and tried to connect all over to the sharepoint file to see if I got the same error. And I sort of did - see 2nd screenshot attached. But what I don't understand is why there would be this error now when it wasn't an issue the last time I opened this file on Friday and nothing has changed in terms of connection. Thanks.
Enable Print but Restrict Download for PDFs in SharePoint Online
Hi All, We have a group of users who have view only or restricted view permissions on SharePoint online , we wanted these users to be able to print the PDFs but not download or bulk download them, is this possible. I have tried Information Right Management, Didn't work for me as I expected.Building a SharePoint Engagement Metrics report / dashboard
I'm looking into building a SharePoint Engagement Metrics report. I understand that SharePoint provides some basic analytics but this view does not offer user granularity. https://contoso.sharepoint.com/sites/my-sharepoint-site/_layouts/15/siteanalytics.aspx?view=19 I'm looking into using the Office 365 Unified Audit Logs, specifically the 'ViewedPage' SharePoint activity. Is this the right approach for this? Is there a better option, if so what are those options? Please advise.
Error connecting sharepoint custom list with PowerBi "We couldn't parse OData response result"
We have a custom list inside our sharepoint on-premises 2013, and using the Power BI desktop app i want to connect with the sharepoint custom list. so i did the following steps:- 1) Inside power BI >> click on "Get Data" >> "SharePoint List" 2. i entered the site url >> select the intended custom list >> but i got this error:- DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'QuickOrder', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values. Details: DataSourceKind=SharePoint DataSourcePath=http://****/****/_api/Web/Lists(guid'80ca0b70-24c5-4d06-b4f4-03de6c7b733f')/Items where the "QuickOrder" is a custom site column of this type so not sure why Power BI raised this error on this column specifically? is there a way to fix this error? or to exclude this column for the integration?Getting Started with React and SharePoint - From a UX Designer/Developer's Perspective
If you've been keeping watch on the new SharePoint Framework you have undoubtedly read or experienced the dichotomy of extremely basic "Hello World" articles and if not basic, then articles written by hard core-code-ninja programmers. If you’re a Designer, Developer or UX Practitioner trying to make sense of the React and Modern SharePoint Framework universe it can be difficult reconciling these two very different spectra. From a UX Practitioner's standpoint we need to know enough about Development to strategically understand what's possible in Design, while attempting to make a User’s experience better. That middle ground of development and design when focused inside of SharePoint helps to build exciting experiences and promote healthy User Adoption. The goal of this 5-part series is targeted at the hybrid role of Designer, Developer and UX Practitioner in an attempt to navigate through some of the poorly documented and major hurdles of React Development. Part 1 – CSS tricks and working with syntax Part 2 – Integration of third party or legacy plug-ins Part 3 – Images, SVG graphics and Components Part 4 – REST call to a SharePoint List and displaying the results Part 5 – Building a super cool React Modern SharePoint Web Part React SharePoint Modern Framework Web Part – we will be building this in Part 5 of this series. Alright, enough talk let’s get started. Part 1 CSS in React Ok so if you’re like me and have been using traditional CSS for almost 20 years, CSS inside React at first... is a little painful. There is an in-depth blog post written by Agata Krzywda about CSS and React https://codeburst.io/4-four-ways-to-style-react-components-ac6f323da822 detailing almost every situation and use case. The article mentioned by Agata is very helpful for understanding CSS and React, but what the article doesn’t take into account are the real-world syntactical oddities that we run into on a daily basis, which like I’ve mentioned are generally missing from 80% of online React documentation. The SPFX team at Microsoft has done a great job by giving us the SPFX boiler plate webpart that generates the code below. Deciphering the CSS in the SPFX boiler plate has a pretty steep learning curve partially because the boiler plate project hides some key ingredients that if you are not outwardly looking for them, you'll miss out on the learning experience. Example the Office Fabric .css file is buried in the node_modules folder and is not referenced through import in the head of the page... so if you were trying to understand where "ms-bgColor-themeDark" is being referenced its completely confusing... Let's take a look at Lines 11, 14. Line 11: <div className={`ms-Grid-row ms-bgColor-themeDark ms-fontColor-white ${styles.row}`}> Line 14: <div className={"ms-font-1 ms-fontColor-white"}> These two lines show different ways to use CSS in React that mimic 90% of the web at large. Now Let's look at Line 16. Notice there's some different stuff going on here... "styles" is the imported reference to the scss file and "label" is the class name. Line16: <div className={styles.label}> * The big take away here is that CSS in React has multiple ways to use it, and you can choose which works best for you depending on your situation. Below are some extremely useful and hard to find syntactical variations of CSS in React, that go beyond the CSS article written by Agata and that also extend the SPFX boiler plate example from Microsoft. Here are a few super helpful examples of className syntactical combinations Multiple class names with hyphens concatenated together while still referencing the import iconstyles module. className={[iconstyles["glyphicon"], iconstyles["glyphicon-star-empty"]].join(' ')} Entire string of static classes in a string with a variable name inside the string <div className={`ms-Grid-row ms-bgColor-themeDark ms-fontColor-white ${styles.row}`}> Multiple static classes along with a variable name concatenated together className={[`mix`, `all`, item.Category ].join(' ')} Class name as a static string. Notice the use of this ( ` ) not ( ‘ ) or ( “ ) className={`mix`} Class used classically in a variable as larger static string const htmlstring = ` <div class="row mixitup-wrapper"></div>`; This table hopefully saves a fellow Designer, Developer or UX Practitioner some time and effort, I know while I was picking up React each variation of CSS was a watershed moment. In Part 2 of this series we are going to hammer out how to work with third party plug-ins inside React like JQuery, Bootstrap and MixitUp.The development spectrum of Microsoft 365 and Power Platform
It's a balance of knowing what skills to use, and when - blended with thoughtful 'build versus buy' decision making criteria. This webinar looks left-to-right across the full spectrum of options within Microsoft 365 and Power Platform - from no-code to low-code, to pro-code. Each presenter will represent one area on the spectrum. Chris Kent will put SharePoint and Lists into action and demonstrate a common no-code scenario. April Dunnam will then showcase what you can do with Power Apps and Power Automate to design a clear example of low code. And last, Vesa Juvonen take us into Visual Studio leveraging SharePoint Framework and guidance on when, and how, to extend Microsoft 365 using pro-code patterns and practices (PnP). Your host, Mark Kashman, will kick things off and interview each presenter between each segment to help discover what you need to ask yourself when assessing your next spectrum of development opportunity. Sharing is caring. Related resources The Microsoft 365 & Power Platform Community: https://pnp.github.io/ Power Platform learning paths: https://aka.ms/learnpowerplatform Microsoft Lists resource center: https://aka.ms/MSLists List Formatting Samples: https://aka.ms/List-Formatting Microsoft adoption hub: https://adoption.microsoft.com
Creating an addin for sharepoint that uses c#
Hi Everyone, I would like tp create an addin for Sharepoint online which uses c# code and libraries. I am following the tutorial mentioned in: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-started-creating-sharepoint-hosted-sharepoint-add-ins I have deployed the addin created from default template in Visual Studio 2019, and now I wish to include and execute a C# file for generating an access token from this framework. I am confused how to call this file from .aspx page and make it work on the sharepoint addin page. Please help.
Generate a dynamic report in SharePoint Online so that list data can be viewed easily
Hi All, We have a SharePoint Online List having data related to one project with multiple columns like Title , Owner, Description, Testing Status ( Completed , On Hold etc. ) . We want to generate a dynamic report ( graphs, charts etc, ) in SharePoint Online so that data can be viewed easily . We are not planning to develop a code as such . What are the available options ?
