web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Retrieve records from ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 22

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.  

 

d365_katiepage_0-1616050917699.png

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.

d365_katiepage_1-1616052249022.png

 

Categories:
I have the same question (0)
  • Verified answer
    PrasadAthalye Profile Picture
    on at
    Re: Retrieve records from SharePoint List and Import Jobs of Dynamics 365 and Send to Excel file in SharePoint Folder

    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...

     

    PrasadAthalye_0-1616339112919.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard