User Profile
GuyCarnegie
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Get file versions into Excel
I have a SharePoint library which I am exporting into a query IQY file so Excel can maintain and make use of a local list of files in the library and their parameters / metadata. This library has to use the mandatory check-out/in process with version control. I see for some reason it's not possible to include the file version number in the IQY. I have tried using a calculated field, but that doesn't get updated when the file version is updated. I need to find a way of "looking up" the current version of files in my SharePoint library from my Excel workbook. I also really need the "release date" which should be the date of approval, but I am currently using the last modified date as a "close enough" alternative. Main issue is the version#, which is a deal breaker if not retrievable. Any help is appreciated. Guyto-do list on to-do bar
Going by my new toolbar, it looks like microsoft has now integrated ToDo into outlook. Question is how to show my ToDo items in my ToDo bar/panel next to my inbox? I currently show "tasks" but I understand this is not quite the same thing. Or does Microsoft think that the ToDo Bar / panel should not actually show ToDo items?Entering UK dates in Sharepoint List and then using DateDif in calc column
I have a column in my SP list for dates. It can only be edited by grid mode as it's not in the edit form - which is fine. I am in UK format dates (dd/MM/yyyy). Note I am using a standard SP list directly on screen - not talking about powerapps here or anything like that. To edit it, I go to grid mode, then select a date using the date picker, which saves dates in US format mm/dd/yyyy. When I try to exit grid mode, it says I have an error and dates should be in UK format. So I manually type the dates in UK format (I am in the UK so thats fine) and manage to save & exit grid mode. Now, I have a calculated column which measures the days since that date, which now shows a !value error - likely as it doesn't recognise the UK date format. Please how can I get the SP online grid-mode Date Picker to use UK dates, and get the DATEDIF function in my calculated field to pick up the correct date from that column?internet shortcuts in onedrive
I have some project folders in onedrive, and I use ms todo for day-to-day actions as these sync with my outlook tasks. I have shared the todo folders and created an internet shortcut to them saved as a shortcut file in my project onedrive folder. It works fine on my local synchronised copy of onedrive folders, but the people that NEED the link are those who just view the project folder online - without their own synchronised copy. The issue is that an internet shortcut is saved as a "url" file type in my online folders - which users are unable to follow. Clicking on it only allows them to "save as" rather than following the link.Understanding SITE vs LIBRARY/LIST vs FOLDER/FILE/ITEM permissions
I created a SharePoint site through MSTeams, for the sake of argument lets say it's called "PLANT_SITE". Within this site, I have a few libraries and lists. LIB1 > SUB1.2 > SUB1.2 LIB2 > SUB 2.1 > SUB 2.2 LST1 > ITEM 1.1 > ITEM 1.2 LST2 > ITEM 2.1 > ITEM 2.2 Within LIB1, I have multiple folders SUB1, SUB2, SUB3 for specific groups of external users. I have set permissions to contribute on specific folders SUB1 (Usergroup1); SUB2 (Usergroup2); SUB3 (Usergroup3). As far as I can tell, users can still ONLY access their allocated SUB-folder, if their permission is ALSO included at the top level (PLANT_SITE; Usergroup1, Usergroup2, Usergroup3 etc). This means I have to grant access at top level, and specifically EXCLUDE them everywhere else that inherits permission from that site. It also means that an automatic notification is sent directing them to the top level site, which I really don't want them accessing, or is it at the LIB/LST level they need access? Surely this cannot be correct, can it? I should be able to add a user to the lower level SUB, without specifying them at the site level at all, yes? Another annoying thing is when I create a NEW SUB folder, it automatically inherits all permissions (for all users) until I go in and remove the unwanted users explicitly from that folder. Can someone shed any light on this please? Is it necessary for usergroups to be specified at levels HIGHER than the specific folders/list items they need to see?User specific data in sharepoint online
I have a library of training courses in SPOnline, but I want a column to state whether the current user has completed a course or not. Obviously this changes depending on which user is viewing the data. I realise this can be done in the powerapp form, but cannot be done in the list itself- ie, a column shows "completed" or not? Edit: I think this might be possible using column json formatting, looking up the username, along with the file ID & version from another list, returning either the date or "null" (which would change the content to a "complete now" button/link which would add the data to the other list - likely via a flow. No idea how to fo the json part though. Any help appreciated.Don't create Minor Versions unless save
I created a document (excel spreadsheet) in a new library - version 1.0 I went into that document, had a look around, and then exited. I guess it must've autosaved while I was in it, because now I have a 1.1 and the item is now draft. How do I prevent that happening for my users? They need to be able to open a document and close it without generating a new version - and how do I delete 1.1 and revert to 1.0, without restoring 1.0 as 2.0, then deleting minor versions.User Acknowledge Sharepoint Document
I want to have an action for each user acknowledge each sharepoint document new major version- kind of like a "read" acknowledgement in outlook. I also need to be able to see an overview of which users have acknowledged which documents, and which they have not. I have around 50 documents (so far) and 50 users. What is the best way to set this up? Users get an alert when new document is published, where they click on a link to acknowledge?Outlook Search Criteria Missing
I read online that, to search for text in an attachment filename, I should look for "Attachment Contains" criteria in the below menu location. Unfortunately, that location holds very few options for me. Is there something wrong with my install, and where can I find "Attachment Contains" criteriaUpdate Form Choice Field using Powerapps
I'm sure this is very simple but I've been struggling for hours. Please help if you can. I am working on a SP list with custom powerapps form. One of my datacards is "status", and as I don't want users to select status directly, I want to programatically select the choice using a button, where its next value depends on its current value. I don't want to use patch, as the list is visible and I need to see the choice value update in the list when I press the button, without refreshing, just like it does for the text-based datacards/fields, so I am using the below code, though I'm at a loss as I can't seem to programatically update ANYTHING, in real time. UpdateContext({tempstatus:""}); Switch (ThisItem.Status.Value, "Draft", UpdateContext({tempstatus:"Submitted"}), "Submitted", UpdateContext({tempstatus:"In Work"}), "In Work", UpdateContext({tempstatus:"Draft"}), "Approved", UpdateContext({tempstatus:"PR Raised"}), "PR Raised", UpdateContext({tempstatus:"ECN Closed"}), "ECN Closed", UpdateContext({tempstatus:"Draft"}), "Rejected", UpdateContext({tempstatus:"Draft"}) ); UpdateContext({DataCardValue13:tempstatus}); // I have also tried UpdateContext({DataCardValue13:{value:tempstatus}}); SubmitForm(SharePointForm1) //commented out patch //Patch('Alt Component Register',First(Filter('Alt Component Register',ID = ThisItem.ID)),{Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:2,Value:tempstatus}});Re: Down the Rabbit Hole! External Sharing of SP List with powerapps Form & Email notification
So I discovered a lot about this,and i think I have a way out. 1. The "old data" was because I had versioning enabled, and users set to view only Approved items (or at least "approved item VERSIONS - which were old of course". All the recent documents were set up "pending" state, due to me doing an "update item" in the flow, after the approval. I have now set users to be able to view drafts, but also added a "Set Approval Status" Step at the end of my flow (one for reject, one for approve) 2. It is true that no matter what I do, I cannot get the O365 connector to work with a Runtime User, and I also can't get a child flow to isolate my powerapp from the O365 connector. SO I'm going to put a helper column in the database which I will set to "1" when an email needs to be sent. I'll have another flow, with a change trigger, conditional on seeing this "1". At that point, it will pull the data, send the email and reset the trigger to "0" to avoid recursion. I'm hoping that will work.Down the Rabbit Hole! External Sharing of SP List with powerapps Form & Email notification
I have a simple SP online list which uses a NEW/EDIT form customized in powerapps. It works flawlessly when I am using it myself as the author, but I needed to share it externally, so I shared with with my own personal O365 account for testing, as deployment needs to be seamless to "real" external users. When I log in on my home PC with my personal O365 "school/work" account, I see several issues: 1. The list is visible, but the data in it is old. I don't mean some data is missing - I mean the actual values for the same records are a day old, and records created earlier today are not visible at all. I can see the new data on my work laptop, and it has more lines, and newer data. 2. When I click on Title field, I get the "almost there" message, with "Office 365 Outlook" connection needing "fixed". I can't fix this whatever I do. Authentication Error - though I AM logged into Sharepoint with my O365 account. 3. The powerapp canvas / Form isn't displaying at all. When I remove the Office 365 Outlook connection from the Flow, the powerapp starts up normally in the external environment (obviously with no email functionality though). I will try a different connector to support email. Item 1 above is still the same though - the list data is still old. No different email connector available ("Mail" is not permitted apparently!) so I have just put the email address into a Compose, to see if it will pass correctly to the flow. It did pass no problem. I will take a copy of the flow and try adding the Office365 outlook Connector back in. Okay so as soon as I add the O365OL connector back in, the external powerapp falls over with an authentication error. I wonder if the connector is trying to log in using my work account - as per the connection configured in the app, but obviously unable to do so on an external machine. I need the connection to be set up for a run-only user. How to do this? This is getting silly now. I'm reading that the best way is to split the flow into a parent/child pair, so that the run-only user doesn't have to interface with the O365OL connection. Turns out that child flows are only available in Solutions. So I rewrite my flow into a solution. (First time messing with solutions) So now I just have to call the parent flow, which has no awkward connectors, from my app. Simple... Not so. My app can only access "My Flows", and doesn't see anything in a solution. Of course, I can't put my app into a solution because its linked to the Sharepoint List. This is getting pathetic! Maybe I'll see if there's a way to call a flow from another flow, while both are still in My Flows. Apparently, there's a way to do nested flows using HTTP requests - but of course... "Your flow was saved, but could not be enabled because it conflicts with the company data loss prevention policies." Can someone please point me in the right direction before I throw this laptop out the window?Sharepoint List Item permission based on Users DOMAIN
I have multiple suppliers who need to enter requests into a sharepoint list (by creating List Items). Rather than maintain separate lists, I want to consolidate into a single list - BUT I need each supplier so see/edit ONLY the items created by them. Note that there may be multiple USERS per SUPPLIER, who should be able to see/edit items created by other users within their own company / domain. Can this be configured somehow? I did think of creating a specific view for each supplier - filtered by the users email domain- and only send each supplier the URL of that view - with the "allitems" view url just having a more secure address eg ?view="view!*!all!*!items", for example - though I would need to "hide" those views from the view menu. Any ideas?Create a hyperlink to a file in web excel
How do I create a hyperlink to a file in web excel? I need to co-author my excel sheet with other users, but it needs to have links to files in it. I'm not "linking" to a data source,or otherwise trying to import data. Just a plain-old file-type hyperlink that opens when it is clicked. Can anyone advise how I set that up please? I can host it on Sharepoint Online or OneDrive. I plan to store the files in a folder alongside the workbook. Open to other solutions and suggestions of course.Local File Hyperlinks not working in Web Excel
I'm pasting hyperlinks to local files (email mailitems) into a shared excel online workbook held in a sharepoint library, for users to click and open. The files are referenced using the UNC path to the local shared network area where they are stored. \\servername\folder\file.msg Excel online automatically changes these paths to "file:///" format, which browsers really struggle with. Should I... 1. Store these msg files somewhere else (needs to be somewhere that I can save them to using VBA)? 2. Somehow configure excel on the web NOT to reformat URLs to the "file:////" format? 3. Instruct all users of the sheet to carry out a task, allowing the "file:////" format URL links to work properly? I tried changing what I'm pasting from "\\servername..." to "=hyperlink("\\servername..." but excel seems to add "https://" to the start of the URL. I tried changing what I'm pasting from "\\servername..." to "=hyperlink("file:////servername..." but excel4Web says "Cant Open Link - May be a local file" or something similar. I need the process to be as straightforward as possible for those using/sharing the worksheet. ie "Click the link and view the file."Sync local folder of shortcuts to Sharepoint 2010 library
My company has a SP2010 library with about 500 documents in it, across multiple folders. Unfortunately, we are unable to use the search function due to access restrictions, and we are not allowed to change our permissions to fix. (the site is not administered locally). I have created an excel web query file which pulls all the file data into excel, and built a VBA macro to create a local folder of "internet shortcuts" to the sharepoint files, where the shortcut names reflect the files they target, and are obviously searchable through Windows Explorer Search function. So the above is a pretty clunky way of synchronising a set of local shortcuts to the online files, but rather than do this the long way, is there something out there which could automatically synchronise the sharepoint library to a local folder of searchable shortcuts in real time, rather than me having to run this process manually whenever Sharepoint sends me an alert that something has changed. Remember, this is sharepoint 2010, so Flow (PA) won't work. Did SP2010 have something similar to flow which might help me?
