Forum Discussion
file replace automatically
i get date from sharepoint folder and there will be 2 file for the 1 Powerbi Table. and the 2 file is version 1 and version 2. Now the default is the version 1 and version 2 file will be "append "
for example:
the version 1 data:
| filename | Date | Vendor | product | QTY |
| Version20231005 | 2023-10-05 | A | iphone 14 | 10 |
| Version20231005 | 2023-10-05 | A | iphone 15 | 20 |
| Version20231005 | 2023-10-05 | B | iphone 15 | 2 |
| Version20231005 | 2023-10-05 | C | iphone 12 | 4 |
| Version20231005 | 2023-10-05 | C | iphone 13 | 3 |
| Version20231005 | 2023-10-05 | D | iphone 14 | 6 |
| Version20231005 | 2023-10-05 | D | iphone 15 | 9 |
the version 2 data :
| filename | Date | Vendor | product | QTY |
| Version20231025 | 2023-10-25 | A | iphone 14 | 3 |
| Version20231025 | 2023-10-25 | A | iphone 15 | 3 |
| Version20231025 | 2023-10-25 | C | iphone 12 | 3 |
| Version20231025 | 2023-10-25 | C | iphone 13 | 3 |
| Version20231025 | 2023-10-25 | D | iphone 14 | 3 |
| Version20231025 | 2023-10-25 | D | iphone 15 | 3 |
what i want is when there is only version 1 file existing ,the table just get the version 1 data
when there are version 1 version 2 existing, just keep the version 2 ( means keep the latest date file) , which means for the above 2 version file ,i only need the version 2 data,as it has the later date.
is there any way to achieve this?
When you connect to the sharepoint folder, you sort the file list by an appropriate criteria (for example file name descending) and then you grab the binary of the first row, like #"Sorted Rows"[Contents]{0}
2 Replies
When you connect to the sharepoint folder, you sort the file list by an appropriate criteria (for example file name descending) and then you grab the binary of the first row, like #"Sorted Rows"[Contents]{0}
sounds a practicable approach ,i will try that and accept this as a solution when it works.
