Skip to main content

Notifications

Power Apps - Building 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:
  • HenWang Profile Picture
    HenWang on at
    Re: How to show a full D365FO table in a SharePoint List including clearing table first?

    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

  • TestyGoingToDoIT Profile Picture
    TestyGoingToDoIT 12 on at
    Re: How to show a full D365FO table in a SharePoint List including clearing table first?

    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

     

  • Verified answer
    HenWang Profile Picture
    HenWang on at
    Re: How to show a full D365FO table in a SharePoint List including clearing table first?

    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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard