Hello, here really simple post to explain how to create a SharePoint site without Microsoft 365 group associated.
Follow there instructions:
Clicck on App Launcher and then on “Admin”. Then click on “Expand all” , SharePoint and “Active sites”
Then we can create site:
Click on Create and “Other options”:
Now we can create our site:
Why we should create site with no M365 group? If we don’t need Outlook, planner or Teams associated but just need a SharePoint Team Site. Just to remind…to do that, we should be are SharePoint Administrator.
Hello, Today not very “tech” article, But maybe usefull 🙂 Yesterday I changed password of my account…and after few hours, I noticed Outlook didn’t receiving any emails… (I updated password anywhere but…). But Previusly it still working…
How to solve it
If your problem , is actually password…A simple way is:
Go to Outlook
Click of File/Office account
Click on “Sigh out”
If problem persist, you can try clean cache.
In run dialog write: %localappdata%\Microsoft\Outlook
Open RoamCache folder
Backup your files 🙂
Delete all files
Start outlook again
In my personal case the problem was password Update, but the real problem was that I updated correclty password after change, and Outlook worked correctly. It stopped after2 hours…
If you’ve ever developed a custom Web Part for SharePoint, and “Failed to load components” message occures for guest users, here you can find possibile solution to fix it.
SPFx Failed to load component guest users
I develop a SPO Webpart…it run correctly but when my customer share site with guest user, it give us and error:
Something like this:
[SPLoaderError.loadComponentError]:***Failed to load component "12345-c123-a1be27-223a-xxxx0"(MyWebpart Name).
Possible fix path
A possible problem is guest users can’t acess to ClientSideAssets library on AppCatalog site, so one way is:
Enable external sharing on AppCatalog site
Break permissions on ClientSideAssets library and give reading permission for guest users
If don’t work, you can try also to restore inherits permission and put guest users inside readers group of app catalog site. In this case, guest can Access to all site resources as reader, but if it work you can continue investigate on problem.
Today, let’s understand how to filter SharePoint Items, by lookup column, from Power Automate flow.
FILTER BY LOOKUP COLUMN
In this Example, I created two lists: Projects and Tasks. Every tasks has lookup to project.
As we can see , we have “Project” column. This is our lookup column.
Create a flow
To to this example I create a Simple flow wiht manually trigger (keep mind…this is just an example…). My flow has one Actions (“Get Items”). Let’s see how to filter task by Project. One way is filter by title column of lookup (In this case I used Title). Another options is filter by Lookup ID.
Code to copy, filter by Value
InternalFieldName/Title eq ‘Lookup Value’
Or, filter by
internalFieldName/Id eq ‘Lookup Id’
Let’s see our flow:
Result: It get me one task, associated with “Project 1” .
Have a nice day!
If you want to understand , in general, how to filter Items in Power Automate, click this link.
Let’s learn how can we passing parameter to our Canvas Apps.
QUERY STRING PARAMETER
In this Example, I built a simple app to write a ticket in SharePoint List. In this case , I need to pass (from “external”) a parameter to our App, to set Ticket Type. My choose are:
To achievement this, we should use “Query String” and Param Function. Query String is part of url , used to passing data to application.
Step 1 – Get query string from App
To get query string, I used param function in OnVisible event of my Screen to get date and store it on local variable. I can’t use “On Start” event of app because UpdateContext is only available while you are currently on a screen. When the OnStart code is executed no screen has loaded yet.
In my Example, I used a Form with SharePooint list as Datasource . My field “Ticket Type” is Choose field. To set value as default, I set Default property of datacard, only if the form is in “insert mode”. Why? because if we are in view or in edit, we need to see data of item, not our parameter. So:
Let’s talk about Microsoft List. You can see “List” and others Mmicrosoft 365 App’s. You can use this awesome tool to create list to track informations (Assets, invetory, customers, issues ecc) and collaborate with your team members. If you know SharePoint List’s, this is appear very familiar.
Create new list
Click on the top-left corner:
App “Lists” and others Mmicrosoft 365 Apps…
Now you can View and Open your recent Lists or create New List. Click on button “+ New List”.
Now you have 4 choises:
“Blank list” to create new list from scratch (we do this for this tutorial…)
“Form Excel” to create new list , starting from excel file. It’s good starting point if you have some excel files and want to use List instead of them.
“From existing list” to create list , starting from another list (also from list create inside SharePoint site).
“Templates” if you click on one on template, you can create list starting from it.
Click on “Blank list“, add list Name, description, color, icon, choose where do you want to save your list (In “My List” or one of your SharePoint sites) and click create.
Customize your list
Now we have our Customer list and we can start to use it. First of all, we need to create some columns. Click on “+ Add Column”
Now you must choose type of date you want to store in this column. Don’t worry if you don’t know what it is it…Ask yourself: “what I want to store in this column? Name of customer? Descriptions? Logo? if the customer is active or now?” This is the key, understand what you need to save. Let’s see common type of column:
Single line of text: Simply “text”: Use it for Customer Name or short description.
Multiple line of text.:Use it when you want to store more the one text rows…for example descriptions, notes etc.
Location: When you neet to track “where”.
Number: No description need 🙂
Yes/no: Use it if you want to track simply yes or no (Boolean) value. Fors example “is valid customer?” or “Is active customer?”
Person:To save People or group in your Microsoft 365 Tenant.
Date and Time: To store date, for example “Expiration date”
Choice: To choice value inside a list of value. For example “New customer, Old customer, Inactive”. Or to save status: “Draft, Approved, Rejected”
Hyperlink: To save a link.
Currency: To store currency value…
Image: To store an image such as logo
Keep mind, you have by default “Title” field , in your list. You can rename it.
Now I rename “Title” with “Customer”, and create “Headquarters” and “Acquisitiond date”:
Use your list
Now your list should appear like this:
Now you can click on “New” to add one record a time, or click on “Edit in grid view” to edit it like’s Excel file:
Keep mind, remember to click on “Exit grid view” to save.
I hope it help you..let me know with comment if you want another article on this argumeent. For example how to collaborate with colleague on this list, or how to create rules to send an email when people do something to this list or something else.
With this article I want to explain how we can get items with Power Automate (From SharePoint Online) and Filter them.
SharePoint list’s called “Offices” ,with some data:
Excel file where we save filtered items. I create and Excel file with same column of list, and store it in OneDrive. Keep mind, you must format sheet as a Table if you want to use it in Power Automate to add rows.
Power Automate flow who get data and put it into Excel File. I used “Get Items” connector to retrieve data from SharePoint list.
We can get data with no query. In this case, you mus put only “Site Adress” and “List Name Parameters”…keep mind “Top Count” parameter and it returs “All” items. I do not suggest this approach (And also Power Automate, who show you a Warning 🙂 )
Best approach, is write a Filter Query to retrieve only items you need. Basically you should write a formula like this: fieldnameoperationvalue.
As fieldName you must use iternal field name of SharePoint (Write me a comment if you need a post on this argoument).
Operation available are:
eq (Equal to)
lt (Less Than)
gt (Greater Than)
ge (Greater than or Equal to)
le (Less than or Equal to)
ne (No Equal to)
Value: value to find, date and string must be inside ‘
We can use also logical operator like “and” and “or”
Let’s see some example (I show query and result on Excel sheet):