Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Insightly Lead Creation always passes null value

Hi All,


I'm running into an issue building a Flow and am pulling out my hair because I can't figure out why this connection isn't working.


After establishing a connection to Insightly (CRM software), I want to pull data from new lead records to manipulate. Ultimately, I want to update a sharepoint list with the information, but for illustration of this problem, I have simply added an action to email the dynamic content from the record:

setup.pngFlow Setup

 You can see the dynamic content has been inserted in the subject line and body of the email. Whenever the flow triggers, however, all the dynamic content is rendered as null values. I tried inserting some conditions before the action and they would break the flow because null wasn't an acceptable input value. The flow output log demonstrates this:


output.pngFlow output



You can see that in the Body of the connection, the name/organization/number fields call the right data, but then there is empty output where they should show up in the subject and body areas below.


Am I using the dynamic content incorrectly? Is this a known bug in using Insightly as a trigger?


I tried testing the function of other Insightly functions (emailing myself the information from a created Insightly event) and they worked fine, but I really need functionality to read field data from Lead records. Any advice would be greatly appreciated. Thanks!!

Community Support Team
Community Support Team

Re: Insightly Lead Creation always passes null value

Hi @ cle0,

I have made a test on my side and the issue is confirmed on my side, the dynamic content of trigger “When a lead is created” would always be null.

I think this issue is related to the connector, I would post this issue to my product team. If the issue is solved, I would reply here.


For you situation, you could refer to steps below to create your flow as an alternative way:

  1. Add trigger “When a lead is created”
  2. Add a Compose, fill in the expressions in the inputs field as below:



     3.Add a Compose 2, fill in the expressions in the inputs field as below:



Note:You could use the expressions to get the title of the lead.

You could also get the description of the lead use expressions below:

outputs('Compose')?[' LEAD_DESCRIPTION']

You could get the field name that would be used in the expressions from the Output of the Compose or the trigger.



The flow would run successfully as below:




Alice Zhang

Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,118)