Power Automate 搜索
搜索
Re: Convert CSV to Excel Power Automated
社区@rpskt As of now there is no free way to convert CSV into Excel in MS Flow. But someone suggested in this thread- https://powerusers.microsoft.com/t5/Building-Flows/Help-with-convert-excel-ba...
Birthday Wishes with birthday card image
社区I have created a birthday wishes flow but wanted to send the image along with the birthday wishes from DL instead of my email. Please help me how to proceed. My requirement: From ID sh...
Re: Hidden TypeForm Fields Not Showing
社区That is strange, since you use the specific Response Submission ID in the http call, right? You might want to check and re-check since there are quite a number of dynamic values that bear some resemb...
Re: How to use FOR EACH in a CSV Table
社区Hi @iwend, I think you should create 10 condition actions to create the replicated file if the PN column has value, steps as below: 1. Get files, and create an Apply to...
Re: Is there a way to get an attendance list from a Teams meeting organized a shared mailbox using power automate
社区I don't see any connector or action which will help you get attendance list but you can get delegate access to your shared mailbox and then try downloading the report you want. Check this ou...
Re: Move File Error
社区Hi @ClaireAllen, It is caused by the destination library is lack of "DocumentCategory" field which type is Choice. When we move files from a library to another library, t hese field n...
Populate Word Template and Format Bulleted List
社区I'm building a Flow that populates a Word template, and I'm conditionally appending text to a string variable to use in the document (I'm creating letters that have content that changes based on cert...
Re: Help stop the Save button from closing my form
社区My apologies, like a total newbie I posted the above message in the Power Automate community instead of the Power Apps community. I will appreciate it if a moderator/admin can please remove this post...
Re: How to update a sharepointlist item when a secondary sharepoint list item is changed
社区You can write a Flow using the Update trigger on the value list and then use GetItem and filter query to filter the ite from ProjectList where Project matches the value from the trigger. Finally, use...
Re: Can't filter data in Get Rows using a date column.
社区Thanks for your help. This was getting a little crazy just trying to match two dates, should be much easier. I bailed on this approach and created a view in SQL that added a column ...
Re: Dealing with Excel boolean value
社区Hello @AndyJ42 , try to add a 'Compose' action before the condition to see what values the 'Emailed' column returns. I just did a quick check and the values are 'True' and 'False', that me...
Re: How can i remove folder permissions in Sharepoint for Sharepoint Group? For 0365 Group?
社区It is to remove permissions from a folder inside a document library. _api/web/lists/getByTitle('[LIBRARY NAME]')/items([FOLDER ID])/roleassignments(10) After modification to use the folder path it ...
Re: How does licensing work with the Unattended RPA Add On?
社区Hi Drake, From my experiences, when working with unattended robots and the licenses for doing it. The company should create another account which is a Shared account, and the license should ...
Get items Order By using Day from Date
社区Hi community, Is there a way to Order/Sort the Get Items from a SP list based on the Day in a date? I'm creating a HTML table of Birthdays for the Month and sending via email. T...
Re: Created Date
社区Sure, here is what the flow looks like and the error I'm getting - formatDateTime(body( 'Get_items' )?[ 'value' ], 'yyyy-MM-dd HH:mm' )
Apply to each first 3
社区Hi, I have a flow that collects data from a form and adds rows to an excel file. In the form there is a multiple choice question with 10 values, for each value chosen in that question, a new...
Error Handling for Triggers
社区It is important to note that a lot of flow errors can happen at the trigger stage, however, there is no way to know this especially if the flows are under a Solution. Ideally, the way to go around th...
Re: Shifts To Office365 Outlook Calendar Automatization
社区@Tobias90 It should take the name from the marked field in the picture above. Does this help?
Sum an array column
社区Hi I have an array that I have created within my flow, I'm trying to find a solution to sum the values in the first column (as per image) to provide a total value. Is this possible? &...
Re: Dealing with Excel boolean value
社区Hello @tom_riha , thank you for your reply. I tried this, the Compose returns "true", but when I put the condition equal to "true", it's returning false:
SharePoint REST query on flow not work
社区Hi How can I let the Item() can get the record base on RefID but it show the error: The parameter name RefID is not valid. The Comments SP list's item ID is not same as the variable "ItemID...
Re: different action depending on dropdown text
社区Hi @UCdr , In flow add a switch action based on your dropdown value and create cases for your dropdown values. In each case you can execute your actions. -------------...