- 148
- 1 342 664
abm abm
United Kingdom
Registrace 22. 06. 2014
Welcome to my Power Automate tutorial channel.
If you find these tutorial videos are useful please share & subscribe my channel.
Any question related to Power Automate post in Microsoft Power Automate community and tag me (@abm).
Microsoft Power Automate Community Profile
@abm
powerusers.microsoft.com/t5/user/viewprofilepage/user-id/2721
Microsoft Power Automate Community Channel
powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Twitter:
mydevexperience
Websites:
mydevexperience.wordpress.com
www.powerautomatetraining.co.uk
If you find these tutorial videos are useful please share & subscribe my channel.
Any question related to Power Automate post in Microsoft Power Automate community and tag me (@abm).
Microsoft Power Automate Community Profile
@abm
powerusers.microsoft.com/t5/user/viewprofilepage/user-id/2721
Microsoft Power Automate Community Channel
powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Twitter:
mydevexperience
Websites:
mydevexperience.wordpress.com
www.powerautomatetraining.co.uk
Power Automate - How to capture SharePoint Trigger based on a particular column modification only?
This is based on a community question about how to capture SharePoint trigger based on a particular column only?
powerusers.microsoft.com/t5/Building-Flows/Flow-to-be-trigger-when-status-changes/m-p/2800708#M314652
Expression used in this video.
@and(not(equals(triggerOutputs()?['body/Last_x0020_Update_x0020_Status/Value'], triggerOutputs()?['body/Status/Value'])),or(equals(triggerOutputs()?['body/Status/Value'],'Approval In Progress'),equals(triggerOutputs()?['body/Status/Value'],'Approval Completed')))
powerusers.microsoft.com/t5/Building-Flows/Flow-to-be-trigger-when-status-changes/m-p/2800708#M314652
Expression used in this video.
@and(not(equals(triggerOutputs()?['body/Last_x0020_Update_x0020_Status/Value'], triggerOutputs()?['body/Status/Value'])),or(equals(triggerOutputs()?['body/Status/Value'],'Approval In Progress'),equals(triggerOutputs()?['body/Status/Value'],'Approval Completed')))
zhlédnutí: 582
Video
Power Automate - Community Question - How to iterate files from doc library including sub-folders?
zhlédnutí 222Před měsícem
This video is based on a community question - How to iterate files from doc library including sub-folders? powerusers.microsoft.com/t5/Building-Flows/Updating-quot-File-type-quot-column-for-existing-files-in/m-p/2798705#M314440
Power Automate - How to auto increment an id when a new item is added - Community Question
zhlédnutí 296Před měsícem
This video is based on a community question 'How to auto increment an id when a new item is added' powerusers.microsoft.com/t5/Building-Flows/How-to-auto-increment-an-id-when-a-new-item-is-added-calculated/m-p/2793921#M313995
Power Automate - How to filter Excel rows and create new excel files and contents based on a filter?
zhlédnutí 1,1KPřed měsícem
This video explains how to filter Excel records and create new excel file and contents based on a filter? Community Thread: powerusers.microsoft.com/t5/Building-Flows/bulding-flows/m-p/2777540#M312343
Power Automate - Community Question - Read Excel Column name with special characters
zhlédnutí 600Před 4 měsíci
Power Automate - Community Question - Excel Column name with special characters This video is based on a question from Power Automate Community Forum. powerusers.microsoft.com/t5/Building-Flows/Add-row-to-excel-worksheet-missing-values-items-code-x-003a/m-p/2673445#M299587
Power Automate - Community Question - Metric Totals
zhlédnutí 256Před 4 měsíci
This video is based on a Power Automate Community question powerusers.microsoft.com/t5/Building-Flows/Desperate-for-some-brainstorming-or-help/m-p/2663339#M298546 Expression xpath xpath(xml(outputs('JSON_For_Each_Month')),concat('sum(/root/',outputs('Each_Month'),')'))
Power Automate - Community Question - Read Excel sheets based on email subject
zhlédnutí 706Před 5 měsíci
This video demonstrates how to read the excel files dynamically based on email subject. powerusers.microsoft.com/t5/Building-Flows/automatic-email-response-for-a-multiple-criteria-in-subject-s/m-p/2604075#M291698
Power Automate - Approvals without using emails - Deep Dig
zhlédnutí 573Před 5 měsíci
This video explains how to approve Power Automate approvals without emails. Explains how to approve the approvals from a custom application.
Power Automate - How to send email with category using Graph API
zhlédnutí 836Před 6 měsíci
In this video I will show you how to send email with category using rest api Graph API
Power Automate - Microsoft Forms upload documents and attach to SharePoint Document Library - Part I
zhlédnutí 1,6KPřed 7 měsíci
This video explains how to get Microsoft Forms documents and attach to SharePoint. Power Automate Community thread: powerusers.microsoft.com/t5/Building-Flows/Save-forms-attachments-to-a-sharepoint-location-with-matching-ID/m-p/2487920#M278149
Power Automate - How to retrieve more than 5000 records from Dataverse?
zhlédnutí 1,3KPřed 7 měsíci
This video explains how to retrieve all records from Dataverse. Please see below blog about change limits in Do...Until loop nishantrana.me/2022/06/06/change-limits-in-do-until-control-power-automate/
Power Automate - SharePoint DateTime Null value update. New designer bug?
zhlédnutí 1,8KPřed 8 měsíci
I believe this is a bug using the new designer of Power Automate regarding the null expressions. Update SharePoint DateTime column with null values.
Power Automate - Community question JSON Filters
zhlédnutí 446Před 8 měsíci
This video is based on a Power Automate community question related to JSON Filter. powerusers.microsoft.com/t5/Building-Flows/Merge-2-SQL-get-RowsV2-Results-using-power-automate/m-p/2474570#M276558
Power Automate - Community Question - SharePoint move files based on specific rules
zhlédnutí 1,3KPřed 8 měsíci
This video explains how to move a file based on specific rules. powerusers.microsoft.com/t5/Building-Flows/Sorting-files-based-on-file-names/m-p/2456180#M274446
Power Automate - Community question related to arrays
zhlédnutí 427Před 8 měsíci
This video is related to below Power Automate community thread. powerusers.microsoft.com/t5/Building-Flows/How-to-use-information-from-Get-user-profile-V2-that-is-in-an/m-p/2451417#M273911
Power Automate - Parse JSON Action Tips
zhlédnutí 3KPřed 8 měsíci
Power Automate - Parse JSON Action Tips
Power Automate - How to upload a file using PipeDrive API?
zhlédnutí 1,2KPřed 9 měsíci
Power Automate - How to upload a file using PipeDrive API?
Power Automate - How to access Open AI API chat completion via Power Automate?
zhlédnutí 966Před 9 měsíci
Power Automate - How to access Open AI API chat completion via Power Automate?
Power Automate - How to update SharePoint Created, Created By, Modified, Modified By Fields?
zhlédnutí 3,5KPřed 9 měsíci
Power Automate - How to update SharePoint Created, Created By, Modified, Modified By Fields?
Power Automate - (Community Question) Filter Owner records from Dataverse
zhlédnutí 577Před 9 měsíci
Power Automate - (Community Question) Filter Owner records from Dataverse
Power Automate - How to retrieve SharePoint List history?
zhlédnutí 1,4KPřed 10 měsíci
Power Automate - How to retrieve SharePoint List history?
Power Automate - SQL Deletion Trigger using Power Automate
zhlédnutí 654Před 10 měsíci
Power Automate - SQL Deletion Trigger using Power Automate
Power Automate - How to filter multi-select choice values from SharePoint using single expression?
zhlédnutí 2,2KPřed 11 měsíci
Power Automate - How to filter multi-select choice values from SharePoint using single expression?
Power Automate - Community Question - Filter and find top scores from multiple lists.
zhlédnutí 378Před 11 měsíci
Power Automate - Community Question - Filter and find top scores from multiple lists.
Power Automate - How to retrieve SharePoint list attachments and send email?
zhlédnutí 11KPřed rokem
Power Automate - How to retrieve SharePoint list attachments and send email?
Power Automate - Community Question - How to update a row of dynamic Excel file?
zhlédnutí 6KPřed rokem
Power Automate - Community Question - How to update a row of dynamic Excel file?
Power Automate - How to update a SharePoint choice column using REST API?
zhlédnutí 2,4KPřed rokem
Power Automate - How to update a SharePoint choice column using REST API?
Power Automate - How to remove top few lines of an excel file that does not have a table?
zhlédnutí 836Před rokem
Power Automate - How to remove top few lines of an excel file that does not have a table?
Power Automate - Community Question - File Filter, Content and Delete Files
zhlédnutí 554Před rokem
Power Automate - Community Question - File Filter, Content and Delete Files
Power Automate - How to filter calendar events filtered by categories (single/multiple)?
zhlédnutí 2,3KPřed rokem
Power Automate - How to filter calendar events filtered by categories (single/multiple)?
Thank you brothers. helping a lot for beginners like me
Can you help on the issue that I am facing this error while selecting the table name from one drive - Could not retrieve values. The dynamic invocation request failed with error:
Thanks for helping. I am getting error - Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'For_each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'. while I follow the step and I am getting email with True or False jpg images(not able to open the images also). How can I make it work.
Thanks!
Welcome!
Worked great. Thanks! God bless!
Glad it helped
Do you know how I can create a way to do the following 1. When an item is created or modified in a sharepoint list 1a. Filter if a condition is met (if information found in column is not "information Correct" and Email Required column is set to "yes" 2. Take column information (choices) that has multiple choices inside that column "Correct Information, Address Incorrect, Not Found, Location Incorrect, Panel Closed etc, 3. Attach a form 4. Send an email to x I want to do this for multiple columns that contain information, and each column has a unique email recipient
I did not know god can be in a youtube video. Thank you god.
hahah. Thanks for the nice comment.
How to update values by dynamic content .. I tried it is now working by if I give mail manually it works
I was about to go crazy jaja, but this helps a lot! thank you!!!!!!!!
Thanks for the comment.
This is the best tutorial! Exactly what I needed and it all worked for me! Thank you so much!!
Thanks a lot
This was exactly what I was looking for! Thank you!
You're welcome!
Hi. I still have the attachment issue. also tried the "update" in the video comments. unfortunately having the same result. i appreciate if you may support me on this
Hi; this works great and was able to get it working - but what about when you delete an Item from the list? it will not recalculate the total. (unless you go in to another item and force an update) - is there a good why to ensure users don't need to do this; as there is no way to know if it has been done
Does this work with a Shared Inbox? I cannot seem to get it to work.
Hi David Thanks for the question. I thought it should. I haven't tried that. What error are you getting?
Hi..im trying to create a similar flow, but when i build it the approval is not directing to the person email. Could you help me out?
Thank you so much! Why didn't I search the net before waisting hours on this bug?!
Thanks
You are a genius! Thank you for this simple guide to get this done.
You're welcome!
I am getting ECONNRESET error when trying to execute the mentioned GET and POST calls..can anyone help me out here please
The ECONNRESET error stands for "Error Connection Reset." Check your firewall.
Hi, Great content. Do you have any recommendations for searching an existing SharePoint List that has duplicates? I normally update my list is batches not one row at a time. Do you have any recommendations for that scenario?
Wonderful! THX!
Glad you like it!
I have trying to understand how to extract formatted data from an email. You nailed it. Thank you!
Glad it helped!
Hi Your videos are really helpful I am struglling to create flow for below data CNo Inv No Amount Email CC Due date Status 101 521 231 11.07.2024 X 101 522 232 11.07.2025 X 102 523 233 11.07.2026 X 103 524 234 11.07.2027 X 101 525 235 11.07.2028 X 103 526 236 11.07.2029 X 103 527 237 11.07.2030 X 104 528 238 11.07.2031 X 102 529 239 11.07.2032 X 101 530 240 11.07.2033 X I want to send email for overdue invoices to Customers such that invoice belonging to one CNO are sent in one email-to email listed in Email and CC column and then update Status to "followe up email" sent. Can you please help
Sorry was busy for the last few weeks. Do you still need help in this?
i keep getting this error at the content compose stage - ''Content' inputs at line '0' and column '0': 'The template language function 'base64ToString' expects its parameter to be a string.
thank you. this is very helpful.
You're welcome!
Hi, do you know what happend "An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected" I tried to upload an image that come from a SP doc library ton a image column type in a PS list, thanks
Why did I not find this sooner....what a ridiculous bug! Thanks 👍
Thanks
Thank you so much for the video. Requesting you to please explain more about =OFFSET(Sheet2!A1,0,0,SUBTOTAL(103,Sheet2!$A:$A),3). I'm bit confused.
Hey ... me again! 😅 ... ... I think I found a tiny, tiny, way that you can improve this! By making the filter use this, instead, you might completely eradicate false positives! nthIndexOf(string(outputs('Compose')), concat('"', item(), '"'), 2) This is because you need to content for whether there are repeated elements of your item *inside* other items.
So, let's pretend that the inputs has an additional two entries at the end of: [ "lettersEFGmoreLetters", "lettersUITmoreLetters" ] ... That will say that "EFG" and "UIT" have matched. However, but concatenating the '"' around the item() then it will only match exact results. The only way that I can see this failing is if the item has internal quotes, then there is a chance that this find false positives on something like the following additional two: [ "letters\"EFG\"moreLetters", "letters\"UIT\"moreLetters" ] Because whilst those would usually be escaped with '\"' in the text as JSON, you have changed the text to a string. I would need to test further to find more on this. Still, this concatenation works for my purpose.here, as my results are already a stringified integer! 😆
I created a flow based on your instruction. However the output is not reflected in the new excel files. Please help.
Very useful video!👍
Glad it was helpful!
If you want to use flow within your non default environment in SharePoint for selected items you can do that by using a column formatting
hello, whenever i check my outputs it only showing the header and body , i dont get the questions separately for me to copy and paste it in the json
Thank you Very Much!! Works Great! You > Chat GPT
You're welcome!
Can you please create a video showing how to select 1 file from document library containing multiple files and send it on an email.
i have created a flow where when ever we receive an email(v3) the automation will copy the body and paste it in an excel sheet . but when i receive 2 emails at exact same time the flow is unable to trigger both the emails but only one some times none can you help me with this
Hi, thank you for this excellent tutorial! I was able to get this workflow to work on a sharepoint list I created manually but not on a sharepoint list I created by uploading a csv file with over 15,000 rows. Any ideas on why this workflow wouldn't work in the latter case?
Thanks for good informatic video, When a file is deleted approval workflow is required whether approve / reject
Thanks
Can we do this exercise on system defined tables like 'Microsoft Entra ID' table? Please make video on that
can someone help me? I am still getting the corrupted files only. I have a trigger comming from a powerapp getting the file The code in the body is: binary(triggerBody()?['file']?['contentBytes']) base64 is set to yes. Can anyone help me?
Hello, thanks for your video's i need to contact with u so, may i know your mail or WhatsApp no:
Thanks for the support. Check my channel about section. Send me an email.
Thanks for this!
Thanks for the support
Thank you @abm4975
Thanks for the support
This http connector is not working anymore. So I found another work around. More details in this thread. powerusers.microsoft.com/t5/Building-Flows/Email-Classification/m-p/2809734/highlight/true#M315588
Thank you very much for your detailed explanation
You are welcome
Thank you for sharing. Throughout the hierarchy, I have 2 sub-folders with the same name. How would I modify this Flow to delete all the files in only one of the sub-folders?
Get folder meta data using path to find the id. Then try to use the delete item using the id from the meta data. I haven't tested this but have a go. Always try this in a test folder or something. Then makes sure all ok. Thanks
With the extracted text from the mail body, how can we create a folder in share point with this extracted text name? It will be helpful if anyone helps me
hello, can ypu see here my recent post for power automate? my Id is hpatel95. I appriciate if you help me..
Believe I replied
Is this condition can be use to trigger only specific column right?
Yes that's correct but you can extend this for multiple fields too.
Hello, that is a very helpful video, thank you. Do you have a video doing the same thing but creating a PDF file from a SQL VarBinary field instead?
Hi Clive Believe you already asked this question in Power Automate community. I did responded. Please have a look. Thanks
@@abm4975 Thanks
Hi abm Is it possible to use a version of this flow to migrate a SPO classic List to a SPO Modern List in the same tenant? I have a few lists to move but I only need to retain the created data from the SPO Classic from the metadata.
Hi Joe Believe it should be possible. I can't see any difference other than the UI changes between classic and modern. So Power Automate should connect the classic list.
@@abm4975 Thank you for your quick reply :) ShareGate charge $4999 a year for that ability so it would be a game changer if it could be done via a flow.
Interesting. Could you connect me via email. Check my Channel about section. I want to see the classic list. I could have a go and see whether I can make it work or not. Thanks