User Profile
OrangeJuiceJones
Copper Contributor
Joined Dec 07, 2020
User Widgets
Recent Discussions
Excel white space characters are incorrect
Hi, I have a column with a serial number which contains a white space. I am unable to search for some of the numbers, even though I can see them. It turns out that the white space have different codes. The normal code is 65 but some are 160, 78, and 80. The format is ABC 17/20 I can find and replace them but is there an easier way to do this - ideally I would want to find any spaces in entire sheet and replace them with the correct space (ALT 65 I think). Perhaps a script ? ThanksSharePoint Content Types (from Hub) and MS changes
I'm provisioning a site through a flow, which in turn executes a Site Design (site script) that creates a library and adds several Content Types from a CT hub. After creating the site I have to wait a few hours before I can attempt to run the site script to add the Content types. The reason for the wait is I think after creating a site, time is required to sycronise the hub to the new site. This was all working but a few days ago it stopped. A few articles say that there will be a change from a pull to a push model. https://support.microsoft.com/en-us/office/what-s-changed-in-content-type-publishing-609399c7-5c42-4e25-aff0-b59d4aa1867f In the link above there is a new verb - 'addContentTypesFromHub' but no examples. I tried adding it to the sitescript but it errors. The code below adds the CT to the site and then assigns it to a new library: { "$schema": "https://developer.microsoft.com/json-schemas/sp/site-design-script-actions.schema.json", "actions": [ { "verb": "createContentType", "name": "myCT name", "id": "0x010100FDBFA5F33B995B42BCF9E8B473960893", "description": "", "parentId": "0x0101", "hidden": false, "group": "myGroup", "subactions": [] }, { "verb": "createSPList", "listName": "doc2", "templateType": 101, "subactions": [ { "verb": "addContentType", "name": "myCT name", "id": "0x010100FDBFA5F33B995B42BCF9E8B473960893" } ] } ], "bindata": {}, "version": 1 } Any ideas on the new MS changes and way forward? Screenshot of error:Change SharePoint Online Locale for Site Collection
I'm trying to adjust the Regional Settings of a SharePoint Site Collection. When a site is created it defaults to 1033 and I found its not possible to provision as 2057. I want to use REST as I can use PowerAutomate and found the api below. https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj246672(v=office.15) However, I dont know how to set it to 2057 and its not explained in the documentation. There is a similiar question here, but its using PowerShell, which I cannot use - https://sharepoint.stackexchange.com/questions/88651/change-default-locale-settings-for-site-collection-in-sharepoint-online Here is what I have so far:PowerBi get data from multiple site collections
Hi, There is a requirement to produce a PowerBi report / dashboard but rather than getting information from a single site, their is a need to gather information from multiple site collections. The other requirement is that these site collections can grow and the url's of the site are unknown until the site is created (all sites to be reported on will have the same pre-fixed characters though) The sites will contain the same list and columns. Ideally, PowerBi should be able to slice and dice the data from various sites. Is this possible?Provision SharePoint Online site with an approval workflow
Hi, I have a requirement in that whenever an item is added to a pre-existing SharePoint list, a number of things need to occur. 1. A site needs to be created with some customisation 2. One library in the site requires a multi-stage approval workflow. This will need to be a repeatable process. It is possible for a Power Automate wf to trigger when an item is created in the list, which can create a site. The wf can also trigger Azure Automation which can add the customisation. (PowerShell) How is it possible to create an approval workflow that is reusable and how can be linked to the sites Library. There may be 200+ sites that get created over time, so it will not be possible to create 200+ workflows manually, it needs to be a single workflow then can be re-used. I was thinking of LogicApps, does this have the capability ?MS Project Professional / Online Sync with Planner
Hi, The current workflow is that we use MS Project Proffessional (Desktop) to create /edit tasks and this is sycronised with a SharePoint Task list. We want to move to modern pages / sites and because Task list and the Task webpart is classic its an issues. I'm investigating how Planner can be used instead but I cannot find a way to syncronise MS Project Professional or MS Project Online tasks to Planner. I spent many hour on this and found mention of only 3rd party tools that allows this (I havent tested this for suitability/cost). Though in Project there is a 'Link to Planner' button, it only serves as a hyperlink and links the Project to a specific plan. (no tasks syctonised). Is it possible to sycronise Project tasks with Planner?SharePoint online Column Formatting
Hi I have a sharePoint multiline column (rich text enabled) in a library and using flow I have added data as: <div>item1</div><div>item2</div>.. When I view the library I can see the items arranged vertically (as I want) but the view gets truncated after the 4th item, otherwise the row height would get too large. Is it possible, on hover over that all the items in the column field can be shown- maybe in a custom card or something else. I've added divs around every item but havent added a container div as this gets difficult to implement through flow, especially when I need to update and maintain previous data. I've looked at MS docs but there is no example where an outer div is not used. - https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#get-started-with-column-formattingConnect PowerApp to SharePoint List / Library dynamically
Hi, When adding a PowerApp webpart to SharePoint Online, is it possible for it to connect to a list / library. I want to create several sites with the same lists/libraries and then want to add PowerApp on a SharePoint page but require it to connect to that sites lists / libraries. What I don’t want is where I need to create/modify a PowerApp for every site - needs to be reusable 🙂 A nice to have would be the ability to create a sites using powershell/site script and add the PowerApp as part of the process too - am I asking too much? ThanksRe-using PowerApps
Hi The requirement was (and still is) to create a dashboard for a department allowing them to save documents and create list items, all with validation and other artefacts - Once done, the entire solution to be templated so it can be cloned for other departments. It was thought the cloning can occur through PowerAutomate / PowerShell. To solve the above, a site has been created and customisation added by creating a canvas PowerApp with several SharePoint data sources. These data sources are hooked up to several libraries and lists in a single MS Teams SharePoint site. How is it possible to template this solution ? - As several sites require to be created, does this also mean I need to create one app per site also or when an app is created, can it be re-used ? My concern is that the app is now tied into the site and because it is tied into a site, I will need to create an app for every site and I would end up with a lot of maintenance. Any ideas welcome. Thanks
