Power Automate Search
Search
Using "For Each" action to loop through matching emails to save attachment & process data
CommunityHello, I have a process where I need to: 1. look for specific emails based on subject heading 2. download the specific xls attachment 3. process data from it 4. delete file from folder ...
Re: get dial in conference number fo send it in sms
CommunityHi @Sumaira, It is a audio conferencing feature of Microsoft Teams, which also requires additional licenses. Just to double check, do you have that feature available ...
Re: Extracting values from an OData response and formatting my current response to be JSON Array?
CommunityHi @RezaDorrani Thank you for the guidance. I have managed to get to a point now where I can convert the output into an array, however, when I r etrieve d the value s from "@o...
Re: Find Substring in a String
CommunityThank you @VictorIvanidze I did look at the documentation, but if you have never done anything like this before, I does not help! I'll mark you solution as closed, and try and figure o...
Re: Date Conversion error - worked fine yesterday?
Communityright you are! thanks! i didn't even think to look for a change to the connector...
Re: Populate a Sharepoint List or Excel file based on other Sharepoint List
CommunityForget it , it works, thanks a lot!
Re: Populate A Word Template - Please Make Sure The Size Is Less Than 10MB
CommunityConverting to a PDF is making it smaller via greater image compression. Word isn't doing that. I'd be tempted to use something like https://kraken.io/ to reduce the size of the images...
Re: Unable to figure out how i can add a new line inside string variable
CommunityHi @johnjohn123, Yes, I tested it first before I posted this possible solution 🙂 What kind of SharePoint column are you using, multiple lines of text? My test...
Re: Remove/Delete Completed Tasks in Planner
Communitywill this delete about 1000 tasks? I think I tried this but it was not deleting when the tasks are more than 400.
Re: Bulk email (20,000+) with Delay action
Community@Poobana are you getting items from SharePoint list to retrieve the items, if yes, then you can use filter query on the Get Items action to fetch only those items whose Expiration Date is today...
Re: subtractFromTime not working
CommunityIts a very simple fix. You overlooked that you are writing the formula as JSON so it needs to use 'Day' not "Day". Change the double quotes to single quotes and it will work. I miss...
Re: Azure DevOps - Queue a new build
CommunityWhats the best way of setting the variable value to complete? Do I need to run a POST to Azure DevOps to determine the build has finished. Ideally I don't want to just add a default wait time out of ...
Re: Invalid template error
CommunityThank you, that explains what happened with my flow. My question now is how can I get the date in a different format now. This is what I am getting now 2021-01-20T00:00:00.000Z I would like...
Re: Convert True and False to Yes or No in Power Automate
CommunityThank you @VictorIvanidze Also, try your expression and got the following error. The execution of template action 'Create_CSV_table' failed. The column values could not be evaluated...
Re: Undo Option for Flow
CommunityWell... just to inform that we are now in 2021. This should be the TOP priority, it is unthinkable to have no Undo here and having one in SharePoint pages. P.S: I also just discovered this ...
Re: SharePoint Array - parsing out unique categories, and finding the minimum date for that category.
CommunityHello @Skiroy , you have the project groups stored in the array, so to process them one by one you will use 'Apply to each' action. Inside this 'Apply to each' you'll use the 'Get items' ...
Combine multiple Sharepoint list into a csv table using flow
CommunityHi. I have a Master Sharepoint list ID -: Number Asset ID-: text Owner Name (Person field) Child list MasterID Environment (Choice field) RiskRating(choice field) ...
Re: Comparing Results From Choice Field On Form
CommunityHi Jdoss, That's where I am heading but I don't know what action type to choose to do this. I have a condition, but whatever I put in the boxes does not seem to work.
Outlook attachment Json data to Sharepoint list not working
CommunityIt seems that it should be working, I have set a flow to get the Data from the (Json) attachment and transfer the data to a Sharepoint list, however I keep getting the following error: ...
Re: Comparing Results From Choice Field On Form
CommunityCan you share a screen shot of the flow in edit mode? These are examples, the #5 in the condition is a question on the form.
Re: Email notifications from shared mailbox permissions
CommunityHi @sama0018 , You may deploy the PowerApps and Power automate within a solution. Then, the normal user can't see the Flow from the My Flow/Shared Flow list. Bes...
Change the owner and connections of Power Automate Flow
CommunityI understand we can add owners on owners of flow page, but it seems the creator of the flow cannot be removed as the button is grey. Besides, if we change the owner and also want to change the connec...
Re: Send an email (v2) dynamic email body depending on current day
Community@nagestiada , Yes, it is possible, but you need to dinamically create your HTML code for email body. You can use PowerAutomate variables, something similar to: ...
Power Automate - missing Site Address from drop down
CommunityI have searched and only found 1 post about a missing SharePoint site from the drop down. While I can enter a custom value, I'd prefer not to have to do this every time I created an ac...
Need help. Can't count file item when get file from sharepoint.
CommunityPlease help to fix this flow. I can't count file item when get file from sharepoint. This is my flow and error.