cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NicholasG
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?

1 REPLY 1
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,

Alice

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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