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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to show a full D36...
Power Apps
Answered

How to show a full D365FO table in a SharePoint List including clearing table first?

(0) ShareShare
ReportReport
Posted on by 12

Hello Community,

New to PowerApps so appreciate some help 🙂

I am trying to achieve something that I think is pretty simple.

I've created a SharePoint list using appropriate table headers that I manually populate for the business once a week, now I want to automate it.

I'm hoping to once a week clear all data out of the customer SharePoint list then repopulate that list with the full table from our Microsoft D365FO.

I've built a simple flow that pulls the data from D365 but I have no idea how to clear and repopulate that SharePoint list from the flow.

Any help would be appreciated - thanks!

 

Categories:
I have the same question (0)
  • Verified answer
    HenWang Profile Picture
    Microsoft Employee on at

    Hi @IamJustAlex ,

     

    For deleting the items part, please refer to below demo:

    HenWang_0-1683858847237.png

     

    1. Get items action: Just select the list you want to delete.

     

    2. Delete item:

    After you create this action, select the ID dynamic content as described in above snap, and then you will get below result: flow will automatically add this apply to each action outside the delete item action, this is expected result.

    HenWang_1-1683858969906.png

     

    After this, you will be able to create item in the similar way: select the Dynamics 365 FO items vale inside SharePoint create item action and flow will help to generate the apply to each action automatically as well.

     

    Best Regards,

    Hen Wang

     

  • TestyGoingToDoIT Profile Picture
    12 on at

    Oh wow - yep that's solved it. I thought it was simple!

    My issue with deleting the sharepoint items was that it would only delete 100 rows which I fixed by altering the Pagination settings.

    Do you know if the below D365FO action has a retrieve limit?

    IamJustAlex_0-1683872254446.png

     

  • HenWang Profile Picture
    Microsoft Employee on at

    Hi @IamJustAlex ,

     

    At least from the official doc, there isn't any limitation on this aspect.

    https://learn.microsoft.com/en-us/connectors/dynamicsax/ 

     

    Best Regards,

    Hen Wang

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard