Ultimate Polling and Quiz Experience with Polls app: The Replacement for Forms app in Teams meeting
Initially Forms app was launched in Teams - for different experiences based on the sync vs async user scenarios, as it points to polling experience in meetings for quick creation to launch, while it points to survey experience in the context of Teams channel.To provide an intuitive and easy-to-access experience , Polls app was launched - a dedicated app for all your polling and quiz needs in Teams meeting and chat. We are glad to see that hosting an effective and interactive meeting just got easier after the launch of Polls.
Hyperlinking List gallery view on SP
I have a list that is full of training courses and i want to make it so that when a user select one of them, it will hyperlink to the corresponding hyperlink. I could do an powerapp, but wanted to see if there is a way to do this via list webpart on a SP page. Can't use event webpart since there are no set dates, some are on demand.
SharePoint List Web Part - major caching issues
Hi All, I've spent a lot of time building a List based company calendar in our SharePoint Intranet Portal, and the calendar itself is working great, however I'm having no end of headaches with the List Web Part. (not just for this calendar, but all list web parts for that matter) The calendar has a Start and End field - both are Date and Time fields. A custom view is created for use with the List Web Part to embed an "upcoming week" view, this is based on a filter which checks both Start and End dates to see whether an event exists within or spans the date range from today to 7 days in the future, so it is a rolling 7 day window. This is based on a number of filter criteria which include [Today] and [Today]+6. The view also has a sort criteria to sort based on the Start (Date/Time) field. This all works fine when previewing the view within the list itself - at midnight the results update to include events from the day that is now 7 days in the future which were previously excluded. So the view itself is working fine. However the same view in a List Web part on another page suffers from a ridiculous amount of browser side (?) caching, to the point that it is basically broken and unusable. When I open the page the next day in a browser (even if the browser was closed) one of three things happens, somewhat at random: The events 7 days in the future (which just came into filter scope today) just don't appear until a forced page reload is done. The events 7 days in the future do appear but they are sorted incorrectly, appearing at the TOP when the date sort order should show them at the BOTTOM. Sometimes 2 happens but the event is shown with the Start and End Date/Time fields empty - so not only is it at the wrong end of the list it doesn't even show a date at all until the page is refreshed. Here is a picture showing the sort order being incorrect as in case 2: When these various problems happen a full CTRL-F5 browser refresh always updates the list to be complete, up to date and sorted correctly, however, if after that you click away from the page and follow a link to return to it OR press a regular F5 refresh it goes back to being incorrect! It takes many page reloads or a lot of time to pass (hours) before it finally settles down and gives the correct results every time. Then the next day the same caching problems happen again. If you go to a new browser or PC the same problems happen again, suggesting this is browser side caching not something at the servers. While the actual content of the list items update in real-time if you edit the list content in another page (which is pretty cool) the "result set" of list items (which items should or should not be seen) is heavily cached, and the sorting is unreliable. Has anyone else found a solution to this ? I have already done things like disabling offline mode for the list, (this only seems to affect caching of the actual data in the list items, not caching of filter results) etc and I cannot find a solution. The only thing I know which would probably work, as I have had to use this approach on another list is to extend the date range of the filter criteria for the view further into the future, then filter out the extra days using json code in "format view - however AFAIK you can only selectively hide rows like this if you use a custom rowFormatter, which means you have to fully re-implement the standard view including hard coding all the columns you want and it still won't look quite the same. This is a lot of work and maintenance overhead in the future to work around a caching problem that shouldn't exist in the first place. Any thoughts appreciated as a lot of time and effort has gone into building an entire calendar system around a SharePoint List, only to find that the list web part just doesn't work properly.
JSON formatting to change background color of ENTIRE column of list?
Hi, I'm trying to use JSON formatting to change the color of an entire column of a SharePoint list, and I can't figure it out. Setting the background-color style property appears to only affect the background color of the text. You can still see the default column color in between rows. I want the whole column to be one color. Is there a way to do that?
ID Calculated Column Not Showing
I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box. However, in the actual List item, the vasty majority are showing ID as 0: There does not seem to be a pattern for this, Does anyone have an explanation for this?Recycle Bin and Site Content Hidden for Site Members and Site Visitors
I posted this before but made a mistake with my write up, so I am reposting. I have a requirement that the Recycle bin and Site Contents should be be hidden from the Site Members and Site Visitors. Please how can I achieve this because the Server Infrastructure activation is not working for me. Any workarounds? Please helpMicrosoft Lists forms: What's New
Microsoft Lists forms help you get the specific details you need from various people and groups, without overexposing your full list and list details. With these improvements, you can create more dynamic, customized, and efficient forms, helping to streamline your workflows and gather more targeted data - and they look beautiful and load and submit quickly. Let's explore these updates in detail – first in a short demo video tour, and then more details below. Watch now: Seamless creation of forms with more customization Quick Creation of List Forms from Lists home, SharePoint, and the Lists app in Teams Creating list forms has never been easier, or more integrated. Now, users can get started with a form without first needing to create a new list. As you create your form from Lists home, SharePoint, or the Lists app in Teams, the underlying list for responses is created automatically behind the scenes. This seamless process saves you time and effort, allowing you to focus on collecting and managing your data. Conditional Branching Make your forms smarter and more dynamic with conditional branching. This feature allows you to show or hide questions based on previous answers, ensuring respondents only see questions relevant to them. This not only improves the user experience but also helps you collect more accurate and targeted data. s the submitter makes their choices. Logo Support Brand your forms with your organization's logo. Adding a logo to your forms not only makes them look more professional, but it also reinforces brand identity. Create more relevant forms with additional field types Note the image above and the corresponding numbers to indicate new supported field types: 1. Location Collect location data with support for location columns on forms. Whether you're planning events, managing inventory, or tracking deliveries, this feature ensures you have accurate location information at your fingertips. 2. Image With image column support, you can now include images in your forms. This is particularly valuable on mobile browsers, where the form can access the device camera for quick image capture and upload. Ideal for audits, visual surveys, product feedback or any form where images can enhance the data collection process. 3. Lookup support Enhance your forms with lookup columns, enabling you to pull in data from other lists. This means that values from a column in another list can be displayed as choices on your form. This feature is particularly useful for creating relationships between different datasets, ensuring your forms are always populated with the most current information. However, please note that currently respondents need at least read access to the underlying source list to see and select the options. 4. Attachments Need to collect files or documents from your respondents? No problem! Our new attachment field support allows users to upload files directly to the form. This is ideal for scenarios like job applications, project submissions, or any situation where additional documentation is required. Enjoy greater control over your forms with additional settings Get Notifications for new form responses Choose to be notified the moment someone submits a response to your form. This feature ensures you stay on top of your data collection and can act promptly on new information, making your workflow more efficient and responsive. By default, this setting is turned off, but you can subscribe to the forms for which you wish to receive notifications. Allow single/multiple responses per user, per form Our new response settings provide you with control over how many times a user can respond to your form. You now have the option to permit either single or multiple responses per user, offering greater flexibility. This feature will be available shortly. Schedule when form submission starts and when it ends Timing is everything! With the new scheduling feature, you can set specific start and end dates for your forms. This is perfect for time-sensitive surveys, event registrations, or any scenario where you need to control when your form is available to respondents. Additional Lists improvements Link unfurling in Microsoft Teams Links to Lists, list items, and Lists forms will display richer details such as title and path when shared in Teams chats and channels. This new feature will enhance collaboration by making it easier for users to recognize specific List link types, in addition to viewing the title and path. n links resolve to a more visual preview. Hide collaborators Based on customer feedback regarding privacy, admins can run the PowerShell command Set-SPOSite -Identity -HidePeopleWhoHaveListsOpen $true to disable this feature on a per-site collection basis, so users cannot see who is working on the list at the same time AND the lists still support co-authoring capabilities, just minimizes the visibility of your co-authors on that sites' lists. Learn more. In the end... We hope you are as excited as we are about these new features rolling out! Try them and see how they can transform your data collection and management processes. Our team is continuously working on new features and improvements to make Microsoft Lists forms even better. Stay tuned for more updates, and don't forget to share your feedback with us. Your input is invaluable in helping us shape the future of Microsoft Lists. Visit the Microsoft Lists resource center: https://aka.ms/MSLists Submit feedback: https://aka.ms/MSLists/Feedback Discover help and 'how to' content: https://aka.ms/MSLists/Help Enjoy, sahilbaidSharePoint List "Lookup" columns not available in Get Items in Flow
I have seen this discussion before (see https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360) but suggested solutions have not resolved my issue. So, I am looking for some more guidance or suggestions. I have a SharePoint list with a Look-up column. Using Get Items in a cloud flow this field does not display. Setup SharePoint List called "ARB Meetings" SharePoint List called "Decision Register", this has a lookup column to the ARB Meetings list. Get Item Note, I have tried using Limit columns by View and created a new view including the required lookup column, without success. In the Decision Register SharePoint List, there are some items where the ARB Meetings column is blank, I don't know if this could cause an issue? Co-Pilot Help I have asked Co-Pilot for help, which gave me plently of good options I have tried the following without success: If your lookup column is not showing in the Get items action in Power Automate, here are a few steps you can try to resolve the issue: Check List Views: Ensure that the lookup column is included in the default view of your SharePoint list. Sometimes, columns not included in the view might not appear in Power Automatehttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Refresh the Flow: After adding the lookup column to your list, refresh your Power Automate flow. You might need to close and reopen the flow designer to see the updated columnshttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Limit Columns by View: In the Get items action, use the Limit columns by view option to select a view that includes the lookup column. This can help ensure that the column is retrievedhttps://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360. Check Column Settings: Verify that the lookup column is properly configured in SharePoint. Ensure it is not hidden or restricted in any wayhttps://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264. Pagination Settings: If your list has a large number of items, enable pagination in the Get items action settings. This can help retrieve all items, including those with lookup columnshttps://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files. If these steps don't resolve the issue, you might want to try creating a new flow from scratch to see if the lookup column appears. Sometimes, starting fresh can help Power Automate recognize new or updated columns. Let me know if you need further assistance or if there's anything else I can help with! References [1] https://jgvjg48436.lithium.com/t5/Building-Flows/Get-items-not-showing-lookup-column/td-p/859264 [2] https://jgvjg48436.lithium.com/t5/General-Power-Automate/Missing-Columns-from-SharePoint-List-in-Flow/td-p/239360 [3] https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files Thank-you, Irene
