How to validate whether the file that we are using in Teams Channels is exists or deleted in SharePoint?

Question

How to validate whether the file that we are using in Teams Channels is exists or deleted in SharePoint?

DeveloperTeams 20

Hi Microsoft Team,

I have attached few Files and Folders in Channel's Files Tab and I have deleted a Team permanently by deleting the group from recycle bin which also deletes the SharePoint site created for that particular group. Is there an API/alternative solution to validate whether the file that we are using in Teams is already deleted in SharePoint or not? Because this data helps us to provide some information to user.

Please kindly help with a detailed technical solution asap for both the question.

Thanks

Meghana-MSFT 4,116 Reputation points Microsoft External Staff

2024-05-20T10:40:10.61+00:00
You can use the Graph API endpoint to list files in a SharePoint document library and check if the file you are looking for exists. If the Team is permanently deleted, including the associated SharePoint site, you won't be able to directly check the file status using the Graph API as the site no longer exists. In this scenario, you can implement error handling in your app to detect when the SharePoint site associated with the Teams channel is not accessible. You can then notify the user with information you wanted to provide.

GraphServiceClient graphClient = new GraphServiceClient(authProvider); // List files in a SharePoint document library var files = await graphClient.Sites["{site-id}"].Lists["{list-id}"].Items .Request() .GetAsync(); // Check if the file exists in the list of files if (files.Any(file => file.Name == "your-file-name.txt")) { // File exists } else { // File does not exist }

https://learn.microsoft.com/en-us/graph/api/channel-get-filesfolder?view=graph-rest-1.0&tabs=http

https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0

https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0
Meghana-MSFT 4,116 Reputation points Microsoft External Staff

2024-05-20T10:40:20.2433333+00:00
You can use the Graph API endpoint to list files in a SharePoint document library and check if the file you are looking for exists. If the Team is permanently deleted, including the associated SharePoint site, you won't be able to directly check the file status using the Graph API as the site no longer exists. In this scenario, you can implement error handling in your app to detect when the SharePoint site associated with the Teams channel is not accessible. You can then notify the user with information you wanted to provide.

GraphServiceClient graphClient = new GraphServiceClient(authProvider); // List files in a SharePoint document library var files = await graphClient.Sites["{site-id}"].Lists["{list-id}"].Items .Request() .GetAsync(); // Check if the file exists in the list of files if (files.Any(file => file.Name == "your-file-name.txt")) { // File exists } else { // File does not exist }

https://learn.microsoft.com/en-us/graph/api/channel-get-filesfolder?view=graph-rest-1.0&tabs=http

https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0

https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0

1 answer

Your answer

Meghana-MSFT 4,116 Reputation points Microsoft External Staff

2024-05-20T10:40:10.61+00:00

You can use the Graph API endpoint to list files in a SharePoint document library and check if the file you are looking for exists. If the Team is permanently deleted, including the associated SharePoint site, you won't be able to directly check the file status using the Graph API as the site no longer exists. In this scenario, you can implement error handling in your app to detect when the SharePoint site associated with the Teams channel is not accessible. You can then notify the user with information you wanted to provide.

GraphServiceClient graphClient = new GraphServiceClient(authProvider); // List files in a SharePoint document library var files = await graphClient.Sites["{site-id}"].Lists["{list-id}"].Items .Request() .GetAsync(); // Check if the file exists in the list of files if (files.Any(file => file.Name == "your-file-name.txt")) { // File exists } else { // File does not exist }

https://learn.microsoft.com/en-us/graph/api/channel-get-filesfolder?view=graph-rest-1.0&tabs=http

https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0

https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0
Meghana-MSFT 4,116 Reputation points Microsoft External Staff

2024-05-20T10:40:20.2433333+00:00

You can use the Graph API endpoint to list files in a SharePoint document library and check if the file you are looking for exists. If the Team is permanently deleted, including the associated SharePoint site, you won't be able to directly check the file status using the Graph API as the site no longer exists. In this scenario, you can implement error handling in your app to detect when the SharePoint site associated with the Teams channel is not accessible. You can then notify the user with information you wanted to provide.

GraphServiceClient graphClient = new GraphServiceClient(authProvider); // List files in a SharePoint document library var files = await graphClient.Sites["{site-id}"].Lists["{list-id}"].Items .Request() .GetAsync(); // Check if the file exists in the list of files if (files.Any(file => file.Name == "your-file-name.txt")) { // File exists } else { // File does not exist }

https://learn.microsoft.com/en-us/graph/api/channel-get-filesfolder?view=graph-rest-1.0&tabs=http

https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0

https://learn.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0

Answer 1

@DeveloperTeams

One alternative solution to validate whether the file that you are using in Teams is already deleted in SharePoint is to check the recycle bin of the SharePoint site. When you delete a file from a SharePoint site, it is moved to the recycle bin of the site. If the file has been deleted from the SharePoint site, it will be in the recycle bin. Here are the steps you can follow:

Go to the SharePoint site where the file was located.
Click on the gear icon in the top right corner and select "Site contents".
In the left-hand menu, click on "Recycle bin".
Search for the file in the recycle bin. If it is there, it has been deleted from the SharePoint site.
If the file is not in the recycle bin, it may have been permanently deleted and cannot be recovered.

Note: If the SharePoint site has been deleted along with the Teams team, this solution will not work.

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.

DeveloperTeams 20 Reputation points

2024-05-20T09:50:52.67+00:00

JimmyYang-MSFT Thanks for the reply. I am aware of this solution but can you please help me with some API to handle this in our code to provide some useful message to the user when they try to access the deleted files from Teams

Share via

How to validate whether the file that we are using in Teams Channels is exists or deleted in SharePoint?

1 answer

Your answer