Power Automate - How to filter Excel rows and create new excel files and contents based on a filter?

Поделиться
HTML-код
  • Опубликовано: 26 янв 2025

Комментарии •

  • @gabriellajager3316
    @gabriellajager3316 5 дней назад

    Great explanation! Thanks!

  • @M2TVLiveMusicVideo
    @M2TVLiveMusicVideo 4 месяца назад +1

    Thanks! With your help now my flow works as well! 😁

    • @abm4975
      @abm4975  4 месяца назад

      Glad I could help! Thanks a lot.

  • @SarahYip-t4d
    @SarahYip-t4d 4 месяца назад +1

    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.

    • @abm4975
      @abm4975  4 месяца назад

      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

    • @SarahYip-t4d
      @SarahYip-t4d 4 месяца назад +1

      @@abm4975 Thank you for your reply. I understood this part. However, is there any issue with the filter array output returning Body[]?

    • @SarahYip-t4d
      @SarahYip-t4d 4 месяца назад +1

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

    • @SarahYip-t4d
      @SarahYip-t4d 4 месяца назад +1

      @@abm4975 Specifically, it is at Apply to each 2 that the Output returns Body [].

    • @abm4975
      @abm4975  4 месяца назад

      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

  • @MohammadAw-eh2gn
    @MohammadAw-eh2gn 7 месяцев назад +1

    Thank you very much sir for your help, video trex explanatory and instructive

    • @abm4975
      @abm4975  7 месяцев назад +1

      Thanks Mohammad. Glad that its helpful.

  • @sarathsharma4970
    @sarathsharma4970 19 дней назад

    How to use dynamic array while creating the table?

  • @adityaprasad6795
    @adityaprasad6795 4 месяца назад +1

    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

    • @abm4975
      @abm4975  4 месяца назад

      Yes you can. Add a row into table action step (Excel Connector) provides the location to choose from Onedrive or SharePoint.
      Thanks

  • @SamyukhthaPranethaa1984
    @SamyukhthaPranethaa1984 7 месяцев назад

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

  • @vishnupp5944
    @vishnupp5944 6 месяцев назад

    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:

    • @abm4975
      @abm4975  5 месяцев назад

      Hi
      Could you post this question in Power Automate community. I will have a look.
      community.powerplatform.com/forums/thread/details/?threadid=bbcf6764-c049-ef11-a317-6045bdeef8e9
      Thanks

  • @fatima-ezzahraerraji5352
    @fatima-ezzahraerraji5352 7 месяцев назад +1

    Thank you very much. Very good video, but the files are not filling up.

    • @abm4975
      @abm4975  7 месяцев назад +1

      Hi
      Thanks for the comment. Could you please explain what you trying to filter? What's the data type of the column?

    • @fatima-ezzahraerraji5352
      @fatima-ezzahraerraji5352 7 месяцев назад

      Hey. Thanks for your answer.
      So the first column contains the names of my students, and I want to filter based on that

    • @deepj7686
      @deepj7686 5 месяцев назад

      ​@@abm4975 I too have same problem like I can able to create new excel file but the contents are empty. Can you please help me on this

    • @deepj7686
      @deepj7686 5 месяцев назад

      ​@@abm4975 hi I too have same problem I'm able to create the excel files but the excel content are empty

    • @deepj7686
      @deepj7686 5 месяцев назад

      I too have same problem ..The excel files are getting created but the excel content are empty

  • @DiegoDeLamaxddjdjdqlfi
    @DiegoDeLamaxddjdjdqlfi 9 дней назад +1

    Hi! I Thanks for your help. I created a similar flow, but in the last step in the Add a row into a table, I had this error message
    Invalid request
    clientRequestId: e93a3ddd-ad8e-4d8e-9a30-562a5fc930b7
    serviceRequestId: 2858f444-9b79-42a5-b4b4-08e110890846"