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 - Building Flows / Retrieve records from ...
Power Automate - Building Flows
Answered

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 d365_katiepage 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:
Business Process Flows
I have the same question (0)
  • Verified answer
    PrasadAthalye Profile Picture
    PrasadAthalye 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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans