web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Move Data between two ...
Power Automate
Unanswered

Move Data between two workbooks in cloud flow

(1) ShareShare
ReportReport
Posted on by 2
Hey Everyone,
 
I have a scenario where I need to apply filter (AX column equals "Business") on an excel file (.xlsb) placed in one drive and copy this data and generate a new file with .xlsx format and paste the filtered data in this xlsx file.
 
Please let me know how can i achieve this. The filtered data can be as large as 10K row and columns can go upto BO column.
 
Thanks
Neeraj
 
 
Categories:
I have the same question (0)
  • Suggested answer
    trice602 Profile Picture
    15,331 Super User 2025 Season 2 on at
    Move Data between two workbooks in cloud flow
    Hi,
     
    This will work.  The OData filter in List rows present in a table File 1 is AX eq 'Business'.
     
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

  • trice602 Profile Picture
    15,331 Super User 2025 Season 2 on at
    Move Data between two workbooks in cloud flow
    Hey there!
     
    I am following up on this post move data between two workbooks in cloud flow in this category building flows from 12/12/2024.  I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered.  If so, please help the community out by completing one or more of the following actions!  Thanks in advance!
     
    Easy as 1-2-3 ‼️💯⭐😎🆒🙏
     
    1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅
    2) You can also mark one of more replies as a verified answer.  Please take a moment and give the author credit for volunteering their time. ✌️
    3) Like one or more replies.  Kudos always greatly appreciated! 👍
     
    Pro tip:  if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too!  The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!
     
    Again, thanks in advance for reading and responding, always glad to help!  Tom 💯💯💯💯💯
  • trice602 Profile Picture
    15,331 Super User 2025 Season 2 on at
    Move Data between two workbooks in cloud flow
    If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions.  Always glad to help!  Tom 💯💯💯💯💯

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard