User Profile
kevingeorget
Brass Contributor
Joined Jan 18, 2019
User Widgets
Recent Discussions
Azure function app- Powershell runtime stack
Hello community, Can anyone please help me with the query i have. I have a Azure Powershell function app set up in my environment. i have 2 timer triggered functions say F1 and F2 running at 5 mins interval. They both are connecting to 2 different SharePoint sites with the same tenant using Connect-PnPOnline with Client Id and Certificates. Issue is that both of them are conflicting the run of the other function when running. Errors i get- Save conflict. Your changes conflict with those made concurrently by another user. OR List 'X' is not present in the site F2 My understanding is the function even though are in the same App can run independently of each other as separate instances. Is there a way other than updating the apps to run at 2 different times to fix this issue?1.3KViews0likes1CommentgetTeamsUserActivityUserDetail Graph API call in SPFx
Hello SharePoint Users, I'm developing an SPFx webpart to pull the MS Teams user activity details. I have given the solution the Reports.Read.All permission in the package and in the Azure portal (API permissions), granted the API access in the SharePoint admin portal as well. But i still get the 403 forbidden error- GET https://graph.microsoft.com/beta/reports/getTeamsUserActivityUserDetail(period='D7')?$format=application/json&$select=userPrincipalName 403 (Forbidden) Here is the code segment that i use (pasting only the relevant part). I'm using same approach for getting the current users Team names and members displayed. Those methods work fine. Any help appreciated. Thanks. Kevin this.props.context.msGraphClientFactory .getClient() .then((client:MSGraphClient😞void=>{ client .api(`/reports/getTeamsUserActivityUserDetail(period='D7')?$format=application/json`) .version('beta') .select("userPrincipalName") .get((err,res)=>{ if(err){ console.log("Error logs "+ err); return; }1.2KViews0likes0CommentsRe: JSON formatting a list view in SharePoint
After some research, I've found a solution. We can user the toLocaleDateString() to extract just the date. so my expression would be- { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(toLocaleDateString[$DueDate]<toLocaleDateString(@now), '#ff0000',if(toLocaleDateString[$DueDate]==toLocaleDateString(@now),'#ffcb0d',''))" } }1.9KViews0likes0CommentsJSON formatting a list view in SharePoint
Hi SharePoint Users, I need to format a Status column (Single line of text field) based on a Date- Time column for a SP List view. The logic- 1. If [DueDate]<Today, then color is Bright Red 2. If [DueDate]=Today, then color is Light red 3. IF [DueDate]>Today, then color is black I tried the simple logic as below, but since both @currentfield and @now takes the date-time value, i'm not getting the desired results. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if([$DueDate] <@now '#ff0000',if([$DueDate] ==@now,'#e89b9b',''))" } } Please help.Solved1.9KViews0likes1CommentConnections in webpart to filter values in a library webpart
Hi SharePoint Users, I've a Task list and a library web part in a page. The task list has a field DocId which is populated with the ID of Library. A flow creates task in the Task list and links the DocId with the value from the library. I'm trying to use the connection feature for the task list webpart to filter the library document. This doesn't filter the results in the library web part. The DocId is a number field. If the issue is with incompatible field types, is their a workaround for this. Can anyone help me here. Attached the screenshots which can help in understanding the requirement. T hanks, KevinSolved675Views0likes1CommentMS-100 study guides/ materials
Hi All, Can any one guide me to any online study materials available for MS-100 https://www.microsoft.com/en-us/learning/exam-ms-100.aspx. I've searched entire Microsoft portal and unable to find one. Since they have moved away from the 70-346 exams around 6 months back, I'm pretty sure they have some kind of materials made available by now. Many thanks. Regards, KevinSolved16KViews1like7CommentsTo make site inaccessible for normal users and accessible for SP Admins SPO
Hi SharePoint Users, I've currently have a live site collection with more than 100 users in it. Due to legal compliance, i need to lock down the site for a temporary period for all the normal users. The site should be accessible only administrators during this period. One way would be to remove all the users from different groups and add them back again later ( which would be a tedious task). Another one would be using below PS code- Set-SPOSite -Identity "" -LockState NoAccess But this blocks out access for everyone including administrators. Any other smart way of doing this through UI or PowerShell? Many thanks, KevinSolved2.1KViews0likes2CommentsRe: Left pane for Team sites in SharePoint Online
Norman Young Well, this is what even i checked first. From the page source of the landing page of both the sites, I could see the template STS#0 mentioned. "webTemplateConfiguration":"STS#0" So, both are Team sites. Regards, Kevin1.6KViews0likes1CommentLeft pane for Team sites in SharePoint Online
Hello SharePoint Users, This might be a silly question. I have 2 team sites, in one i can see the left pane appearing and in the other it's not present. Any idea how i can enable and disable the left pane. Attached the screenshot. Regards, KevinSolved1.7KViews0likes5CommentsTo get the Parent site list in the sub site using PowerShell SharePoint Online
Hi SharePoint Users, Here is my requirement and appreciate if anyone could help me out. I have a site collection with multiple sub sites present. I need to populate a list (Application list) in the parent site with all the list names and list owners (all the list have unique permissions) from parent as well as sub sites. I'm able to fetch the list details in the parent site. And also able to traverse the sub sites and lists. But i'm unable to access the Application list when traversing through the sub sites. Could anyone tell me how i could access the parent site list when traversing through the sub site lists. Regards, Kevin1.1KViews0likes0CommentsRe: JSON Conditional formatting for list view colum
RobElliottThanks a lot for the reply. But my issue is only with the migrated documents. The one created newly have the dropdowns populated correctly. There are around 500 items in the list. I would prefer the JSON method as it would update the values at one go for all the items.1.6KViews0likes0CommentsRouting access level request to different list owners
Hi SharePoint Users, I have a site with 5 (say) different list having unique permissions. Each list is configured with a Owner and Members SP permission groups. When a new user access the URL of any of the list, he is denied access and he could in turn request access. This request goes to the site owners group by default. Is it possible to route the request to respective List Owners SP group. I've tried options with Flow, but Flow currently don't have the capability to fetch the List owners. I would ideally want to configure all the access request to a shared mailbox and based on the request URL, forward the request to different List owners group. Haven't tried options with Powershell yet. Any suggestions/help appreciated. Regards, Kevin2.8KViews0likes4CommentsRe: The minimum permission level that we can create that allows us to manage Site permissions
Norman Young Cheers. Alan Marshall Thanks for replying. So here is my scenario. I have site SiteA which has a list ListA. ListA has unique permissions (breaking the inheritance from the site). I want a ListA owner group that can manage the permissions of only this list and don't have the ability to see the PowerApps button or any other ability to modify the list. If I create a Permission level with 'Manage Permissions...' checked and leave 'Manage List...' unchecked. The Owner group users won't have the access to go to List settings page (to navigate to Permissions for this list) or click on the 'Share' link appearing on the List view. The only option i have is to give both the above permission level to the Owner group. Let me know if there is a workaround still. Thanks, Kevin3.4KViews0likes0CommentsThe minimum permission level that we can create that allows us to manage Site permissions
Hi SharePoint Users, I need to create a custom permission level that allows a user to manage permissions to the site (add/remove users) but not give him access to customize a list form and such design capabilities. The 'Full Control' permission level will allow the user to customize forms and pages. Any suggestion appreciated. Regards, Kevin3.6KViews0likes3CommentsJSON Conditional formatting for list view colum
Hi SharePoint Users, I've recently migrated some contents from a legacy system to SharePoint list. There is a drop down 'WareHouse' having the 7 different text values. But in the legacy system these were mapped to numbers. And the migrated documents show number in the list view. Using PowerApps, i have modified the drop down to map the numbers to the correct text values in the Forms. Attached screenshot for further details. Is their a way using JSON formatting to map the numbers to a text value in the list view. E.g. if(@currentField == '1','DropdownText value 1')1.7KViews0likes2Comments
Recent Blog Articles
No content to show