When and item is created (SharePoint)
Site Address: "my site"
List Name: Initiation
Initialize variable
Name: varTargetEndUsers
Type: String
Value: {blank}
Apply to each
Select an output from previous steps: triggerBody()?['Target_x0020_End_x0020_USer_x002']
Append to string variable
Name: varTargetendUSers
Value: concat(items('Apply_to_each')?['Value'], ',')
[End Apply to Each]
Initialize variable 1
Name: varProductPillars
Type: String
Value: {blank}
Apply to each 1
Select an output from previous steps: triggerBody()?['oData__x0032_025_x0020_Product_x0020_P']
Append to string variable 1
Name: varProductPillars
Value: concat(items('Apply_to_each_1')?['Value'], ',')
[End Apply to Each 1]
Initialize variable 2
Name: varPrimaryGoTo
Type: String
Value: {Blank}
Apply to each 2
Select an output from previous steps: triggerBody()?['Primary_x0020_Go_x002d_To_x0020_']
Append to string variable 2
Name: varPrimaryGoTo
Value: concat(items('Apply_to_each_2')?['Value'], ',')
[End Apply to Each 2]
Compose
Inputs: concat(
'<html><body style="font-family: Calibri;">',
'<h2>Project Initiation Form</h2>',
'<p><b>Project Name:</b>', triggerBody()?['Title'], '</p>', '<p><b>Initiation Date:</b>', triggerBody()?['Initiation_x0020_Date'], '</p>',
'<p><b>Project Description:</b>', triggerBody()?['Project_x0020_Description'], '</p>',
'<p><b>GMI Product Strategy:</b>', triggerBody()?['GMi_x0020_Product_x0020_Strategy'], '</p>',
'<p><b>What Solution(s) Are We Adding:</b>', triggerBody()?['What_x0020_Solution_x0028_s_x002'], '</p>',
'<p><b>Target End User(s):</b>', variables('varTargetendUsers'), '</p>',
'<p><b>Primary Go-To Market(s):</b>', variables('varPrimaryGoTo'), '</p>',
'<p><b>Target Market(s):</b>', triggerBody()?['Target_x0020_Markets'], '</p>',
'<p><b>Key Compitior(s):</b>', triggerBody()?['Key_x0020_Competitors'], '</p>',
'<p><b>Target Internal Release:</b>', triggerBody()?['Target_x0020_Internal_x0020_Rele'], '</p>',
'<p><b>Target Market Launch:</b>', triggerBody()?['Target_x0020_Market_x0020_Launch'], '</p>',
'<p><b>Estimated Annual US Market:</b>', triggerBody()?['Estimated_x0020_Annual_x0020_US_'], '</p>',
'<p><b>Key Design Decision(s):</b>', triggerBody()?['Key_x0020_Design_x0020_Decision_'], '</p>',
'<p><b>Development Challenge(s):</b>', triggerBody()?['Development_x0020_Challenge_x002'], '</p>',
'<p><b>Key Product Concern(s):</b>', triggerBody()?['Key_x0020_Product_x0020_Concern_'], '</p>',
'<p><b>Product Category:</b>', triggerBody()?['Product_x0020_Category/Value'], '</p>',
'<p><b>Classification:</b>', triggerBody()?['Classification/Value'], '</p>',
'<p><b>Project Difficulty:</b>', triggerBody()?['Project_x0020_Difficulty/Value'], '</p>',
'<p><b>2025 Product Pillars:</b>', variables('varProductPillars'), '</p>',
'<p><b>Estimated Ghent 3-Year Sales Forecast:</b>', triggerBody()?['Estimated_x0020_Ghent_x0020_3_x0'], '</p>',
'</body></html>
Create File (OneDrive)
Folder Path: /"temporary folder"
File Name: triggerBody()?['Title']-triggerBody()?['Initiation_x0020_Date'].html
File Content: outputs('Compose')
Convert File (OneDrive)
File: outputs('Create_file')?['body/Id']
Target Type: PDF
Create File 1 (SharePoint)
Site Address: "my site"
Folder Path: /Initiation Hard Copy
File Name: triggerBody()?['Title']-triggerBody()?['Initiation_x0020_Date'].pdf
File Content: body('Convert_file')
Delay
Count: 15
Unit: Second
Delete File (OneDrive)
File: outputs('Create_file')?['body/Id']
When a file is created in a folder (deprecated) (sharepoint)
Sites Address: "my site"
Folder Id: /Initiation Hard Copy
Delay
Count: 45
Unit: Second
Condition:
triggerOutputs()?['headers/x-ms-file-name-encoded']
Does not end with
.pdf
True
Compose [Compose - Project Name]
Inputs: split(decodeBase64(triggerOutputs()?['headers/x-ms-file-name-encoded']), '-')[0]
List the cards in a board (Trello)
Board Id: Initiation
Filter Array [Filter Matching Card]
From: body('List_the_cards_in_a_board')
Filter Query: [USe Advanced mode] @equals(toLower(trim(item()?['name'])), toLower(trim(outputs('Compose_-_Project_Name'))))
Compose [Compose - PDF Link]
Inputs: concat('SharePoint url address/', triggerOutputs()?['headers']['x-ms-file-name-encoded'])
Get Card by ID [Get Card Info] (Trello)
Board Id: Initiaiton
Card Id: first(body('Filter_Matching_Card'))?['id']
Compose [Compose - Updated Description]
Inputs: replace(
body('Get_Card_Info')?['desc'],
'- Project Initiation Form: (link will be added)',
concat('- Project Initiation Form: ', outputs('Compose_-_PDF_Link'))
)
Update a card (Trello)
Board Id: Initiation
Card Id: first(body('Filter_Matching_Card'))?['id']
Name: first(body('Fliter_Matching_Card'))?['name']
Description: outputs('Compose_-_Updated_Description')
