Category: Microsoft 365 PnP | Microsoft Community Hub

Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Recent Discussions

How to get who created M365 Group using PowerShell?
How do we find who created M365 group using PowerShell? Graph API?
Solved
Bhashwar1450
Copper Contributor
Aug 05, 2022 Place Microsoft 365 PnP
3.6KViews
0likes
2Comments
Sharepoint list format whole row using indexOf
Hoping this will be a simple question for someone who knows JSON. I'm new to JSON and have found two examples of conditional formatting I'm trying unpick to colour a whole row on a sharepoint list using indexOf to search for the string "Holiday". Our training calendar (sharepoint list) can include "School holidays", "Bank holidays", "Half term holidays" etc in the field 'Title'. Changing the column colour works for the title field alone with the following indexOf example (using if) { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "attributes": { "class": "=if(indexOf(@currentField,'oliday') != -1, 'sp-css-backgroundColor-BgCornflowerBlue sp-field-fontSizeSmall sp-css-color-CornflowerBlueFont','')" } } And, changing the whole row background colour works with the following which does not use indexOf (using operators?) { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "additionalRowClass": { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Training_x0020_Crs_x0020_Ttl]", "Holiday" ] }, "sp-css-backgroundColor-BgCornflowerBlue sp-field-fontSizeSmall sp-css-color-CornflowerBlueFont", "" ] } } To me the logic in both examples looks to be achieved in slightly different ways and I've hit a wall trying to combine the code, does anyone know how to use indexOf condition to detect 'holiday' to conditionally format the whole row? (In the code above it looks like sharepoint has kept 'Training Crs Ttl' as a reference to the field now renamed to Title but I don't think this has a bearing on the code) Many thanks Chris
Solved
Chris_Boylan
Copper Contributor
Dec 31, 2021 Place Microsoft 365 PnP
sharepoint
5.6KViews
0likes
3Comments
Help with an Excel Formula/Command Please
Good Afternoon, I need help with a formula which I am trying to put into an Excel Spreadsheet please. I'm not sure how to do what I want to do. Please See The Diagram Below. I am wanting to put a formula into cell E3 so that the 'correct' currency name & symbol will display in this cell (E3) when a particular currency is selected from the yellow box. The formula would need to be something like "(if I4 = 1 then E3 equals H3) or (if I4 = 2 then E3 equals H4) or (if I4 = 3 then E3 equals H5) or (if I4 = 4 then E3 equals H6). That way the (spreadsheet) user can select their preferred currency, by simply putting the appropriate number in cell I4 (light yellow colored) and then the corresponding symbol/currency type will post over to E3 in the 'Currency Convertor" (from column H). I hope someone can help. Many thanks, Andrew.
Solved
Andrew58
Copper Contributor
Dec 06, 2021 Place Microsoft 365 PnP
2.5KViews
0likes
8Comments
Help deleting 'folder' in SPO?
We've gotten a into a strange situation with a modern SharePoint Online site and could use some help/ideas on how to get out of it: A file was deployed with the Feature framework style of deployment to a path of /SiteAssets/myfile.ext. However, this happened prior to the Site Assets library actually being created by the 'just-in-time' model used on modern sites. As a result, the site now has a root 'folder' named SiteAssets and it is blocking the JIT creation of Site Assets library. When I say 'folder' think web/IIS folder, NOT a SharePoint folder in a library. How would one delete this kind of 'folder' such that the Site Assets library can actually be created? I've tried various forms of SPO/PnP PowerShell and none of the cmdlets seem to work with this kind of 'folder' 😞 Any help/ideas would be MUCH appreciated...
Solved
Jim Duncan
Brass Contributor
Aug 31, 2021 Place Microsoft 365 PnP
1.4KViews
0likes
4Comments
Sharepoint List
Hi everyone. So here I have a starting tenant with a starting Sharepoint list. Now I want to integrate it into an arrival tenant with an arrival Sharepoint list. How to do this using powershell?
Solved
Numberone1
Copper Contributor
Aug 16, 2021 Place Microsoft 365 PnP
1.4KViews
0likes
4Comments
Phone Call Link in SharePoint View/Column Formatting
Does anyone know of a way (or a workaround) to get tel:123-456-7890 links working in view/column formatting? This would be very helpful for showing contact links with "click to call" on mobile. It already works for "mailto" links, but "tel" links are not working.
Solved
Mike Hatheway
Brass Contributor
Feb 09, 2021 Place Microsoft 365 PnP
2KViews
0likes
3Comments

Events

Recent Blogs

Resources

Share

Tags

No tags to show