abm abm
abm abm
  • 148
  • 1 342 664
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')))
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)?

Komentáře

  • @vishnupp5944
    @vishnupp5944 Před 3 dny

    Thank you brothers. helping a lot for beginners like me

  • @vishnupp5944
    @vishnupp5944 Před 3 dny

    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:

  • @meenufsts
    @meenufsts Před 7 dny

    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.

  • @charlesuko8110
    @charlesuko8110 Před 10 dny

    Thanks!

  • @billybarbarian
    @billybarbarian Před 10 dny

    Worked great. Thanks! God bless!

  • @FaithfulStreaming
    @FaithfulStreaming Před 12 dny

    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

  • @Ncredible07
    @Ncredible07 Před 12 dny

    I did not know god can be in a youtube video. Thank you god.

    • @abm4975
      @abm4975 Před 7 dny

      hahah. Thanks for the nice comment.

  • @bharanidharan3074
    @bharanidharan3074 Před 13 dny

    How to update values by dynamic content .. I tried it is now working by if I give mail manually it works

  • @user-wy8ge7vz8e
    @user-wy8ge7vz8e Před 14 dny

    I was about to go crazy jaja, but this helps a lot! thank you!!!!!!!!

    • @abm4975
      @abm4975 Před 7 dny

      Thanks for the comment.

  • @stevenmicah8558
    @stevenmicah8558 Před 17 dny

    This is the best tutorial! Exactly what I needed and it all worked for me! Thank you so much!!

  • @MichaelClarkenator
    @MichaelClarkenator Před 18 dny

    This was exactly what I was looking for! Thank you!

  • @bilalhemdulla8813
    @bilalhemdulla8813 Před 18 dny

    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

  • @ralphcham
    @ralphcham Před 18 dny

    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

  • @davidferrick
    @davidferrick Před 19 dny

    Does this work with a Shared Inbox? I cannot seem to get it to work.

    • @abm4975
      @abm4975 Před 7 dny

      Hi David Thanks for the question. I thought it should. I haven't tried that. What error are you getting?

  • @ShantiniSivanesan
    @ShantiniSivanesan Před 19 dny

    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?

  • @AlbrechtPhilipp
    @AlbrechtPhilipp Před 20 dny

    Thank you so much! Why didn't I search the net before waisting hours on this bug?!

  • @OttoAnalytics
    @OttoAnalytics Před 20 dny

    You are a genius! Thank you for this simple guide to get this done.

  • @sasikanthmachavarapu4689

    I am getting ECONNRESET error when trying to execute the mentioned GET and POST calls..can anyone help me out here please

    • @abm4975
      @abm4975 Před 7 dny

      The ECONNRESET error stands for "Error Connection Reset." Check your firewall.

  • @AnthonyLewis-f2c
    @AnthonyLewis-f2c Před 21 dnem

    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?

  • @x4ms
    @x4ms Před 22 dny

    Wonderful! THX!

  • @MrFulcrumSystems
    @MrFulcrumSystems Před 22 dny

    I have trying to understand how to extract formatted data from an email. You nailed it. Thank you!

  • @surbhidhillon6993
    @surbhidhillon6993 Před 23 dny

    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

    • @abm4975
      @abm4975 Před 7 dny

      Sorry was busy for the last few weeks. Do you still need help in this?

  • @rushdihameed798
    @rushdihameed798 Před 25 dny

    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.

  • @josephtiu1219
    @josephtiu1219 Před 25 dny

    thank you. this is very helpful.

  • @gregoirepesenti
    @gregoirepesenti Před 26 dny

    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

  • @_JezzaG
    @_JezzaG Před 26 dny

    Why did I not find this sooner....what a ridiculous bug! Thanks 👍

  • @yeskumar78
    @yeskumar78 Před 27 dny

    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.

  • @ukm365
    @ukm365 Před 28 dny

    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.

    • @ukm365
      @ukm365 Před 28 dny

      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! 😆

  • @SamyukhthaPranethaa1984

    I created a flow based on your instruction. However the output is not reflected in the new excel files. Please help.

  • @laszlogyor6628
    @laszlogyor6628 Před 29 dny

    Very useful video!👍

    • @abm4975
      @abm4975 Před 7 dny

      Glad it was helpful!

  • @joker-cy6qo
    @joker-cy6qo Před 29 dny

    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

  • @mhmdzrik8579
    @mhmdzrik8579 Před měsícem

    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

  • @Dlhlaptop
    @Dlhlaptop Před měsícem

    Thank you Very Much!! Works Great! You > Chat GPT

    • @abm4975
      @abm4975 Před měsícem

      You're welcome!

  • @kirtichopra2551
    @kirtichopra2551 Před měsícem

    Can you please create a video showing how to select 1 file from document library containing multiple files and send it on an email.

  • @SreeramSashankChundi
    @SreeramSashankChundi Před měsícem

    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

  • @reshmapatel101
    @reshmapatel101 Před měsícem

    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?

  • @shathike4079
    @shathike4079 Před měsícem

    Thanks for good informatic video, When a file is deleted approval workflow is required whether approve / reject

  • @17avskadoo
    @17avskadoo Před měsícem

    Can we do this exercise on system defined tables like 'Microsoft Entra ID' table? Please make video on that

  • @jonaskoniger3337
    @jonaskoniger3337 Před měsícem

    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?

  • @abdelhamedmohammedali6143

    Hello, thanks for your video's i need to contact with u so, may i know your mail or WhatsApp no:

    • @abm4975
      @abm4975 Před měsícem

      Thanks for the support. Check my channel about section. Send me an email.

  • @marconeabdala8793
    @marconeabdala8793 Před měsícem

    Thanks for this!

    • @abm4975
      @abm4975 Před měsícem

      Thanks for the support

  • @user-um1dj4th3u
    @user-um1dj4th3u Před měsícem

    Thank you @abm4975

    • @abm4975
      @abm4975 Před měsícem

      Thanks for the support

  • @abm4975
    @abm4975 Před měsícem

    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

  • @user-bn4cs7bk8h
    @user-bn4cs7bk8h Před měsícem

    Thank you very much for your detailed explanation

    • @abm4975
      @abm4975 Před měsícem

      You are welcome

  • @bc67
    @bc67 Před měsícem

    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?

    • @abm4975
      @abm4975 Před měsícem

      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

  • @RakhibMohammad
    @RakhibMohammad Před měsícem

    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

  • @himanshupaghdal
    @himanshupaghdal Před měsícem

    hello, can ypu see here my recent post for power automate? my Id is hpatel95. I appriciate if you help me..

    • @abm4975
      @abm4975 Před měsícem

      Believe I replied

  • @himanshupaghdal
    @himanshupaghdal Před měsícem

    Is this condition can be use to trigger only specific column right?

    • @abm4975
      @abm4975 Před měsícem

      Yes that's correct but you can extend this for multiple fields too.

  • @CliveMMorgan
    @CliveMMorgan Před měsícem

    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?

    • @abm4975
      @abm4975 Před měsícem

      Hi Clive Believe you already asked this question in Power Automate community. I did responded. Please have a look. Thanks

    • @CliveMMorgan
      @CliveMMorgan Před měsícem

      @@abm4975 Thanks

  • @JoeAtWork-gy4wh
    @JoeAtWork-gy4wh Před měsícem

    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.

    • @abm4975
      @abm4975 Před měsícem

      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.

    • @JoeAtWork-gy4wh
      @JoeAtWork-gy4wh Před měsícem

      @@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.

    • @abm4975
      @abm4975 Před měsícem

      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