how to insert data in the source after compareing dates

i have a source name as Payment details which in CRM and one excel file in azure blob. in both files, we have the columns name payment date and payment due date in both files . I want to update my CRM file after comparing the payment date of CRM to the payment date of Excel i want the latest date of excel in the CRM file .

Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-04-02T00:11:08.133+00:00

Hi @Prabodh Purwar (MINDTREE LIMITED) ,

Thanks for using Microsoft Q&A !!
To make sure I understand it correctly, You are pulling data from CRM and want to compare payment date against the excel file and get the Maximum Payment Due date from Excel and update it back to CRM ? Can you please provide a sample data. Also, what will be the sink of this data ?
Prabodh Purwar (MINDTREE LIMITED) 1 Reputation point

2021-04-03T06:31:02.017+00:00

Hi @Saurabh Sharma

yes ,Saurabh u r correct my sink is the same CRM table paymnet details,

i want the latest date of excel should be copied in the CRM and if payment details column is empty the check the payment due date

and update the latest payment due date in payment due date column in CRM

This is the data from CRM

This is data from EXcel
Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-04-07T19:49:40.42+00:00

@Prabodh Purwar (MINDTREE LIMITED) As per internal discussion please share your solution once you are done.