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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

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 Flow Community Video Gallery!

Users Online
Currently online: 245 members 4,000 guests
Please welcome our newest community members: