Add & Remove App Catalog SharePoint Online Site Collection

#Login with Global Admin id and update the email address below

Connect-SPOService -Url https://xxx-admin.sharepoint.com -credential {user}@xxx.com

# get a reference to the site collection where the site collection app catalog should be created

$site = Get-SPOSite https://xxx.sharepoint.com/sites/yyy/ 

# remove site collection app catalog

Remove-SPOSiteCollectionAppCatalog -Site $site

# Add site collection app catalog

Add-SPOSiteCollectionAppCatalog -Site $site

Note : Account used to create App Catalog Site Collection, must be Site Collection Administrators on both the tenant-level App Catalog and the target Site Collection

How to filter a SharePoint list or library using URL parameters

?FilterField1=[IntFieldName]&FilterValue1=[FilterValue]

Filtering yes/no or true/false values

If your filter isn’t working for yes/no columns, replace “no” with 0 and “yes” with 1 in your URL.

SharePoint List Item Query String Filter on Multiple Values

If you want to filter on multiple values then you can pass values separated by a semicolon(;). See like below:

?FilterName=Country&FilterMultiValue=IN;SL

Remember here the filter column name is the internal name of the column, not the display name.

You can add up to 10 FilterField and FilterValue like below:

/Lists/MyTestingList/AllItems.aspx?FilterField1=Country&FilterValue1=IN&FilterField2=Title&FilterValue2=Item-2……

SharePoint List Item Query String Filter on wildcard characters

You can also filter SharePoint list items filter items based on wildcard characters like below:

/Lists/MyTestingList/AllItems.aspx?FilterName=Country&FilterMultiValue=*IN*

Microsoft Lists

Your smart information tracking app across Microsoft 365

 

Microsoft 365 apps - with the broader notion of difference between work management and task management:

 

• Microsoft Lists [Work management, work tracking] | Create, share and track structured information with the ability to create, collect, view, filter, sort, collaborate, share, etc. across status, life cycle, ownership, etc. Lists can further integrate with the Power Platform to design and build productivity apps alongside Power Apps (custom forms) and Power Automate (custom flows); think of Lists then as the underlying database for IW-led 'productivity apps.'

 

• Microsoft To Do [Task management] | For individuals - a complete view of all their tasks, including tasks assigned to them. It is their view on their tasks. When completed, tasks disappear.

 

• Microsoft Planner [Task management] | For the team; task management for the team; tasks assigned to individuals on the team. When completed, tasks disappear.

 

• Microsoft Tasks [Task management] | an app within Teams to help users manage and prioritize their work generated, aggregated tasks from across Microsoft’s portfolio of productivity and collaboration tools: Office docs, Planner plans, emails, chats, and more.

 

• Microsoft Excel [Analysis tool] | Create spreadsheets using built-in tools to help turn data into insights and to visualize via charts and graphs – to help calculate, analyze and predict. In Excel, the individual cell is the focus; related information sits next to each other. With Lists, an entire row is the collective focus; related information with each other. Note: You can import data from Excel, manage with the list and one-way export up-to-date info back in Excel or Power BI for further analysis.

 

On May 20, at the Build 2020 developer conference, Microsoft revealed “Lists,” the newest app for the Microsoft 355 subscription service.

 

Vision for Lists – to highlight how you use it to track issues, manage inventory, build out event agendas, report status, manage FAQs, and more.

 

• Microsoft Lists home (web) and mobile app – Create new lists, share and access recent and favorite lists in one location

• Microsoft Teams ♥ Microsoft Lists – Create a new list or embed an existing list directly in a Teams channel - combining lists with side-by-side conversation

• Ready-made templates help you get started quickly – Jumpstart common scenarios with preconfigured structure, forms, views, and formatting

• Customizable views, smart rules, and sharing keep everyone in sync – Visualize your information, build if/then rules, and share with confidence

Videos

    

Demo List

https://demobuilderwebcpptxz.blob.core.windows.net/microsoft-lists-create-a-list/startdemo.html

https://resources.techcommunity.microsoft.com/wp-content/uploads/2020/07/Microsoft-Lists_Look-Book.pdf

Reference

https://techcommunity.microsoft.com/t5/microsoft-365-blog/announcing-microsoft-lists-your-smart-information-tracking-app/ba-p/1372233

https://resources.techcommunity.microsoft.com/microsoft-lists/#demos