How to create a flow to update any file been modified not just a specific file?
So, I've half solved my previous question of Auto updating Vesion number in an excel file on SharePoint. I can now setup flow to update a specific file, but it's a pain to setup the same way one by one for all my excel files. Is there away to setup my flow so it can update ANY excel files that's been updated? Currently, I need to point to a specific file location, but what if I remove the file name and replace it with the Name, however, I don't know how to setup afterwards, it's asking me for Property and says the key value Lable is not applicable anymore? Help please~
Want to automate email population when specific list item details updated
I've created trackers using SharePoint lists. I want to be able to automate the population of emails to specific people to include specific column details from a SP list item to send at times when a specific column's drop down selection changes to a specific selection, or when certain fields are populated for the first time. Is this possible? If so, how do I do that? I've looked through the Alerts and Workflow instructions and it is all way too basic to meet my needs because it only sends an alert when anything in the item is updated, not when specific updates are made. Also, neither seems to auto populate the email with specific details pulled from the list item that is being updated. I don't know if this is possible, or if I maybe need another program or plug-in to work with it. I'm sure I can get my IT to give me permission to download and use additional programs or plug-ins, but I don't know what I need right now or if my vision is even possible. I think we are using SharePoint 2016, but I am not sure how to confirm that. Looking for help from anyone who has successfully put something like this together! Thanks!Random issues with Pnp Powershell in Azure Runbooks
Hi everyone, we're facing random issues when running PnP powershell from Azure runbooks when several instances of the same runbook run concurrently. The scenario We have several of runbooks, they all use PnP Powershell, and each of them perform different actions, such as Enabling site collection app catalog, scripting, external sharing, creating a list etc. Those runbooks get triggered in two different ways: - one is triggered after a new site is created, through a site script, that triggers a logic app and from there we trigger the runbook - the others are triggered via webhook (http post from a function attached to a queue) The issues When the same runbook is triggered more than once at the same time, they fail in different ways: - we see the logs being logged more than once, then the runbooks get suspended - pnp randomly fails, it does not enable the site catalog, or enable scripting, etc - if we put our code inside a try catch block, we use to read weird errors (null reference, invalid connection when using Connect-PnPOnline, etc) Some errors are: Set-PnPTenantSite : Object reference not set to an instance of an object. At line:41 char:9 Connect-PnPOnline : Token request failed. At line:31 char:5 Set-PnPTenantSite : No connection, please connect first with Connect-PnPOnline At line:41 char:9 Add-PnPSiteCollectionAppCatalog : Object reference not set to an instance of an object. Background info: The runbooks were never executed at the same time against the same site. When we trigger them concurrently, we only do it for 10 sites, and the runbooks are pretty simple (connect to the tenant, enable site collection app catalog, and then disconnect) Any ideas? Thanks
Doc Library Expiration Date Automation
Greeting Everyone, I am in need of your expertise. I created an expiration date field that automatically calculates 1 year from the date the file is uploaded. I also created a flow to notify the document owner or the user who modified the document to review the document 15 days prior to the expiration date. However, I would like SP to automatically change the expiration date field when a user modifies the document and checks it back in. How would I go about doing so? I am fairly new to SP Online and all functions previously mentioned were done by watching Youtube videos. Thank you in advance for any assistance anyone can provide.
Sharepoint, Excelfiles, filter, teams
Hey, Hey, I have been looking for a solution to make it easier for me and my colleagues and I hope someone can give me some tips or advice what I can do. We have a team site in sharepoint With different folders: Warehouse: In This folder, each employee has a excel Workbook with data and material that we used that day with the customer. Dispatch: This includes all employees a excel Worksheet with the customer's data and what we have done On yet another excel Worksheet, we note the Repairs/cancels Of that day So We are always every day again 3 to 4 times the same to fill what leads to problems. Can I not somehow make sure that all employees on 1 excelwerkblad Note All: Customer data, install/repairMaterial...... etc. and that excel Automatically filters the correct data to the correct werblad Copy so that it does not have to be filled in again Day report: All employees record everything in this Repair/Cancel: Material I hope you have some tips or Ideas Have, let's come 😊
