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:
Connecting to Date field:
Connecting to a Number field:
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?
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