How to add multiple links in a single column of a SharePoint library
I'm setting up a workflow for students to submit petitions for course substitutions and waivers. These often require students to provide documentation (copies of syllabi, unofficial transcripts, etc) which they are able to do via Microsoft forms. The petition reviewers have requested that the petitions be saved as pdf documents. I've been able to use Power Automate to grab a templated document, save it to a Sharepoint library and populate the Form details into the library columns, which populates the document, which I can convert to pdf. The only problem I'm having has to do with the files the students upload to the Form. I'm able to grab those files and save them in SharePoint, but I'm having trouble creating a column that lists all the hyperlinks to the files. In a list, I could do this in a multi-line text column with rich-text enabled, but libraries don't allow that. I'm not that proficient yet in JSON. Is there a JSON schema that would allow me to format a multi-line text or a multi-choice column to display multiple hyperlinks based on dynamic content AND have the link carry over to the Word template via document properties quick part?
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 when items viewable by that group reach a certain amount. Is this leveraging of the Column 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 SharePoint site 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 the channel folders weren't created in the SharePoint site so when the flow 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't create 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?
