Lists
12 TopicsMicrosoft Lists Auto Increment Number Field
Hi Experts, I am using MS Lists within MS Teams for the 1st time today. I am trying to create a simple issue list with 2 columns. 1st column (ID) is of type Number and the 2nd column is of type 'Multiple lines of text'. When a new item is added to the list, I want the ID column to auto-increment. What I've tried is, using the 'Edit column' dialog, I checked the 'Use calculated value' checkbox and in the 'Default value' field I've entered the formula: = "ID"+1 But the ID field is not getting populated nor is it auto-incrementing. Any thoughts what I am doind wrong? Tom McCannSolved91KViews1like10CommentsIntegration of SharePoint/Lists, To Do/Planner, and Forms with Power Automate
Background: I'm an attorney with two legal assistants. I've found Teams is a great way to work with my assistants when I'm in court, etc. to get things done. But I want to take it to the "next level" because there are still a lot of gaps between what we are doing on Teams (tasks, approvals, communicating) and what we still do outside of Teams. Essentially, I want to bring a lot of those things outside of Teams into it so that we work smarter and not harder. Although I'm tech savvy, I'm by no means an expert or developer. Overview: Ultimately, I'd like to integrate SharePoint/Lists, To Do/Planner and Forms. My thought is that I could have one of my assistants do data entry through Forms (create/update) and then use Power Automate to create/update SharePoint/Lists and also create/update To Do/Planner tasks. I'd also like to keep a "Master Lists" in one Team where the Forms reside, and then present that information into different Teams by service so that I have one Team for one type of service, and another for a different type of service. "Master Lists" itself will have Lookup columns to relate data (client contact information, client matters, client tasks, etc.). After a lot of research, I find I can create Forms, create/update SharePoint/Lists based on Form entries and create/update To Do/Planner using Power Automate. One of the issues I'm encountering is taking that information and putting it into different Teams in a way that filters the services (so that Service A is in Team A, and Service B is in Team B, etc.). One of the reasons I want to have separate Teams for different services and not perform this in the "Master Lists" (which is in it's own Team) is because my assistants work on different services; additionally, I am relying on one assistant to do the main data entry of creating a client and populating information (the "Master Lists"), while the other one is just completing assigned tasks and updating information accordingly. I'm wondering whether I am on the right track for what I wish to accomplish. I'd like to be able to show client information in different Teams filtered on the service type so that I can keep things somewhat separate, and it'd be great that either of my assistants could update in those Teams accordingly rather than going back to the "Master Lists" I have. I don't want to keep creating new lists in each Team per my requirements if I can avoid it. Any advice or links to resources is greatly appreciated.5.3KViews1like3CommentsMicrosoft Lists Tab in Teams APP not pulling list
Hi, I have users getting this message when trying to access a Microsoft list via mobile Teams App. Most of the members on the team can access however some see this below I have had the ones that are getting above message log out and log back in- didnt work Uninstall and reinstall teams app - didn't work Removed member and added to team and channel- didn't work access from desktop app- worked Any other troubleshooting ideas to get the link to load for them in the mobile app? Thanks, Matt2.7KViews1like1CommentMultilingual view of a list in a teams tab
Hi Community, We created a issue list (based on the template) in a team and embedded it as a teams tab to a channel. We changed the predefined column names of the issue list. the german users are having a german teams user interface however, most users are getting english column names of the list in the teams tab. some users are getting the columns names correctly in german. the list is stored in the corresponding team site the default language of this team site is german my questions: 1. What/which user language configuration impacts the display of a list in a tab in MS Teams? 2. How to control this from admin side, so that the language setting of the MS Teams App rules it as the master? Thanks, André1.7KViews0likes2CommentsLists - Conditional column styling
Hello: I have created a list using lists in office 365, with column background and text color conditional style. When I use this list in Teams, conditional color column background is respected but conditional text color is not applied. May be I must configure something in Teams? Thanks in advance.513Views0likes0Commentsjoin a conversation about a list item in teams does not work
The ability to start a conversation about a list item in teams is not working properly , just trying to figure out if there is anything i can do or simply microsoft´s feature needs to be updated. The feature itselfhttps://support.microsoft.com/en-us/office/have-a-conversation-about-a-list-item-in-teams-79f80553-2c54-467e-be91-2bc6b71e94a6#bkmk_joinconversation to be used with the Sharepoint App in teams. but from my experience since this was released the "link" created does not open the item view form but the list with all items. If i use the MS List app instead, this used to work as documented, but since 2 weeks now i get a black screen /white depending of your theme and nothing loads at all. nor the list not the item view form. anyone else having this issue ? any ideas ?2.4KViews0likes5CommentsUnable to import data in MS List App
Hi there, I am trying to create a project tracker using the Lists app in teams (I know planner and project exist but the management needs a POC for lists as well) and I noticed that if I start a list from scratch, it is very easy to format the columns and make them look aesthetic, also it is easy to add a Person/Group Type column where I can add people that link back to their profile and other Org data. However, when I try to import an existing tracker that existed in an Excel until now, I am either unable to import it or if it imports, there is no formatting and the people names don't seem to be linking to their respective people/employee profiles. Has anyone been able to successfully import excel data into the Lists project tracking app? This is how it looks currently: This is how I want it to look:2KViews0likes1CommentMicrosoft Lists Teams intergration
I am looking to add a Microsoft list to an existing Teams channel, I have managed to get the list into Teams successfully. However we are using this list as an issue tracker, so we tend to use a field in the list "Comments" to keep weekly updates on the issue. I am noticing that using a long text field in Lists within Teams isn't the most user friendly thing the textbox field is very small and doesn't allow you to increase the size. Wondering if anyone knows if any special formatting can be applied to fix this or if there is another solution that would allow us to track progress similar to our current process.Solved1.2KViews2likes1CommentCalendar List View - Future Months Not Showing
Hello! I created a group calendar within Teams where team members can add their time off through a list. Team members have put in time off for the next three months. In the list view, I can see all inputs for all months but in the calendar view, I can only see the current month (June) listings. Here is a screenshot of the calendar view. There should be listings for July but they are not showing up on the calendar view. Any help would be greatly appreciated!1.3KViews0likes0Comments