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 Groups API
Microsoft Graph Groups API
A Microsoft API that creates and manages different types of groups and group functionality.
204 questions
Microsoft Graph Workbooks API
Microsoft Graph Workbooks API
A Microsoft API that allows web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
66 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Zehui Yao_MSFT 4,001 Reputation points Microsoft Vendor
    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.