Forum Discussion
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 archived (i removed their licenses and changed their display name to Archived - FirstName LastName). For some reason only half the rows the user created have changed to Archived - FirstName LastName and the others are still pre archived FirstName LastName. So the custom columned i created as a step (column called Employee) that has the Author Columns First Name and Last Name extracted and combined ie Employee = [Author First Name] & " " & [Author Last Name] all the non changed names now show as Error? I cannot figure it out. I do not wish to delete the data and everything i have tried fails?
Also i have tried Changing the name back and then archiving again and the same issue occurs in the same rows? WTF?
Anyhelp?
2 Replies
whitchResolver I
I'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 ...
PowerBiNoob37Nah, 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..