Forum Widgets
Latest Discussions
Error when using MS Group Form for upload of files to Sharepoint List
Hi everyone. Task: I am trying to upload files from Group Form to a SP list. I set up the following Power Automate flow: step 1: (Forms) "When a new response is submitted" step 2: "Apply to each" (List of Response notifications Response Id) step 2a: "Get response details" ("Form Id": My group form), "Response Id": List of Response notifications Response Id) step 2b: "Create Item": Site Address: [Sharepoint site], List Name: [name of Sharepoint list where I want to upload MS Forms files to]. Matching all other required fields in Sharepoint list to MS Forms fields step 2c: "Apply to each": Select an output from previous steps: json() as expression, selecting "ID" as dynamic content within json paranthesis. step 2d: "Get file content": Site Address: Group Team where the Group form is residing. "File identifier": id (field from Forms) step 2e: Add Attachment: Site Address: [Sharepoint site], List Name: [name of Sharepoint list where I want to upload MS Forms files to]. Id: ID [from sharepoint]. File Name: name (from MS Forms). File Content: Body [from sharepoint] Scenario 1: I get an error when trying to execute, same error if 1 file uploaded or 2 files uploaded: (Fails in step 2b, "Create Item"): "OpenApiOperationParameterValidationFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/Title' to be a string of maximum length '255' but is of length '486' ". I dont understand why the full URL address AND the filename is returned, along with some other unreadable code as well. Scenario 2: If I change step 2b above for “item/Title” from using the File Upload MS Form field to a fixed text string like “Dummy title”, it fails, but now in step 2d, “Get File content”): { "status": 404, "message": "File not found\r\nclientRequestId: 15de2a9d-22a0-40f9-9b7f-924fa0706cb6\r\nserviceRequestId: 15de2a9d-22a0-40f9-9b7f-924fa0706cb6" } Any got any idea how to solve this? Seems I am not able to “capture” the file ID/name correctly?
Power Automate Assign Task Notification - Change Assigned by Name
I have a Power Automate Flow that reads answers from a Microsoft Form and assigns tasks to team members. They then receive an email that I assigned them a task. I don't want it to say my name but instead, something like Business Task Manager assigned you to a task. Is there a way to change this so it looks like that task assignments are not from me?
Stop trigger when receiving calendar invite for 'When a new email arrives in a shared mailbox'
I have created a flow which starts with the trigger 'When a new email arrives in a shared mailbox'. I would like to prevent this trigger starting the flow if I receive a calendar invite from any sender. I have tried and tested a couple options with co-pilot which did not work: Adding this function to the settings of the trigger '@not(equals(triggerOutputs()?['body/MessageClass'], 'IPM.Schedule.Meeting.Request'))' -> NO emails were triggering the flow any longer Using a condition with the following function: '@contains(triggerOutputs()?['body/Categories'], 'Meeting')' I am ideally going to avoid creating more steps in my flow, and instead working within the settings of the trigger. Please help! Below is the flow if at all helpful...
Limiting powerapps form person field to members of one sharepoint site returns no values
Hi there, I am working on an app, and I would like to limit the output on a Person field to only the Sharepoint Site Members. Whenever I go into the field in SharePoint and set the limit to our Sharepoint Group members in the List Settings, the dropdown does not show any results. How would I work around this, or what might cause this issue?
Email V2 not saving dynamic content
Hi, I am trying to set up a flow for when a guest completes a survey it will pull the info I want from the survey and send it to multiple people. When I try to add some dynamic content to the body of the email and click save it doesnt actually save it. Some of the questions save but others don't.Use dynamic content within If statement in expression in PowerAutomate
I am using Power Automate to save emails and attachments into a SharePoint Document Library. This is working well, and I now want to automatically apply metadata to the items that are uploaded. I want to check the Subject field of an email I receive and if it contains a keyword, apply that keyword to the sharepoint column metadata. I have more than 8 options so I can't use nested conditions (however using conditions DOES work). I am looking to use a switch case with nested if statements, but I am not sure how to refer to the "Subject" field inside an if statement. For example, in the "On" field in a switch condition: (screenshot below) if(contains(variables('Subject'),'jeff'),'1',if(contains(variables('Subject'),'josh'),'2', Is not accepted by the expression field. Any idea what I'm doing wrong?Power automate SharePoint list update
Greetings, I want my company SharePoint to show data (a priority list) from another companies SharePoint. I want to auto check for updates and changes as well. Can they give me permission to integrate the list on my SharePoint? Or would I need to copy the file, and then power automate so it looks for changes in their list and then updates my list accordingly?
