Announcements
Hi,
My question is regarding Key Column and Key Value. The documentation at Excel Online (Business) - Connectors | Microsoft Learn isn't really useful. What should we select as Key Column and Key Value? I just want to delete all rows. Thanks!
Hi @925stuart
You could the solution in the post mentioned below:
Solved: Delete all rows in an Excel file - Power Platform Community (microsoft.com)
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
@925stuart / @ManishSolanki This is the best solution to implement easily. If you have very large tables (in terms of rows) and need the flows to run faster, then I would use an Excel Script to delete all rows.
Here's more information. The XLS is a small file with 20 rows max. It contains a list of new action items which I'm trying to read using Flow to create Tasks in Planner. I would like to delete the rows which has been successfully converted to Tasks.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 468
Haque 370
Valantis 354
