Power Platform Community Forum Thread Details

I have a flow set-up where when an item is created in SharePoint list "Initiation" then a card will be created in Trello (using the standard Trello connector Create a card). I have a flow set-up after that is a When an item is created (SharePoint) that when a file is created in "Initiation" a file will be created in OneDrive, converted to pdf then Create a file (SharePoint) once the SharePoint file is created it will then delete the OneDrive file. After that I have a flow set-up to trigger When a file is created in a folder (deprecated). The trigger is pointed at the folder where the previous flow saved the file. The flow will then update the Trello cards description to add a link to the folder. All of these flows worked fine previously until about 2 weeks ago. They are now only working when they are "soft reset" by turning the flow off and then back on. I have 9 other flows that were created that work fine (one does the pdf conversion step the rest are description updates and all trigger off of different lists.) To try to remedy this I have tried new lists in SharePoint, deleted and reconnect my SharePoint, OneDrive, and Trello connections. I have also rebuilt all three flows last week. these test resulted in no changes. I am at a loss on how to fix this problem as I need these three to run in order for the other flows to complete successfully. Below are examples of my three flows in order as I listed them.

Also I am using standard PowerAutomate with the New Designer UI and based in the cloud app not desktop. I do not have admin access but can communicate possible solutions to network admins.

When an item is created (SharePoint)
Site Adress: "my site"
List Item: Initiation

Create a card (Trello)
Board Id: Initiation
Parent List Id: Stage 1
Card Name: triggerBody()?['Title']
Source Url: null
Due Date: triggerBody()?['Target_x0020_Internal_x0020_Rele']
Card Description: Project Initiation:triggerBody()?['Initiation_x0020_Date']
TriggerBody()?['Project_x0020_Description']

       ## Project Files
       - **Project Initiation Form:** (link will be added)
       - **Design Wishlist:** (link will be added)
       - **Design Philosophy:** (link will be added)
       - **Custom Option:** (link will be added)
       - **Key Competitors:** (link will be added)
       - **Business Plan:** (link will be added)
       - **Part Number Configuration:** (link will be added)
       - **Pricing:** (link will be added)
       - **LMO:** (link will be added)
       - **Unit Sales:** (link will be added)
       - **Sales Projections:** (link will be added)
       - **Compliance and Certifications:** (link will be added)
       - **New Item Spreadsheet:** (link will be added)
       - **Raw Material Uploader:** (link will be added)
       - **Product Uploader:** (link will be added)
       - **Instruction Sheets:** (link will be added)
       - **Spec Sheets:** (link will be added)
       - **Line Drawings:** (link will be added)
       - **Product Hero Renderings:** (link will be added)

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>',
'Project Name:', triggerBody()?['Title'], '', 'Initiation Date:', triggerBody()?['Initiation_x0020_Date'], '',
'Project Description:', triggerBody()?['Project_x0020_Description'], '',
'GMI Product Strategy:', triggerBody()?['GMi_x0020_Product_x0020_Strategy'], '',
'What Solution(s) Are We Adding:', triggerBody()?['What_x0020_Solution_x0028_s_x002'], '',
'Target End User(s):', variables('varTargetendUsers'), '',
'Primary Go-To Market(s):', variables('varPrimaryGoTo'), '',
'Target Market(s):', triggerBody()?['Target_x0020_Markets'], '',
'Key Compitior(s):', triggerBody()?['Key_x0020_Competitors'], '',
'Target Internal Release:', triggerBody()?['Target_x0020_Internal_x0020_Rele'], '',
'Target Market Launch:', triggerBody()?['Target_x0020_Market_x0020_Launch'], '',
'Estimated Annual US Market:', triggerBody()?['Estimated_x0020_Annual_x0020_US_'], '',
'Key Design Decision(s):', triggerBody()?['Key_x0020_Design_x0020_Decision_'], '',
'Development Challenge(s):', triggerBody()?['Development_x0020_Challenge_x002'], '',
'Key Product Concern(s):', triggerBody()?['Key_x0020_Product_x0020_Concern_'], '',
'Product Category:', triggerBody()?['Product_x0020_Category/Value'], '',
'Classification:', triggerBody()?['Classification/Value'], '',
'Project Difficulty:', triggerBody()?['Project_x0020_Difficulty/Value'], '',
'2025 Product Pillars:', variables('varProductPillars'), '',
'Estimated Ghent 3-Year Sales Forecast:', triggerBody()?['Estimated_x0020_Ghent_x0020_3_x0'], '',
'</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')

Categories:

Building flows

Hi @RC-03112030-0

I am super sorry for your hassles.

here is what I would try

1. Turn off the new UI in your flow.

2. Save it

3. Publish all customizations

4. When you say you rebuilt the flows, do you mean you created other copies or you create a brand new flow or you modified the existing?

5. I know it sounds stupid... but verify 100000% that your triggers are pointing to a site that no one changed permissions on and the trigger will not fire.

6. Verify no one added any trigger conditions

7. If you did in fact create brand new flows, then I want you to try this.

---Create a manual flow

---Add an action to read the SharePoint list(s) that are not triggering or read the File Folder location that are not triggering.

If you are able to read them in your actions then that is good and it might help break any meta-data uggg that has happened.

I know you said you created new connections (I think), but see if you have a service account and create the flow AS the account.

In the end, normally removing the triggering and or doing a Save-As will fix meta-data breaks, but it sounds lik you did all that.

If so, then try it from another Environment. Even if you have to spin up a free Developer environment to try it from.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey