You’re offline. This is a read only version of the page.
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
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.
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
Ive added
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
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:
Best regards,
Mabel
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (