This is my PAD flow so far, which creates an Excel file for each user and I want it to send a Teams message to each user individually with the Excel file as an attachment, but not sure how to do the latter part:
SET users TO $'''John Smith
Mary Jane
Jane Doe
Frank Smith'''
Text.SplitText.Split Text: users StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> userlist
LOOP FOREACH CurrentUser IN userlist
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance
Excel.SaveExcel.SaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.OpenXmlWorkbook DocumentPath: $'''C:\\Users\\kc\\Documents\\%CurrentUser%'''
Web.InvokeWebService.InvokeWebService Url: `` Method: Web.Method.Get Accept: $'''application/xml''' ContentType: $'''application/xml''' ConnectionTimeout: 30 FollowRedirection: True ClearCookies: False FailOnErrorStatus: False EncodeRequestBody: True UserAgent: $'''Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.21) Gecko/20100312 Firefox/3.6''' Encoding: Web.Encoding.AutoDetect AcceptUntrustedCertificates: False ResponseHeaders=> WebServiceResponseHeaders Response=> WebServiceResponse StatusCode=> StatusCode
END
