power automate

143 Topics

How to get Get Attachment into power automate
I created one Sharepoint list and that list having attachment column. I need to get that attachment content and details when any items created or modified into list from power automate. I tried some flow like "Get Attachment" or "Get File Content" etc. But I got the message file not found so please let me know the step by step for getting attached in power automate.
himanshue2logy
Nov 04, 2020 Place Power Apps and Power Automate in SharePoint
72KViews
0likes
3Comments
Power Automate – Copy files from SharePoint to a local system folder
Hi Team I want to copy files from a SharePoint Online document library to a file system on a local machine. I am using Create File action to create files and move to local machine. It may fail sometimes because of large file size and length of file name exceeding the limit. How can I capture those filenames which were failed in a string or array and reason for failure? Please help me on this issue. jcgonzalezmartin Norman Young RobElliott Thank you.
MadhusudanShettyMS
Apr 28, 2020 Place Power Apps and Power Automate in SharePoint
48KViews
0likes
7Comments
SharePoint is missing "Move to..." option. "Copy to..." is still available.
Dear Tech Community, one of our SharePoint sites is setup to function as a archive. There is a library called "Inbox" where archived projects are moved to and from there on they get prepared and final moved into a library called "Archive". Currently we have the issue, that two projects aren't moveable, but they still can be copied: Other folders going through the same workflow are moveable: First I thought, that the workflow moving the folders into the "Inbox" messed something up. But after trying several scenarios I was able to exclude the possibility of the workflow messing something up. I'm also the owner of this site and library, I have no clue how I can't have the permission to move a folder. Copying isn't an option, due to loss of document history. Can someone help? Thank you, best regards Saša
Solved
Sasa_Ivosevic
Jan 17, 2023 Place SharePoint
46KViews
0likes
4Comments
'OpenApiConnection' is not valid
Hi everyone, I am new to power automate, l am trying to migrate data from a SQL table to a SharePoint list using power automate, one of the fields keeps throwing an openApiconnection error. it is a lookup field in SharePoint however in Microsoft flow it's expecting a lookup ID of the field. how do l go round solving it, please..... The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Project/Id' is required to be of type 'Integer/int64'. The runtime value '"743: Carefirst replacement / Eclipse - Phase 1: Adults"' to be converted doesn't have the expected format 'Integer/int64'.
KeithMontana
Jun 24, 2021 Place SharePoint
21KViews
0likes
1Comment
Add Button to SharePoint Form JSON
I maintain a SharePoint list at work, and I would like to create some buttons on the Edit and Display item forms for common quick actions which involve updating data in several fields / columns. I've tried a few approaches: I have a Power Automate flow for each quick action, and I can currently use these flows from the right-click menu when I'm looking at the SharePoint list, but I can't use them when I have the item open and am looking at the Edit/Display form. I was able to make a custom column on a test list that could set other values in the item, but it also wasn't actionable from the Edit/Display Form. I have the Edit/Display Form configured using the options described here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration. The idea is to add button elements to the header, with the customRowAction of "executeFlow" (or set Value-- tried this too but no luck). I created elements on the Edit Form that look like buttons, that show up where I want them to, the way I want them to, when I want them to. However, clicking them does nothing. Based on everything I've tried so far, I think the json & Flow setup is correct, but so far nothing has transferred to the list forms. I know Power Apps is an option for this, but I would prefer to avoid re-building the current JSON formatting for the list forms in a new place if I can, since the overhead there is much higher. Is there something specific I need to do differently to make buttons work on the list forms? Alternately, is there a way to pull the existing JSON-formatted list forms into PowerApps to start with as a base? Below is what I have in the header JSON to define one of the buttons (edited out work-specific info for obvious reasons). The button is conditionally visible to me & another user who was helping me troubleshoot, depending upon the status of the item, and the flow ID is just taken from the flow URL. The visibility works fine, but clicking the button doesn't do anything. { "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json", "elmType": "button", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"<the flow ID>\"}" }, "style": { "border-width": "1px", "border-radius": "20px", "width": "225px", "margin": "2px", "box-shadow": "1px 1px SlateBlue", "border-style": "solid", "border-color": "SkyBlue", "background-color": "LightSkyBlue", "color": "MidnightBlue", "text-align": "center", "font-size": "16px", "cursor": "pointer", "visibility": { "operator": "?", "operands": [ { "operator": "&&", "operands": [ { "operator": "==", "operands": [ "[$Technical_x0020_Reviewer_x0020_D]", "" ] }, { "operator": "!=", "operands": [ "[$Status]", "Rejected" ] }, { "operator": "!=", "operands": [ "[$Status]", "Approved" ] }, { "operator": "!=", "operands": [ "[$Status]", "Approved, Won't Be Updated" ] }, { "operator": "!=", "operands": [ "[$Status]", "Abandoned" ] }, { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@me", "<my email>" ] }, { "operator": "==", "operands": [ "@me", "<other work user>" ] } ] } ] }, "visible", "hidden" ] } }, "children": [ { "elmType": "span", "attributes": { "iconName": "SkypeCircleCheck" }, "style": { "padding-right": "6px", "color": "AliceBlue", "text-align": "left" } }, { "elmType": "span", "txtContent": "Mark Technical Approval", "style": { "padding-right": "6px" } } ] } I've also tried making it into a "set value" button instead, but no luck with that either.
Solved
Annika_Morrell
Sep 02, 2022 Place SharePoint
19KViews
0likes
5Comments
Populate a date column automatically
How do I populate a date column automatically when the status field is changed to "Implemented" with a Sharepoint List? I am new to using PowerAutomate, and I am trying to have the project close date automatically populate to "Today's Date" when the status field has moved to Implemented. It doesn't seem to work, and the field is not updating after testing. The following error message is coming back after testing. Message: ActionDependencyFailed. The execution of template action 'Update_item' is skipped: dependant action 'Condition' completed with status 'Failed' and code 'BadRequest'. What am I missing?
Solved
Sharepoint_Chris
Jan 03, 2022 Place SharePoint
18KViews
0likes
10Comments
Can Power Automate auto print outlook attachments?
Hi everyone, If Power Automate support auto print email attachments ? Scenario: I have a customer always send purchase order list to me (*PDF) , I have set an outlook rule that to Move his orders to a folder. Everyday I check this folder to see any new orders coming, then print it. Try to see if Power Automate can support any new email came to this folder and directly print it.
Luke_Lee
May 11, 2021 Place Power Apps and Power Automate in SharePoint
14KViews
0likes
3Comments
Retrieve Full Page Body of SharePoint News Page with Power Automate
I have a SharePoint Communication site with a News webpart set up. In Power Automate, (when I try to pull in the News page body) the only field for the body of the text I am able to access is the 'Description' field (which is capped at like 250 characters). Does anyone have an idea on how I can pull the entire page body into power automate?
Solved
Boe_Barlage
Feb 01, 2022 Place Power Apps and Power Automate in SharePoint
13KViews
1like
3Comments
How to create a automate flow which fetch's the data of users from azure active directory
Hi All, I am new to Power Automate however, I want to know is there any way to create a automate flow which will fetch the data of "All" users from Azure active directory. Goal: An email should be trigged to a particular team after the termination/offboarding of an employee through power automate. We disable the user's account from AAD by setting 'accountenabled: No' Please help 🙂
shamuvel
Jun 28, 2023 Place Power Apps and Power Automate in SharePoint
13KViews
0likes
1Comment
Concatenating Multi-Choice Field
I have a modern Sharepoint list with Fields including: Speciality - Choice (Multiple selection allowed) SME - Person I'd like to concatenate them into a single line of text. I can't use the Calculated column I believe due to the multiple choice. I tried Flow but really struggling to get anything to work as I keep getting 'Apply to Each' and it won't let me extract the data. Anyone have any suggestions? Many Thanks
jawilson
May 15, 2020 Place SharePoint
12KViews
0likes
3Comments