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!
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
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?
Hi @IamJustAlex ,
For deleting the items part, please refer to below demo:
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.
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