New answers tagged sharepoint-online
0
Try below steps
Create automated flow select When file is created or modified (Properties only)
add condition Name is equal to Key Logistics and IsFolder is equal to false
if yes then send an email
Check attached screenshot for reference
0
Custom master pages are currently not supported for "modern" pages.
Documentation: Supported customizations for "modern" pages
Similar thread: Customize master page on modern/communication site
1
Try this using Value() function:
Sort(Filter(Master,StartsWith("ID",Value(Search.Text)),Created.Email=User().Email),ID,Descending)
In this case, user has to enter the valid number in search textbox.
Reference: Value function in Power Apps
Update from comments:
If above is not working for you then use below:
Sort(Filter(Master,StartsWith(Text(...
0
Transform to modern site pages using PowerShell:
https://docs.microsoft.com/en-us/sharepoint/dev/transform/modernize-userinterface-site-pages-powershell
Sample blog for your reference:
https://www.c-sharpcorner.com/blogs/convert-classic-pages-to-modern-pages-using-pnp-powershell-script2
0
You can increase the size of your SharePoint list form.
Edit your existing SharePoint list item form with Power Apps
Inside Power Apps Studio, Click File > Settings
Change the width to match your requirements
Save and publish the form
Now you will see that your SharePoint list item form is much wider.
0
When you treat document libraries as Folders, then the Document library's name is Shared Documents, not Documents.
Documents is merely a "Title" that can be different in different translations. The "Name" on the other hand never changes.
This is the URL of the default Document library. Notice how it says "Shared Documents"
https:...
0
It could be that the something is wrong with the accents or with casing. Or maybe there is some extra character in a string.
Always use single quotes when defining variables. Just in case there is a special character in your string:
[String] $string2='Wiadomości'
This is the best way to compare two strings:
[System.StringComparer]::...
0
Except for a very few exceptions, Classic Team sites have the same features (or even more) as the Modern Team sites. This means classic Team Sites can:
Have modern pages. Including modern home pages.
Can be connected to a Microsoft 365 group
Can be connected to a hub site.
etc.
Create a modern landing page for a classic site
Navigate to your classic Team ...
0
Might not be the best answer, because I am not good at PowerQueries.
Perhaps, you can first filter the lists by title:
/_api/Web/Lists/?$filter=Title eq 'My List Name'
This way, if the returned array of lists contains 0 items, then your list does not exist.
If the filtered list returned 1 item - you are good to proceed to retrieve list items.
0
SuccessFactors does not directly intergrate with SharePoint Online. And there is no integration between the Continuous Feedback tool and SharePoint lists.
However, you can take advantage of Power Automate and SuccessFactors API. If you create a Cloud flow that is triggered when a SharePoint list item created, you can send an HTTP request to the ...
0
How to read a table from an Excel file that is periodically recreated
You need to use the Get Tables action first. This lets you get all tables from your Excel file.
Then, you can select the first table and grab its unique 'id':
Expression used to get unique table ID
first(outputs('Get_tables')?['body/value'])['id']
2
Here are three options for speed comparison. We'll create 100 SharePoint list item in a plain list. Then you can see what approach is best.
Option #1. Direct approach
for($i=0; $i -lt 100; $i++){
Add-PnPListItem -List "Plain List" -Values @{Title=$i}
}
Time: 70.3 seconds
Option #2. Pass list object instead of the name
When using the Add-...
1
As you want to improve the experience when coding about the JSON in the form body, it may be better for you to post the idea in user voice. And I am not sure if there is a 3rd party tool available having this feature.
0
You can use Site usage feature to view usage data for your site the last 7 days, last 30 days, and last 90 days.
Note:
Site admins, owners, members, and visitors can view site usage data
Site visitors cannot run external user reports or download the 90-day
usage report
Guest users with Site Owner permissions will not have access to site
analytics or site ...
0
Since the answers are old and couple of new methods are available for this now. Currently, it is not possible to do this tenant wide using Admin center. But it is possible to set this at site level using PowerShell or via Admin Center for each site.
Using PowerShell loop through sites and set the flag
$sites = Get-SPOSite -Limit ALL
foreach ($site in $sites)...
1
Unfortunately, there are no formatting options available for the form body. The only options are the sections, their names, and the fields for each as you've already got.
0
option 1: add a condition. should be pretty simple, check the title, if it's the one you want, send the email, if not do nothing. (when you add actions to the flow, once of the choices of things to add is the condition action)
Problem with the above: it will work, but technically the workflow will run for every single document, which counts against your ...
0
You cannot show the list item attachments as a thumbnail image in list view using JSON formatting capabilities.
Documentation: Use column formatting to customize SharePoint
0
Installing the update above, ensuring that .NET Framework 3.0 was installed and then clearing the cache worked for me.
#Add Module
Install-Module -Name DotNetVersionLister -Scope CurrentUser #-Force
#Check to see which/if .NET is installed and what version
Get-STDotNetVersion
1
You would need to use Conditional Access Policies, created in Azure AD, at the site level. You can use Set-SPOSite -ConditionalAccessPolicy <policy_name> to assign it.
This will require Azure AD P1 licensing for users managing the policy and the end users who are covered by the policy.
0
Bonjour, il est en effet possible d'ajouter un sous site sous la forme d'un onglet (lien web) dans le canal d'une equipe Teams. Le probleme est qu'il est impossible d'ouvrir dans Teams, les librairies qui composent le sous site en question...
Quelqu'un a t il une solution ?
0
Follow below steps:
Set Require that this column contains information to No for both columns from column settings
Go to List settings
Click Validation settings
Enter either of below formula (as per your requirement) in Formula text box
Add meaningful error message in User Message text box. This message will be shown to users on list forms
Click Save
If you ...
0
When you want to import data into list by using excel, it's impossible to populate multiple choice column.
0
You don’t need to set column as required. Please use below formula in the list validation.
IF([A]="",IF([B]<>"",TRUE,FALSE),IF([A]<>"",IF([B]="",TRUE,FALSE),TRUE))
0
Please run the following the PowerShell script:
Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\...
0
It does what it needs to do
try {
Connect-PnPOnline-Urlhttps://yourname.sharepoint.com/sites/yourSite
$page=Get-PnPClientSidePage-Identity"Home.aspx"
#Retrieve webparts from modern page
$webParts=$page.Controls
foreach($webpartin$webparts) {
Write- Host "WebPart Id "
$webpart.InstanceId
Write- Host "Title "
$...
0
PnP PowerShell to Add Link to Quick Launch:
Add-PnPNavigationNode -Title "Contoso" -Url "http://contoso.sharepoint.com/sites/contoso/" -Location "QuickLaunch"
PnP PowerShell to Remove Link to Quick Launch:
Remove-PnPNavigationNode -Title Recent -Location QuickLaunch
Here is the PnP PowerShell script to add link to Quick Launch:...
0
I recommend using MS flow instead of using sharepoint designer since it is much more easier to configure plus has more functionalities for future integration and improvements.
MS flow has a template flow which does pretty much what you want to do ... you would have to modify it little bit
Please check the one here :-
https://us.flow.microsoft.com/en-us/...
0
The reason it is not working is because you need to add a "wait" statement. Because SPD is not understanding that it should wait for a response before exiting the workflow. I am adding how to do it below :-
Add parallel action and create a new Boolean variable
Please make sure to set the variable to exit the parallel loop
To do this right click on ...
0
I think the best way to store info on SharePoint is to dismiss folders instead of metadata and after create views acts like a folder.
0
SharePoint groups are not supported in audience targeting in SharePoint online.
Azure AD groups (including security groups and Microsoft 365 groups) are supported with the exception of AAD dynamic groups.
Documentation: Target content to a specific audience on a SharePoint site
Currently you can only use AD groups or Microsoft 365 groups to target ...
0
Microsoft confirmed it's a bug. And almost fixed it. At the moment the sets are displayed with correct fields. But another issue appears now. When you press "Edit all", information disappears from all columns. But I will leave it for another post.
0
you can try to go on document library in whic is the document you want to be approved and go to (...)-> Automate->Power automate-->Create a flow. From there you can choose several type of prebuilt flows (you are able to change delete some aprts obviously).
I try this and the email is notified as "Microsoft Power Apps & Power Automate".
...
0
Still the same list view threshold in SharePoint online:
You can store up to 30 million items or files in a list or library.
Filtered views of large lists have a similar experience to other
lists. However, when a list view shows more than 5000 items, you may
run into a list view threshold error.
More information:
https://docs.microsoft.com/en-us/sharepoint/...
1
Use this:
"txtContent": "=if([$isOwner], 'Captain', 'Crew')"
Output:
0
SharePoint Online Modern page layouts:
Home Page Layout
Article Page Layout
Single Part App Page
Please run the following PnP PowerShell script:
Write-Host "Type the site collection URL:"
$siteCollectionURL = Read-Host
Write-Host "Type the page name:"
$PageName = Read-Host
Write-Host "Choose the page layout:"
...
0
According to the PowerShell script that you provided, there was no error in my test.
The SharePointPnPPowerShellOnline module is being retired and all of that effort is being channeled to the PnP.PowerShell module. The SharePointPnPPowerShellOnline module will continue to be around for the on-prem versions of SharePoint Server (though not updated), but for ...
0
For update choice Column with CSOM under condition, you can refer to this thread. It still works for current SharePoint Online and it runs without any issue in my end.
For multichoice column, you can refer to the following script I modify a bit on
#Login Information for script
$User = "jerry@email.com"
$Pass = "<PWD>"
$WebUrl = &...
1
For the end users , we are not able to provide a button to cancel the flow run. There is an action called terminate action which will stop the running flow. However it is often used to stop the flow in the process for certain condition.
Only Flow owners will be able to stop a pending flow in Power Automate studio. End users cannot do that in a list or ...
1
I found the error : the GetFolderByServerRelativePath method must be used instead of GetFolderByServerRelativeUrl
The right code is :
$folderurl="/sites/MySite/MydocLib/MyFolder %1"
$rpFolder = [Microsoft.SharePoint.Client.ResourcePath]::FromDecodedUrl($folderurl)
$CurrentFolder = $ctx.web.GetFolderByServerRelativePath($rpFolder)
$Ctx.Load($...
1
Steps to solve your problem,
Go to library settings
In permission and management > click on Manage files which have no checked in version
When you see list of checked out files
Take ownership of selection > select the document for which you want to take ownership
Delete it or update it, it's up to you 🙂
I didn't do this by my self > not unit ...
0
This is how you can display Approvers in a dropdown:
Collect all values from the Approver field. We want to only take "DisplayName". But you can also take an email if you wish. We collect all of these values in the Approvers array:
ClearCollect(ContractsList, Contracts);
Collect(Approvers,ForAll(ContractsList, 'Approver'.DisplayName));
Now you can ...
0
I have found various solutions to this,
https://youtu.be/pkZG2boN7jQ?t=524
http://blog.extrobe.co.uk/blog/2016/11/27/populate-a-dropdown-based-on-the-value-of-another-dropdown-in-powerapps/
Filtering lookup values based on another column in another list, sharepoint online and powerapps
https://powerusers.microsoft.com/t5/Building-Power-Apps/filter-a-person-...
3
Once the Flow is triggered, there is no way it can prompt the users to enter more information directly. Except for the approval feedback:
However, you can do something like this:
Create a small Power App. It will have a people picker control.
In your Flow, stop using the OOB approval action. Instead, send users an email with the URL to the new Power App.
...
1
Might not be the direct answer to your question, but it is probably easier to use the native "Create file" action instead of the REST:
1
If you are using a modern SharePoint list and the status column is a choice, you can simply do the following:
Go the the "Column settings" > "Format this column":
Click "Choice pills" > "Advanced Mode":
Inser the following code:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/...
0
Unfortunately, choice is not yet supported as an input in the "for a selected file" trigger. This is all we have at the time of writing it:
0
One option is to use the Do Until loop in Power Automate like so:
Basically, you keep creating an approval until it's finally approved. The real example will have more actions.
2
You should ask your IT to do the following:
Create standalone Modern Team site for your service. Give them the name of your service.
Add you as an Owner to the new site.
Provide the URLs to the new site.
Now, that you are a site owner, you need to do the following:
[Optional] Ask an SharePoint Online user to help you. You can even use this forum to do it.
...
0
Yes I cant maybe conditionally use different hyperlink for each courier, I decided to use a hyperlink to the item in List 2 using a filtered view link. So after the user clicks on the hyperlink in List 1, it will open the respective shipping details item in List 2, and then they can click on the tracking number to go to the courier's page from List 2. So it ...
Top 50 recent answers are included
