Share
Report
10Hi all,
I am running a PowerBI on button click command which imports a list of items (~200) from PowerBI to a sharepoint list. This button will be clicked everyday to import these items from PowerBI to a sharepoint. We expect the sharepoint to be housed with at least 2-3 months worth of data (4000-6000 entries) before building an archival function.
It is expected that there may be around 70-80 duplicates values in columns A, B and C, and I would like to do a few things:
1) if duplicate detected in A, B and C, pull the row out and check for the following:
2) is column D a duplicate?
3) If column D is also a duplicate, delete the new entry entirely
4) If column D is not a duplicate, update the old entry with the new value in column D. After updating, delete the new entry entirely.
I have tried using the inbuilt condition function but due to the number of items we expect in the sharepoint, the iteration takes very long to complete. I would appreciate any sort of feedback to achieve the above intention while maintaining the performance of the flow.
All responses (
Answers (
