Extracting last day data from microsoft dynamics cm 2015 of an entity

[Priyank2]

Hello,

I am using tmicrosoftcrmInput component to extract microsoft dyanamics crm 2015 opportunities,now I have a requirement to extact opportunities where condition is modifiedon(date field type) should be yesterday.

can anyone help me or guide me how to apply this condition in component?

Thank you in advance!

[Anonymous · Accepted solution]

Hi

For testing, add a filter condition (modifiedon column in your case) in the Condition table and set a fixed date value in the Value column, can you try and let me know if you are able to extract the data that matches the condition.

settings like

 

If it works, we will add a dynamic value date.

Regards

Shong

[Priyank2]

Hello Shong,

Thank you very much! It worked and dynamics value also added in flow.