User Profile
pigsinblankets
Copper Contributor
Joined Nov 15, 2022
User Widgets
Recent Discussions
Change multiple line of text column to single line of text
Good morning, I have a multiple line of text column in a Microsoft List. All names are under 255 characters. Just wondering if I can change this to a single line of text column without losing any data? SharePoint doesn't pop up a you may lose data box but I'm still not sure if it will work so haven't saved it. This is needed for how data is formatted elsewhere. Thanks!Solved1.2KViews0likes2CommentsSharePoint List - 'Yes to All' automation
Good Afternoon, Is there a way to create a 'yes to all' button to e-mail to colleagues who can then review the Microsoft list data applicable to them and click that yes to all button which will change that column all to yes? Currently colleagues are needing to go into each individual row one by one to mark them as yes so just wondering if there's a way to automate this and make the process more efficient Thank you! 🙂SolvedPower Automate latest SP List appended text update
Good evening, I am having problems with the appended text field in SharePoint Lists and using this in PowerBI. Is there a way using Power Automate to capture the latest appended text update and duplicate that to a separate list column for this to be used in PowerBI reporting and show the latest update? Currently I have problems where the appended text update shows as blank in PowerBI when an alternative column is updated as it assumes the lack of an appended text update is the latest (i.e blank) Hopeful this is a common issue and is solvable somehow, thank you 🙂Resize statement boxes on Likert question
Good Morning, I have never used a Likert type question before and despite Googling I am having problems resizing the statement boxes, words like 'Communication' don't fit on one line, Is there a simple way to resize these so the text fits in there properly? Thanks!7.2KViews0likes4CommentsAdd a Document SharePoint link to a MS form
Good Morning, I'm trying to add a document hyperlink/SharePoint link to a Microsoft form but the link pastes in 'DocX' format and isn't a hyperlink when pasted to the form. I am trying to add a document link to a subtitle to allow users to access it for more information to be able to answer the question - am I missing something super obvious here to be able to do this? Thanks!7.5KViews0likes4CommentsBranching in Microsoft Forms - greater or less than
Good Morning, I'm not sure MS forms has this functionality but for branching questions I was wondering if there was any way to branch to questions determined by a certain numerical answer. So if the respondent answers 100 or less it will branch to question X but if the respondent answers 101 or more it will branch to question Y - is this possible in MS forms? I can't find any reference to it on Microsoft's guide here https://support.microsoft.com/en-us/office/use-branching-logic-in-microsoft-forms-16634fda-eddb-44da-856d-6a8213f0d8bb so I'm guessing not? Thank you 🙂1.8KViews0likes2CommentsSharepoint List Permissions Vs Sharing Links to List
Good Morning, A user has had a problem accessing a Shared Link (granting them permission) to a SharePoint list and I have had to add them to the 'list permission settings' with read access. Can someone explain what the difference is between granting permissions via the list permission settings and granting permissions via a sharing link? I am unsure why both options even exist, Thanks1.9KViews0likes2CommentsRe: Add a Document SharePoint link to a MS form
Hi Rob, Thanks very much for the reply that seems to have worked! 🙂 Is there anyway to edit the display text to the hyperlink or would it have to be the full long links above? I've tried to amend the display text to a shorter title but I can't seem to get that to work so guessing hyperlink formatting isn't an option in MS forms? Thanks again! 🙂6.7KViews0likes2CommentsImporting SharePoint Classic View Microsoft List into MS Teams
Good Morning, We have a 'classic view' SharePoint Microsoft List built into our Microsoft Project Web App (PWA) system - the classic view cannot be changed due to how the system has been built, and the lists are part of individual 'project sites' within the overall PWA system. I have tried multiple ways to add this MS List to a tab in Microsoft Teams however I can't get this to work properly, I have tried using the website app and lists app and SharePoint app - the columns are formatted correctly and I can't work out why particularly data isn't working. Is there a better MS teams App to use for adding a SharePoint list to MS teams or is there some sort of incompatibility between SharePoint classic view and importing into MS teams? Thanks,1.2KViews0likes1CommentSharePoint List Access Permissions to use Online List in PowerBI
Good Afternoon, I have given a group e-mail direct access (read only) rights to a SharePoint list and have also shared a link to the list to this e-mail address given them view rights. They are having issues with the List Data feeding into PowerBI Desktop and I'm struggling to resolve this - does the e-mail address above also need access to the SharePoint site as a whole where the list is hosted in order to use it in PowerBI? Is it possible the 'direct access' permission is somehow clashing with the Shared Link causing the data to not feed in properly? I've tried resetting permissions/only using direct access/only using the Shared Link but can't resolve this problem, Thanks2.4KViews0likes2Comments
Recent Blog Articles
No content to show