If you want to update the existing item in the SharePoint list instead of creating a new one when you send the same data from the Power BI

If you want to update the existing item in the SharePoint list instead of creating a new one when you send the same data from the Power BI report. This is certainly possible with Microsoft Flow.

Here are the steps you can follow to update the existing item in SharePoint list:

1. Create a Flow with a Trigger:

   • Start by creating a new flow or editing your existing flow.

   • Set up the trigger as per your requirement (either automated or instant with a button).

2. Get Data from Power BI Report:

   • Add a new step and choose "Power BI."

   • Use the "Get rows" action to retrieve data from your filtered Power BI report.

   • Configure the "Get rows" action by specifying the workspace, dataset, and table.

3. Check if Item Exists in SharePoint List:

   • Add a new step and choose "SharePoint."

   • Use the "Get items" action to retrieve items from your SharePoint list.

   • Use a filter query to check if the item you want to update already exists in the list.

4. Update or Create Item in SharePoint List:

   • Add a condition to check if the item exists in the SharePoint list.

   • If the item exists, use the "Update item" action to update the existing item in the list.

   • If the item does not exist, use the "Create item" action to create a new item in the list.

5. Save and Test Your Flow:

   • Save your flow and test it by triggering it manually or waiting for the automated trigger to occur.