DataVerse Connector within a Macro

Hi,

I am trying to pull information from Dynamics 365 based on Modified date.

Ideally when the workflow runs i would like all data for the last 7 days (sysdate-7).

I've got a workflow using dataverse input which is pulling data from Dynamics 365 successfully. i've converted this into a macro, is it possible to update the parameters in the dataverse input with something like sysdate-7 when filtering manually on modified date?

Macros

Accepted answers

vinayabraham

Yes, you can dynamically filter data based on the Modified Date in Dynamics 365 using the Dataverse Input Tool by leveraging parameters in your macro.Creat a Parameter DateFilter.Set the Default Value to something like DateTimeAdd(DateTimeToday(), -7, "days") if you want the last 7 days dynamically.Also configure the action tool (Update Value) and choose URL or Query to Modify

All comments

apathetichell

Yes. I don't use these tools -> but I can almost gurantee you that the answer is yes. your dynamic work occurs outside your macro-> you add a control parameter and an action tool into your macro. you use the action tool to replace a speciifc string -> which corresponds to the date range. you update that date range outside the macro and voila.

vinayabraham

AHill06

Thanks @apathetichell and @vinayabraham for giving me some pointers.

I've now been able to successfully implement this, now need to work out a work around the max row count limitation. as I don't know how many rows there are each day but I do know I need them all! thanks for your help.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335