You’re offline. This is a read only version of the page.
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!
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.
@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.
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
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (