Word quick parts - issues with managed metadata when converting word to pdf
Hello everyone, I am having an odd issue which I am not sure how to deal with. I have a site (SharePoint Online) with document sets and different content types. Within document sets I create various Word documents which I fill with data using Word Quick parts (data from columns). Everything seems to work fine until I export the file to PDF via Microsoft flow (when I open the original Word files, everything is filled in correctly). Most of the time, all the information is filled in, except of 2 quick parts, which are basically filled with managed metadata. For some reason, only these 2 are not getting the information, even thought the original Word document has those filled in (I basically take the same document and convert it to PDF file). I am not sure why this is happening. Also, one of my former colleagues has created a custom functionality to create PDF files directly on SharePoint (not using Flow), but the same thing happens. The only way when all data is filled in PDF document is when you convert file directly from word using File --> Export --> Create PDF. From what I see, it seems that in this process, quick parts have the issue with column types of managed metadata, as the other ones work as expected. If anyone has any idea why this happens, I would much appreciate it.
power automate will not update choice column 'get items' when the value is deleted
I'm using power automates 'get items' to copy and update SharePoint list items from one list to another. Everything works when I update items or change the value of choice column items. but if I completely delete the value, the destination list will retain the previous value that was entered. The if I enter a new value in my source list, my destination list will update again? I think this changed after the mass push out of co-pilot. My flow was created previously and now I'm trying to update it. Any ideas if there is a setting I'm missing or why this is happening?
Excluding a column in versioning
Hi, I have a column in Microsoft List that is being populated automatically via Power Automate. This happens every 1 minute. I have question if this column can be excluded in the versioning? Switching off the versioning may affect my another configuration in Power Automate > When a list is updated > send an email. My end goal is that version should change based on changes in non-automated columns.
SharePoint List - Concatenate multiple rows
Hello! Thank you so much for any assistance, truly. I am hoping to create a SharePoint calculated column. I have a SharePoint list In which I display agent's leads. Within the list, it shows the lead, the agent assigned, and which region the lead is assigned to; moreover, I want to create a calculated column that will be next to the my agent assigned column that will display the name of the different region choices they are assigned to. So, if an agent is assigned to multiple, different, regions, it will display such (even if they are viewing only one of their leads). If I need to make a calculated column, I can group the agents based on their email column.
Create a flow to trigger on a column change
Hello, Could someone please share how to create the following (Power automate) flow : 1. Given folder with files 2. It has custom column "Assigned To", type "Person or Group" 3. When value is set to this field per file need to send an Outlook notification (or any other action) It is similar in functionality to "Rules" notify on column change (screenshot below), but because it is requires a custom e-mail template, this "Rule" can't be used as-is. I've tried steps to retrieve the file metadata and similar ones, but wasn't able to select this specific property "Assigned To" and for any file in a folder (not for certain file, that hardcoded in a step).
SharePoint List - how to leverage Column Totals?
I have a SharePoint List where owners can see/edit all items, but members can only see items that they have created. Therefore, Column Count (Totals) is different for owners and members. Owners: Members: Can I leverage the Column Count of each? I plan to create a Power Automate flow that will notify me when items viewable by the owners reach a certain amount. And then a separate flow will use the Column Count of the members to notify me whenitems viewable by that group reach a certain amount. Is this leveraging of theColumn Count (Totals) possible?
Creating a teams channel does not create sharepoint folders
Hi Everyone, I have a power automate flow that creates a teams site and teams channels once triggered.Each team is provisioned alongside its own SharePoint Site. Once channels are created, the flow copies over folders from a pre-defined SharePointsite to this new site. The problem is flow works great in DEV and I have had no problem creating channels and copying over folders, however when we deployed to the clients environment the flow created the site and channels properly in teams but thechannel folders weren'tcreated in the SharePointsite so when theflow tries to copy over the folders from the source site to the new site, it cant find the folders. I also manually created a channel in one of the teams and it didn'tcreate a folder in the sp site. When I attempt to "Open in Sharepoint" from teams, it gives me a pop up with the following message: "We are setting up your file directory. Try refreshing the page after a few minutes or check back later." Anyone have any insight on this? Could this be because of permissions? Any help is appreciated.
Sharepoint page approval flow
I have setup a page approval flow on site pages but when I am impersonating user the approval flow doesn't work but when I being owner of the site creating a site page then flow is working. I have custom permissions (contribute without delete) set for users. Can you please suggest if it is a permission issue and if yes then what should be minimum permissions for this flow to work?
Power Automate: IF date falls on a weekend THEN subtract 2 days (SharePoint List)
Good day, I've created a list calledRecurring Finance Tasks: I do not want tasks to fall on a weekend. How can I build a flow that checks the date daily and subtracts two days (putting the date in the previous week) if the date falls on a weekend? Condition expressions: and(not(equals(item()?['Next Date'], null)), equals(formatDateTime(item()?['Next Date'], 'dddd'), 'Saturday')) and(not(equals(item()?['Next Date'], null)), equals(formatDateTime(item()?['Next Date'], 'dddd'), 'Sunday')) Next Date expressions: addDays(item()?['Next Date'], -2, 'dd-MM-yyyy') I've tried so many different approaches and keep failing, I'm not a coder so please excuse any mistakes I've made via my endless Googling. Any help would be hugely appreciated! Regards, Robin
