Unanswered

Sharepoint List to Excel Spreadsheet to Mailchimp - Date Formatting

(0) Share

Report

Posted on by Natalie_b06

Hi,

I have been having trouble connecting a flow that when a new item is created in a Sahrepoint List, this updates all fields in Mailchimp. At the moment, flow only allows you to add a new subscriber in Mailchimp for First Name, Last Name and Email Address. I have found a solution using both flow and other automation tool.

Flow connects the Sharepoint List and adds a new row onto a table in Excel Online (Business) in One Drive. The other automation tool then links the excel table to Mailchimp and when a new row is created from the original flow in the table it then adds a new subscriber to Mailchimp with all related fields.

The problem is the format in the Sharepoint list for DOB is DD/MM/YYYY 00:00 which is pulled through to the Excel Online spreadsheet using Flow. However the other automation tool fails and said that the date format needs to be MM/DD. Does anyone know if there is any way in Flow that an action can be created to adjust the format of this field so that when it pulls it through to Excel it can be in the format required?

Ive tried to explain best I can. I am also a new user so please forgive me if im wrong.

Thanks

Natalie

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @Natalie_b06 ,

Could you share a screenshot on your current flow?

If you want the date time formatted to be ‘MM/DD’, please just insert a formatDateTime function in the datetime field.

Please check the following doc on the formatDateTime function for more details:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatDateTime

Best regards,

Mabel

Was this reply helpful? Yes No
Natalie_b06 6 on at

Like (0)

Report

Hi Mabel,

Here is a screenshot. It is the 'DOB' field that needs formatting to 'MM/DD' im not familar with expressions yet. Would I put the formatDateTime function in the DOB field?

Thanks

Was this reply helpful? Yes No
Natalie_b06 6 on at

Like (0)

Report

Ive added
format DateTime(triggerBody()?['DOB'],'MM/DD/YY')
into the DOB field and ran the flow and it is failing (see below):

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report
Hi @Natalie_b06 ,

The error message says that the provided value is of type Null. Please make sure DOB in the SharePoint list does have value.

Further, please modify you function into:

formatDateTime(triggerBody()?[‘DOB’],’MM/dd/yyyy’)

I have made the following test according to the screenshot, which is working successfully.

The function I am using in the Start field is:

formatDateTime(triggerBody()?['StartDate'],'MM/DD/YYYY')

An image for your reference

Best regards,

Mabel

Was this reply helpful? Yes No
merlynproton 2 on at

Like (0)

Report

Hello

I was going through this entire thread to understand the issue. Did you try an integration tool like Automate.io? I am using it at this moment, and I have my Mailchimp connected to my excel sheet to pull all Mailchimp data directly into my excel sheet. In my Mailchimp, I have the DOB format for my subscriber date which is pulled into my excel as it is. Whenever a new subscriber is added to my Mailchimp, a new row is automatically created in my excel sheet along with all the details about that subscriber. I haven't faced any issue with the formatting till now. I also use Sharepoint which is connected to my Mailchimp and excel in this same workflow. I think this can be an easy alternative. Hope I have understood your problem right and have helped. Let me know if it works.

Was this reply helpful? Yes No