Power Automate - Community Question - How to update a row of dynamic Excel file?

Поділитися
Вставка
  • Опубліковано 14 жов 2024
  • This video explains how to update a row of dynamic Excel file.
    powerusers.mic...

КОМЕНТАРІ • 15

  • @TinyTrends-G
    @TinyTrends-G 9 місяців тому +3

    Hi, forget back to you. I already done my automation project. And this video really helps a lot. Thank you so much for sharing this knowledge with us. More videos ahead.

    • @abm4975
      @abm4975  Місяць тому

      Glad it helped!

  • @PrabhuKiranTulam
    @PrabhuKiranTulam 5 місяців тому

    Hi, how to use this update a row action in PAD by passing dynamic variable for table name. will this same approach works? if possible please do a small demo video on that

  • @TinyTrends-G
    @TinyTrends-G Рік тому +1

    Hi, is it possible the table also be dynamic? I have multiple tables in my excel file. Thank you so much

    • @abm4975
      @abm4975  Рік тому

      Hi
      Thanks for the question. Yes you can. Use Get tables action step and dynamically map the table values in a loop. Still you need to know the schema of each columns for each tables for the update. May be an IF condition to determine that. Hope it helps.
      Thanks

  • @fakeaccount3415
    @fakeaccount3415 5 місяців тому

    so table name is randon we choose or we have to configure before in an excel sheet?

  • @thabomosupi3312
    @thabomosupi3312 Місяць тому +1

    Hi, you are sharing valuable skills, however your screen is blurred (not clear to view). Can you try to improve this please?

    • @abm4975
      @abm4975  Місяць тому +2

      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

    • @thabomosupi3312
      @thabomosupi3312 Місяць тому +1

      @@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! 😃🙏

    • @abm4975
      @abm4975  Місяць тому

      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.

  • @noodlebrains
    @noodlebrains 5 місяців тому

    I have different sheets with different rows and a main sheet with all rows. I wanted to only update rows in main sheet if the row is present in the source data sheet. But I can’t get it to work, it just my update rows keeps overwriting the existing data when the new sheet is added 😢 even though it doesn’t have that row

  • @bhakti_krishann
    @bhakti_krishann 6 місяців тому +1

    I have an Excel file in which there is no unique data. I want to update multiple rows on basis of single value ? How it possible pls help us

    • @abm4975
      @abm4975  6 місяців тому

      First, use the filter rows to filter the values and use the update rows

  • @andonii46
    @andonii46 18 днів тому +1

    How would this work in PAD?

    • @abm4975
      @abm4975  17 днів тому

      Hi
      I haven't tried this in PAD yet.
      Thanks