This is awesome!! What if I wanted to update an indicator stating the email had already been sent without causing an infinite loop? Where would I put the condition to initially test for the indicator, and how would I update it?
Can you help me convert this video content into a table format? I mean, when I receive an email in a table view , I want to store the same format Columns in a SharePoint list or Excel, with columns and different rows. I’ve tried several times but haven’t been able to do it. Please help me out.
Thank you, but i am notable to see relations though i have two attachments in ADO, do you know why? is there something Org will have control to hide the attachments in API?
Very useful thank you. I needed to send data (including attachments) from a PowerApp into a list and then completely cleanse that data, of the person who submitted it, by sending everything to a second list before emailing the submission (including attachments) to a third party. The transferring of the attachments was the last piece of the puzzle and this video solves that.
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
Hi You need to use union() expression to get all the owners first. Then do filter based on each owner will get you their own records. Form that find the manager name do another union() expression to get unique managers (Removing duplicate names). Do the same for functional manager too. Finally you have a set of managers and functional managers email address you can use in your email action step. If you need further help in this please let me know. Thanks
Thanks for the video... But how does the extracting approvers work if the amount is 1500... It will still give you multiple approvers right? Based on the first logic (trigger amount is less than or equal to approval config amount) , it will extract both the line items is 2000 & 3000. Now based on second logic ( output from first ---- > config amount greater than or equal to trigger amount) it still gives the same 2000 n 3000 as answer... Am I missing something here? Please help.
Hi Satish I got two filters. First one is less than or equal to. Then I got second filter greater than or equal to. Have a look on those two filter action steps. Thanks
GREAT VIDEO. I am wanting to extract the last word of a line within the text. currently I am using last(split(outputs('Converted_Data')[6],': ')) but this displays the entire line of text when i only want the last word in that line
@@abm4975 the data is: " * Location: THURS Morning - Prestart 6:30AM - At: - Sandercock Park - Gold", " Coast Hwy at Paradise Ave, Mermaid Beach (320) (3D Job) (F/Move 10AM) (", " Ammar), QLD", I want to extract the last piece of text QLD, but this value can change.
You can’t sign in because this app sent an invalid request. You can try again later, or contact the developer about this issue. Learn more about this error If you are a developer of this app, see error details. Error 400: redirect_uri_mismatch Power automate have different email id register and gmail is other email address how to mange this ?
Hi Is that two different emails. Then you need two different flows as trigger referring to those emails. Store the body in OneDrive or SharePoint. Once you received both then you can compare the body. You need three flows to achieve this. Thanks
Hi. I want to write a flow where I want to copy work items in one DevOps project to another devops project. While copying the fields are straight forward, how to I fetch the attachment list from the work item and copy them to another work item? Please advise
Hi @sudhindrak01 I made a video regarding this. Please have a look and comment. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tHHkrydI8xk.html Thanks
Hello, thanks for the very detailed explanation. At 21:46 when you discovered something not quite right, what was it that you corrected? I am stuck at this. Thanks very much for your advice.
So for me I already run the flow in my prep video. Then when I start using the same data Dept excel sheet is already created. For the demonstration purpose I did changed the dept name. In your case close the browser sessions and leave it for few minutes. Then run the flow. It won't get locked. If you need further help in this let me know. Thanks
@@abm4975 Just to add, I managed to create the new department files but their contents were empty. I wonder if it has anything to do with the filter array output returning Body[].
Hi Sarah I need to check your flow. Could you check my channel about section. Send me an email. I could offer a screenshare help to progress this. Thanks
Hi Follow the below steps: Use the Get Files (properties only) Set your library name, folder and say include nested items Yes Under the Filter Query use FSObjType eq 0 This will get all the files only not any subfolders. Then use the delete file and use the identifier from the previous step to delete the file.
Different ways you could do this. Easiest way is read all the rows using list rows. Before the list rows declare a variable called Total as integer. Once the list rows are done add a compose and add an expression add() here map the excel value and the variable Total. Then again inside the loop use Set variable to map the output of the compose. Finally outside the loop you can use the Total variable which will be the sum of the column values of all the rows. Thanks
Hi this is sivaji , I need help to create flow Scenario: Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
Hi You need to get the emails first from the excel. For this you need to use union() expression to get all the unique emails after reading the Excel sheet using List Rows. Next iterate the results of the union so that you get each email and use the Filter action step or List Rows with filter query matching each email. Next you can use this result to use the Select actions step to select the values which you want to email. Finally map the results from the select action step in your email. Thanks
Hi this is sivaji , I need help to create flow Scenario: Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
Can you maybe do this question from the powerplatform forum: I have the flow which getting two set of data from two table (which are stored into two different excel files) and I want to merge the two into a single table by appending the data from the table in excel file two into the table into excel file 1. Both of them have one common primary key which is unique (an e-mail adress) I want combine both table into single table for each row return from the table in the second excel file, I tried with a for loop but could not make it work. Any solution on my problem here? Any help will be great.
Hi Can u use the same for SharePoint for creating the Excel sheet without using one drive It Is possible to do it that way Trying to help me out is some emergency
Hello, I have a folder in which sharepoint reports are created every week and I want to get the latest one created with this action. Do you know which filter query I can use for this? Thanks for the tutorial :)
Hello excellent tutorial, I just tried the flow exactly as you have it. It currently runs successfully but I'm not getting the actual attachment on the email. The attachment type for my share point list is a "word" document. I'm just getting the email with no attachment, any feedback?
Hi Thanks for your kind comments. I need to see the flow. You can connect me via email. Its in my Channel about section. Send me an email and I could check this via a screeshare if that helps. Thanks
Try the below: Power Pages Management > Basic Forms > Open your form > Select Basic Form Metadata > Click New Basic Form Metadata Select the Type as Attribute. Control Style as Multiple Choice > Select Attribute logical name - Here select your multi-select field name.
Hi, I have a scenario like can you please help me I will be receiving emails from specific people with a specific table in the body of the email. I wanted power automate to copy those tables and paste it in a Excel sheet Can you please help 😊
Hi Have a look at this blog. tomriha.com/parse-data-from-an-html-table-in-an-email-with-power-automate/ Also there are few videos out there regarding the same subject. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-i4GHCGMAD88.html Thanks
Hello @abm abm! I really appreciate this video leveraging Microsoft Graph API along with many others you’ve created!! I have a question to potentially use Microsoft Graph API: I’d like to get the link to an open (non-submitted) adaptive card and share this link via email? I have tried first posting the adaptive card and in a parallel branch create the expression in a compose action -- outputs('Post_adaptive_card_and_wait_for_a_response')?['body/data/messageId'], but when I test the compose, my compose is blank, which I imagine is because the adaptive card is not complete/submitted. I believe it’s possible to dynamically create the adaptive card link using Microsoft Graph API to get the Message ID for the adaptive card, but I don’t have too much experience with using Microsoft Graph API and would be MOST grateful for your support! 😀
Hi @gavinobrien5361 Thanks for the comment and support. An interesting question you asked. Its client side you generate the adaptive card. Tell me more about you create using the designer or not? Not sure we can store this in a profile?
Hi Thanks a lot for your comment. I have checked the video and it looks ok to me. Once you start playing the video check the settings > click quality > set to high resolution (1080p). Let me know how it goes. Thanks
@@abm4975 Thanks a million bro. May GOD Bless You abundantly! I am now able to follow the video as the quality of improved on my screen. Your Video is exactly the guidance and teaching I needed to complete my current project. You have just captured a new follower, ha, ha ,ha! 😃🙏
Hi Thanks for your reply. Glad that all sorted. Any questions regarding Flow, Power Pages and Model Driven Apps let me know. Glad to help the community. Wishing the best.
The issue is HTTPS step isn't working as it is giving me the below error. Can you create a video which will bypass https steps and everyone can use it? Also if you could show us with dynamic sheet names that'll help us a lot as most of us wouldn't have fixed sheet names. Failed to create connection for connection id '/providers/Microsoft.PowerApps/apis/shared_webcontents/connections/shared-webcontents-ecd35c89-7b7b-496c-9556-dc1e6cdc4e69'. Connection creation/edit of 'shared_webcontents' has been blocked by Data Loss Prevention (DLP) policy 'Productivity Policy'.
This is great thanks. One issue - when my email sends, the attachments become unformatted- so if it was a PDF it comes as a big blob of characters rather than retaining the original format. For a text file I get all the markup showing like \. What am I missing?
Hi Andy I need to see the flow to determine what's going on. Check my channel about section and connect me via email. I could check via a screenshare and see. Thanks
Thank you for this breakdown! How would I modify this to move files from sharepoint to a onedrive folder instead? I have a similar naming situation and I tried setting up everything the same way but didn't find an equivalent onedrive action to "create new folder". I found a one drive equivalent to "get file content" and "create a file" but something isn't working. Thank you!
Yes for the OneDrive when you create the file you can pass the dynamic folder name. It will automatically create the folder. If you need any further help in this please let me know. Thanks
Hi, I would like to ask, how can the unique code in the email subject (e.g., 00015) be used as a trigger to find a folder with the same name in SharePoint? 1. Email arrives (with the unique code in the subject). 2. Save the email and attachment as a .eml file. 3. Save the .eml file in a folder that already exists in SharePoint, with the folder name matching the unique code in the email subject. I greatly appreciate the information you are going to provide
Hi Thanks for the question and support. Follow the below steps: 1. After the outlook trigger, add an action step called Create new folder. 2. Next action step Export email. Here pass the Message ID from the trigger. 3. Finally use the create file to save the email body to the specified folder we created earlier.