Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Excel trigger to send data to a Cognito Form

I am trying to set up a Flow with an Excel Trigger, that is sending data including Date, and Number columns over to Cognito Forms.


I'm able to set up the Excel Trigger and target the correct Excel sheet/document in SharePoint. The issue I'm running into is that the data is only showing up for a Text field in Cognito Forms. I can not pass the data into a Date or Number field.


Examples of what I'm seeing when setting up the flow.


Connecting to Text field:

Data sent to a Text field in Cognito Forms.

Connecting to Date field:

Data sent to a Date field in Cognito Forms

Connecting to a Number field:

Data connected to a Number field in Cognito Forms.


I'm trying to work out why data can be sent to the Text field, but not to the Date/Number field. Will the data need to be formatted in a different/specific way for Cognito Forms to collect?

Community Support Team
Community Support Team

Re: Excel trigger to send data to a Cognito Form

Hi @NicholasG,


Please take a try to add two Compose actions under the trigger to save the Date and Number field, and the insert the value of Compose in the "Create entry" action of Cognito Form connector.


Best regards,


Helpful resources


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 Kudoed Authors (Last 30 Days)
Users online (5,285)