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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Inserting a file from ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Inserting a file from SharePoint to Business central

(3) ShareShare
ReportReport
Posted on by CU18040422-0 6
When i Uploaded a file (pdf/doc/.xlsx) in SharePoint a power automate flow should auto trigger and the files should insert into Business Central Customized table.
The flow is working well except for one excel file. it is inserting multiple times into Business Central and that file is connected to external data source. Is there any way to resolve this issue.
Categories:
Dynamics 365 general
Power Platform integration
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,554 Super User 2026 Season 1 on at
    Good morning, afternoon, or evening depending on your location!
     
    Based on your description, the problem likely stems from the external data source connection in the Excel file, which may be triggering multiple updates or refresh events.
    Possible Causes & Solutions
    1. Check Power Automate Trigger Conditions
      • If the flow is triggered by file creation or modification, the external data source may be causing multiple updates.
      • Add a trigger condition to ensure the flow runs only when a new file is uploaded, not when the file is modified.
    2. Disable Auto-Refresh in Excel
      • If the Excel file is connected to an external data source, it may be refreshing automatically, causing multiple triggers.
      • Open the Excel file and navigate to Data > Queries & Connections to disable automatic refresh.
    3. Use a Unique Identifier in Business Central
      • Modify the flow to check if the file already exists in Business Central before inserting a new record.
      • Implement a lookup step to prevent duplicate entries.
    4. Monitor Flow Runs in Power Automate
      • Check the run history in Power Automate to see how many times the flow is executing.
      • If multiple runs are detected, adjust the trigger settings or add a delay to prevent rapid execution.
    5. Consider Using a Scheduled Flow Instead
      • If real-time triggering is causing issues, switch to a scheduled flow that runs at intervals to process new files.
     
    Hope this helps some!

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 Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 174

#2
ManoVerse Profile Picture

ManoVerse 58 Super User 2026 Season 1

#3
Niki Patel Profile Picture

Niki Patel 42

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans