Flow to send email to Teams Subchannel ONLY

%3CLINGO-SUB%20id%3D%22lingo-sub-2246998%22%20slang%3D%22en-US%22%3EFlow%20to%20send%20email%20to%20Teams%20Subchannel%20ONLY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246998%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20reports%20I%20need%20emailed%20out%20to%20clients%20on%20a%20regular%20basis.%20One%20report%20is%20sent%20to%20clients%20and%20contains%20sensitive%20financial%20information.%20The%20other%20report%20is%20sent%20to%20clients%20and%20their%20associates.%20The%20files%20are%20currently%20uploaded%20into%20a%20Teams%20channel%20and%20subchannel%20with%20the%20subchannel%20housing%20the%20report%20containing%20sensitive%20financial%20information.%26nbsp%3B%3C%2FP%3E%3CP%3EClient%20%231%20Team%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EGeneral%20Subfolder%20-%20Everyone%20has%20access%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3EPrivate%20Subfolder%20-%20Only%20client%20has%20access%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20automate%20this%20process%20with%20a%20flow.%20I've%20been%20successful%20sending%20an%20email%20to%20the%20entire%20Team%20when%20a%20file%20is%20uploaded%20to%20the%20General%20Team%20Folder%20but%20am%20struggling%20to%20find%20a%20way%20to%20automate%20an%20email%20to%20only%20those%20members%20who%20have%20access%20to%20the%20Private%20Subfolder.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20something%20that's%20even%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

Hello All!

 

I have two reports I need emailed out to clients on a regular basis. One report is sent to clients and contains sensitive financial information. The other report is sent to clients and their associates. The files are currently uploaded into a Teams channel and subchannel with the subchannel housing the report containing sensitive financial information. 

Client #1 Team

General Subfolder - Everyone has access

Private Subfolder - Only client has access

 

I am trying to automate this process with a flow. I've been successful sending an email to the entire Team when a file is uploaded to the General Team Folder but am struggling to find a way to automate an email to only those members who have access to the Private Subfolder. 

 

Is this something that's even possible?

0 Replies