Forum Widgets
Latest Discussions
Get the content of pervious file version
Hi All, I'm trying to get the content of the last Major version of a document (so it can be published to another site as a PDF). So if the document is at version 3.6, I need the content of 3.0 to publish. I'm able to work out the current Major version by looking at the actual version and splitting on the decimal. If the decimal portion is 0, the current file is published. I then use a "Send HTTP request to SharePoint" with _api/web/getfilebyserverrelativeurl('/sites/SrcSite/@{items('Apply_to_each')?['{FullPath}']}')/versions as the URI The results are then filtered to get the version I'm after. I've seen posts else where that use the resulting _vti_history/17/SrcSite/File name.docx Uri within a "Get file content using path", however that just returns a 404 error. Any ideas on if/how this might be doable?
SharePoint site news notifications in Microsoft Teams channel
Dear Microsoft community, we are desperately trying to solve the issue since Microsoft stopped supporting the SharePoint News connector. We were trying to use the workaround that MS proposed but it's just not working. Can someone help me to setup a workflow that is posting the recent news in our news channel so that colleagues can start conversations about it? Thanks. Best Phil
Sent back to creator for approval
Hello, I am trying to create a secondary approval. First approval - is is the user sending it to be approved by managers for the spend to go ahead the 2nd approval is sent back by the finance department to the creator for approval that the goods/services have been delivered/carried out. If I build a seperate list based on the responses in the first list - the created by comes through as me as I am running the flow - but if put the 2nd flow on the 1st list it doesn't seem to run correctly. Any tips would be appreciatedCreate a file will raise this error "Access denied. 403", although i am the site admin
I have an AddPicture Control, and inside the OnChange i am calling a workflow as follow:- PopulateWorkOrderPictures.Run("Before","Posting",TextInputPicNoteBefore.Text,varWorkOrder.ID,varWorkOrder.RelatedProcessID, { contentBytes: UploadedImage1.Image, name: AddMediaButton1.FileName }) here is the flow definition:- but i am getting Access Denied error 403. i can confirm that the "Folder Path" inside the "Create file" action is valid and it is as follow:- AttachmentDocuments/11111111-23-12-2023-posting/Before and also i am the site admin and i am using power apps using my email, which have full control on everything.. any advice why i am getting this error?Copying lookup column value from one SharePoint list to another
Hello. I am having some difficulty when I try to copy the values in a SharePoint lookup column from one list to another. Both lists have the same lookup column called "Sponsor" and they are both referencing the same list called "Sponsor Values". The Sponsor column is also a multi-selection drop-down in both lists, so I need to copy over all values. The Sponsor Values list that is being referenced only has columns ID and Sponsor Name. I have a Power Automate flow setup that copies information between list A and list B, but the Sponsor field does not copy over. Can anyone help with how I need to go about doing this in Power Automate?
PowerApps customizing SharePoint form - Multiple lines of text column showing HTML
When customizing a custom list using PowerApps, my multiple line of text fields no longer behave as expected. In the forms they turn into single line of text and start displaying HTML in the output. I have managed to set the field behaviour to 'Edit multi-line text' which helps a bit, but it still returns HTML output, and there does not seem to be an option to have rich text editing in the new/edit forms. Please give me tips on how to work with multi-line fields using PowerApps for SharePoint lists. Also tell me if there is an option for using the normal SharePoint new form and just modifying the view form? ThxFlow save failed with code 'InvalidTemplate' and message 'The template validation failed:
What I want to do is the trigger should initiate When an item is created, it should automatically send out an email to the approver with options to approve or decline. Scenario A (App Approval): If the manager approves/declines from the app, the status will be updated in the SharePoint list. Power Automate should detect this update and send the respective confirmation email to the requester without waiting for action from the email. Scenario B (Email Approval): If the manager approves/declines from the email options, Power Automate should update the SharePoint item’s status and send the respective confirmation email. Workflow Steps I followed: Trigger: When an item is created in the SharePoint list, initiate the flow. Send Email with Options: Send an approval email to the approver with "Approve" and "Decline" options. Parallel Branch Execution: Branch 1 (Email Approval): Wait for a response from the email. If approved/declined, update the SharePoint item’s status accordingly. Send a confirmation email to the requester. Branch 2 (App Approval): Trigger: When an item is modified in SharePoint. Detect if the status has changed (approved/declined) from the app. Send a confirmation email to the requester. When I applied this I am getting this error [ Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Send_an_email_(V2)_2' at line '1 and column '7007' cannot reference action 'Update_item'. Action 'Update_item' must either be in 'runAfter' path or within a scope action on the 'runAfter' path of action 'Send_an_email_(V2)_2', or be a Trigger.'.'.]Capture Approval Comments from SharePoint Approval
I am using a SharePoint list for items that are being independently worked. Once the work item is complete an approval is sent for review. The approval request is done on the list with the built-in function not using power automate. How can I capture the approval decision, date and comments using the basic built-in function using power automate? I don't need to send an email. I cannot have the flow triggered on an item once it is created as the created item will be worked at a later time. I just want to capture data related to the approval decision.
File not found when doing Get File content in Power Automate
Good Day, Been researching this endlessly but no solution. I am doing a flow but when doing a Get file content in Apply to each, I get the error below. I am using Identifier from the Get file (properties) in my Get file content action. What am I missing ? Can someone please help. Many thanks in advance. "File not found clientRequestId: 83ed0d3e-d278-48f3-b3ff-a6662a4d68d7 serviceRequestId: 83ed0d3e-d278-48f3-b3ff-a6662a4d68d7
