Forum Discussion
PowerBiNoob37
Helper I
Helper IQuery Errors. Author Sharepoint Name Changed Archived user
Hi, I have an unusual error in which i cant seem to fix, i have a dashboard that grabs rows from SharePoint, recently it stopped working and i discoverd that one of my users that i recently archi...
whitch
Resolver I
Resolver II've had similar SharePoint issues in the past and been unable to fix them too. Can you amend your formula which is extracting the names to handle both cases? Something like:
if Text.Start([your field],8 ) = "Archived" then ... else ...
PowerBiNoob37Helper I
Helper INah, cause the error is in the inital grab. I ended up just archiving them all into a new list, the company only needs records for up to 5 years, so they 3 years old and basically useless for them at this stage, keeping the rows would have been preferable, however meh to this problem. I do believe you can go into powershell and change metadata though if your still having issues..