Retrieve records from SharePoint List and Import Jobs of Dynamics 365 and Send to Excel file in SharePoint Folder

[d365_katiepage]

I created a flow that retrieves record from SharePointList and Import Job entity of Dynamics 365.  Then, it should send the data to an excel file in SharePoint folder.  

Bug ID, Name, Priority and Impact must come from SharePoint List with status of Ready to Push (DONE)

Solution Push Date should get the current date or the date the flow was triggered.

Solutions Pushed -should contain Solution names of Import Jobs in Dynamics 365 where Modified On=Solution Push Date.

I am new to Flows and does not know how to make the Solutions Pushed date and Solutions Pushed happen.

This is how my flow looks like.

[PrasadAthalye · Accepted solution]

For Solutions Push date, do you mean the date on which this flow was triggered? If yes, you can declare a variable as the first action in the flow and use utcnow() function that provides the current date.

Then you can use this variable within the Common data service list Rows filter. For example, since I did not have anything modified in recent days, I used subtract time and went back 60 days. Refer example below...