How to delete range data if filter in present in workbook

zisan aalam 11 Reputation points
2022-11-18T11:21:09.143+00:00

I am trying to delete a data of a named range by the following API- POST /workbook/names/{name}/range/delete. It works fine when there is no filter in workbook but it gives issues when filter is present in workbook and it gives following error message The operation failed because it conflicts with a filtered range. So how to handle this ? How to ignore the filter in workbook?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,570 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Zehui Yao_MSFT 5,831 Reputation points
    2022-11-21T08:56:22.617+00:00

    Hi @zisan aalam , after my test, I can delete range which is hidden due to filter by the endpoint POST /workbook/worksheets/{sheetid}/range(address='<address>'/delete)
    Hope this can help. Best Wishes.

    262513-image.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.