Power Automate - Split, First, Last, Iterate All & access particular values from a set of values

Sdílet
Vložit
  • čas přidán 13. 09. 2024
  • This video explains PowerAutomate expressions split, first, last & iterate all values

Komentáře • 22

  • @x4ms
    @x4ms Před 2 měsíci +1

    Wonderful! THX!

  • @williamleveson-gower5088

    Thank you !!. Your video helped me to split a property address.

    • @abm4975
      @abm4975  Před rokem

      Hi William
      Thanks for your kind comments.

  • @anaaguilar3304
    @anaaguilar3304 Před 2 lety +1

    Thanks again btw. This is very useful and you are very good at explaining everything.

    • @abm4975
      @abm4975  Před 2 lety

      Hi Ana
      Thanks for the comment.

  • @geralddahl9159
    @geralddahl9159 Před 4 měsíci

    For the string 10, 20, 30, 10, 40 how can I search the string to return the index of 10 as both 0 and 12? Thx for making this, @abm4975.

  • @teomcam
    @teomcam Před 10 měsíci +1

    How to use split with two delimiters in teh same text? In my example I have ; and -

    • @abm4975
      @abm4975  Před 10 měsíci

      Try the below.
      split(split('hello; test-test3'), ';'),'-')

  • @prashanthbala2437
    @prashanthbala2437 Před 2 lety +1

    Dear sir, Iam looking for pulling up invoice details from different formats of pdf files. I tried AI builder but it was not that sucessful. Can you please help me on creating the flow in a dynamic way of pulling up invoice details?

    • @abm4975
      @abm4975  Před 2 lety +1

      Hi Prashanth
      Could you post your requirements in details under Power Automate community forum? Tag me @abm so that I will get notified. I will have a look into this.
      powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
      Thanks

  • @TJSMalladi
    @TJSMalladi Před 9 měsíci

    I have a multi line value. I have 6 items separated by a + sign. And a ‘|’(pipe symbol) for the end of the 6 items and again next 6 items are are there. I was able to get individual items using your video by choosing 0- 5 compose. How can I get the next 6 values after the pipe symbol please help

    • @TJSMalladi
      @TJSMalladi Před 9 měsíci +1

      I tried the split(split( it didn’t work 😢

    • @abm4975
      @abm4975  Před 9 měsíci

      I need to see your flow. If you still need help then please post this under the Power Automate community and tag me as @abm. Also if you want a screenshare connect me via teams. Check my Channel About section for more details.
      Power Automate Community Forum
      powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
      Thanks

    • @abm4975
      @abm4975  Před 9 měsíci

      Hi
      I need to see your flow. If you still need help then please post this under the Power Automate community and tag me as @abm. Also if you want a screenshare connect me via teams. Check my Channel About section for more details.
      Power Automate Community Forum
      powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
      Thanks

  • @owenhostetler2575
    @owenhostetler2575 Před 2 lety +1

    Thank you for the great video however the issue I'm having is that I can't input my data on the input string because it is different each time. How can I take this process and extract extract key pieces onto it's own line. Also multiple data points are listed on the same line. The data I need to extract from the below example is the "Company Name", the "Case #", the "Subject", and the "Description" they will all be exported into an excel file on their own column.
    "*** CASE -ASSIGNMENT NOTIFICATION *** The following New Case has been assigned",
    "to a new Queue. Company: XYZ Company Contact Name: Mylene Magboo Case",
    "#: 00282495 Subject: Devices stopped communicating in Skokie, IL 60077",
    "Description: Customer devices at the attached location in Skokie, IL that",
    "stopped reporting at 9:04AM on 8/3/22.
    Any direction would be appreciated.

    • @abm4975
      @abm4975  Před 2 lety

      Hi Owen
      Apologies for the late reply. Do you still need help in this?
      Thanks