I need to check that the the excel received in sharepoint should always contain the same header names stored in collection and if there is any discrepancy then BOT will throw the exception and send an email in the below format :
The headers within the Initial User List, “[FILE NAME]” do not follow the correct format. Please update the headers based on the information below and replace the file to be validated once again, prior to ingestion.
Current Header Format:
[Paste existing incorrect Headers here in a table format like the below]
Correct Header Format:
CAMPAIGN NAME USER NT LOGIN USER FULL NAME USER EMAIL (IF APPLICABLE) RES1 RES2 RES3 APPROVER NT LOGIN APPROVER FULL NAME APPROVER EMAIL