GOAL: Users edit Excel file in Browser AND Block Downloads from Single Document Library

[abpmr_entarc]

GOAL: Users edit Excel file in Browser AND Block Downloads from Single Document Library

To date, I have tried many angles, including activating RMS (IRM) in O365 + SharePoint, and also enabling Access in Control in O365 + Azure. If I use either IRM or Access Control, it locks the files from download wonderfully...BUT it also blocks edit, which defeats the purpose altogether. I need some way of at least hiding the menus as a workaround. I have tried hiding elements such as the Site Contents control, but it only applies to the home page and not the Doc Lib.

Another consideration is how I might apply digital file management to the excel templates in order to render them useless upon download. Trying to be creative in my approach, but I am not sure how to tackle it just yet.

Any thoughts out there?

[Brad_Groux]

This isn't anything you can accomplish with Flow, the Excel Connectors (Business, OneDrive) are severely limited. The SharePoint Online Connector also doesn't offer any functionality that could block a user from downloading a file. I believe that your only real option is Conditional Access. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!