I am getting leads two different date formats

[Vignesh Velappan]

I have connected pabbly with Facebook ad leads to google sheets to automate updating leads. I have changed the date format with the date/time formatter from Africa/Abidjan to Asia/Kolkata, still on my google sheet i am facing double leads with the same lead being shown two times, one in the Africa/Abidjan time zone format and one with the Asia/Kolkata time zone format. I have tried creating new recconecting the workflow but it doesn't seem to be working out.

 

[Pabblymember11]

Hey @Vignesh Velappan

Kindly share the workflow URL in which you have tried the same.

 

[Vignesh Velappan]

I have tried changing the format in two ways, One with the date/time formatter and once with the {{pc_local_human_now}} format. With the date/time formatter i was having the issue of double leads as mentioned in the pictures above. One with the Africa/Abidjan time zone i.e +0000 and one with the Asia/Kolkata time zone i.e +05:30.
With the {{pc_local_human_now}} format instead of seeing actual dates I'm being shown time stamps interspaced with dates with the Africa/ Abidjan time zone. I'm connected pabbly for other clients too with the date/time formatter and i haven't been facing any issues.

 

[Vignesh Velappan]

I have multiple workflows connecting to the same sheet. 7 to be precise, each one for a different lead generation form. Could the issue be related to this by any chance?

 

[Pabblymember11]

Could you kindly share the URL of your workflow where you've attempted this process? This will help us examine the input and the action steps you've implemented to provide you with more effective assistance.

 

[Vignesh Velappan]

Sure.
1. https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZlMDYzNTA0M2Q1MjZkNTUzMTUxMzEi_pc
2. https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZlMDYzNTA0M2Q1MjZkNTUzMjUxMzMi_pc

 

[Pabblymember11]

Hey @Vignesh Velappan

Can you please try using the Filter action step with the following filter type? Which will process only a single entry with the particular timezone.