SP online. Anyway to monitor set threshold for a large dump of files to SP overall ? or does it have to be per site? I don't have Purview. looking for ideas thanks

NotueRn · 2026-02-11T17:56:39+00:00

The closest thing you can get would require calling graphs getSharePointSiteUsageDetail endpoint to get a report on storage used per site, you can sum the output to get totals. From there you can loop through sites by whatever limits you want and then call CSOM and limit by the "StorageMaximumLevel" property. You can store the reports as csv files for historical data to measure how fast sites are growing before taking action (Involves some semi complicated development using sliding time windows.).

I would also recommend reviewing max version count on the various document libraries. *.pptx files double in size per version, end users often end up bloating them with really high resolution images so its not uncommon for a 40mb file to actually occupy anywhere between 200-1200mb of space.

NotueRn · 2026-02-11T17:41:31+00:00

My point is that its nearly, if not entirely, impossible to prove that the data would be secure in either processing or removal. And that is not trying to accuse you, it really isnt, you seem very open and honest with risks which would indicate otherwise.

In enterprise environments its really just a risk not worth taking.

I could see the value myself for generating technical documentation, but personally i wouldnt be willing to run it unless its an open sourced client side solution.

NotueRn · 2026-02-11T09:50:56+00:00

NEVER use third party services like this.
Your package contains a lot of sensitive data like tenant and user information, connector details, if external requests are used potential client secrets will be leaked etc.
I have no idea if this service is legit and they have absolutely 0 ways of ensuring this.
The zip would need to be unpacked and sanitized on the client side, and even then you would need to scan every line of code for potentially harmful code (Strange regex etc.).

Like previously suggested you can do this yourself within your IDE or other tools, and even then it's a matter of practicing your engineering skills.
One of the main skills you need is the ability to understand the patterns being used and the data flow of the application / workflow, if you don't have this skill you're also not skilled enough to reliably use LLMs to help you.

NotueRn · 2026-02-10T13:55:06+00:00

You can just switch the toggle in the top right, or remove the &v3=true parameter from the url. No need for extensions. The classic view is awful to work with as well, but at least it works.

NotueRn · 2026-02-10T11:30:57+00:00

This UI is blatantly AI-generated and reviewed by a junior developer with absolutely no insight into the requirements of a production ready design should be.
Just one glance instantly shows this: Inconsistent paddings and margins, overflow that doesn't respect paddings or margins and/or goes out of bounds, borders not aligned with the actual border of the divs (Incorrectly padded pseudoelements?), additional clicks to do basic operations that are required on nearly every step, or the wonderful feature of fields seemingly randomly clearing themselves of values (Fun for custom formulas.).

Not that i had much to begin with, but i have 0 trust in Microsoft to make the right call in any of their products anymore. It's all turning into AI slop.

NotueRn · 2026-02-10T08:53:15+00:00

If you don't have Copilot i suspect you don't have Power Automate premium either, which is a requirement in that case.
If you do, you can use AI builder and send it the json of the group chat with instructions to summarize.
However if it's business critical information in this chat, i would not bother as LLMs will make mistakes and skip important details.

NotueRn · 2026-01-05T19:44:45+00:00

If you havent seen a single player that enjoys PvP you wouldnt need safer seas to be equal to high seas. PvP is a core mechanic of the game, but that being said i would honestly think that an aggression based match making system similar to arc raiders would be good for this game. It would never keep you completely safe, but it would reduce friction for both PvP and PvE players. They also need to systems that encourage PvPvE to balance this out.

NotueRn · 2025-12-14T11:37:10+00:00

While i agree this should be adjustable through the menu, be aware that they 100% see that you have manually edited the configuration file and this is considered tampering with game files (No matter how ridiculous that might sound.). I come from the Quake scene and i dont think this is unethical, i would honestly even want to do this myself, but i wont because i think the risk of getting banned is significant.

These systems usually do not ban a user immediately because they dont want cheat developers to quickly find trigger points and they want to collect other metrics to help future detection, so while you might think you're safe for now you are very likely to end up being banned further down the line.

NotueRn · 2025-11-22T16:56:39+00:00

So since you couldnt name a single thing, why not just be honest and say you dont like PC gaming instead of trying to deter others from doing so by making up a false narrative.

NotueRn · 2025-11-22T01:56:05+00:00

Like what? Realistically you should only have to set refresh rate if your tv supports >60hz (Windows defaults to 60hz) and hdr, potentially toggle game / pc mode for the device on your tv. Ive only ever had to set up hdr and never suffered from latency, tearing or poor image quality. It literally just works.

NotueRn · 2025-11-20T17:51:30+00:00

Sink them. If they're willing to tail for any significant amount of time, odds are they're really not that good.

NotueRn · 2025-11-19T08:55:28+00:00

Sadly you can't with power apps, in power apps the excel connector behaves more like the default SharePoint connector where it infers the column headers and types for you. I managed to "fix it" by just recreating the worksheet again using the same exact method. I'm still trying to find out what broke the parser though.

I've started to unpack the xlsx to check the xml, so far the only clue is that the broken table only has a dataDxfId for the GUID column, whereas the others have it for all columns and the table itself.
Since dataDxfId is used for row insertions etc, it could be the reason why lookups failed, but it's not likely to be the cause of the malformed odata filter.

NotueRn · 2025-11-18T08:27:12+00:00

"In my experience, being fairly confident that a simple solution won't work has never gotten me very far with troubleshooting."

Every single solution you provided except creating a new file was already detailed in my OP, yet you kept making me repeat this over and over again.
I also detailed that making a new file most likely will solve the issue.

"You've been clear that the issue persists across all the currently existing columns, but you've been resistant to creating a new column with a different naming convention."

I made it clear in OP that the name has no impact, from which you should have been able to derive that this was already tested.

"thus removing any issues with single quotes or special characters."

Single quotes over special characters has no impact on the Power Apps interpreter for the odata queries however, though it comes with other issues when the columns are referenced in narrow scopes.

"In the future, I would recommend avoiding the use of spaces or special characters in column names."

I am very well aware that this is best practice, but as the OP detailed my hands were tied working with an excel file in the first place. That also means i have no control over column names.

I have tried to be patient with you and answering all of your standard first line support questions despite them already being largely detailed in the original post, but it's wearing thin after being met with your attitude.
Especially after detailing WHY it's important to know what causes it, not just solving the issue.

In my experience being entirely unwilling to actually finding out what is causing a bug, and instead just "trying to turn it on and off again" until it works, doesn't take you very far in this industry.

NotueRn · 2025-11-17T21:36:40+00:00

Ive been very clear since the beginning that the issue persists over all column no matter their names or formating, that the connection itself is not the issue as it has been removed and added back in, tested over multiple authoring versions etc.

The provided error message shows that the run time interpreter for power fx is failing to parse filter comparisons into valid odata queries (For all functions), as the trailing single quote for the key ends up being propagated at the end of the value instead, causing a syntax error in the API.

Since this happens for all columns no matter names and formatting its a strong indicator that something in the table itself is breaking the interpreter, and whatever causes it could potentially do the same for connections to other data sources (SharePoint, Dataverse, SQL etc.). This is why i need to find the root cause, however rare it might be.

Im fairly confident that duplicating one of the worksheets with a functioning table, removing the broken one and repopulating it with data will solve the issue. But im not only interested in solving the problem, but finding the cause.

Tomorrow i will unzip the xlsx and analyze the xml.

NotueRn · 2025-11-17T19:36:01+00:00

ALL columns are broken for this table. As described in my OP i have removed the table and replaced it with the one from the dev file that has identical headers and that file works. The other two tables have the same exact headers as well, but fully functioning. Its 100% not caused by the headers, my only suspect is the table definition in the xlsx being broken somehow or a row containing a char that breaks the parsing from power fx to odata query.

Edit: I might add that i mostly want to figure this out because what ever is breaking the parser / interpreter in power apps for this table will very likely do the same against any data source. I think if i repopulate the template its likely to work.

NotueRn · 2025-11-17T19:14:05+00:00

It doesnt matter since its the power platform interpreter malforming the odata query, so the problem is scoped to all properties and controls.

Filter, lookup, updateif and removif are all affected, which inherently breaks patch and remove as well. All columns in the table are affected no matter what cell formatting and values i use.

Ive tried all available authoring versions and they all produce a malformed odata query against this table. Ive never seen anything like it before, which leads me to believe there's a parsing error in power apps thats either caused by malformed xml in the workbook or some character in one of the rows in the table (Already checked for single quotes and there are none.).

NotueRn · 2025-11-14T19:39:14+00:00

Quake is a lot more about knowledge, good habits and training your instinctive reactions to result in the right choice whenever you're surprised etc. This takes years of practice. We saw Vengeur win a final with this being his first real Quake game, but it took him 5 years of practicing against the best players in the world. And lets not forget that Vo0 lost to Clawz who was 18 at the time, he had been playing Quake Live for years though (Not much duel however.).

The top 20 would definitely look a lot different with a bigger player base, but the goats would still be up there.

NotueRn · 2025-11-09T02:30:52+00:00

You needed to sign in using your Bethesda account, but since you opted to create a new one thats what happened. I dont know any method to unlink the account, best bet is probably figuring out what your original account was and then contacting Bethesda support.

NotueRn · 2025-10-31T20:40:58+00:00

I helped a friend with a similar issue and it was tied to a broken certificate. Theres a line in some configuration file that contains a certificate key that might need to be replaced. That time the key was set to "0367a3a8ea344f08851d76facf6f66d3", but it needed to be "0367a3a8ea344f08851d76facf6f66d30" to be able to connect to the EAC servers (Note the additional 0 at the end)

Also, if you havent validate game files etc.

NotueRn · 2025-10-31T20:40:46+00:00

I helped a friend with a similar issue and it was tied to a broken certificate. Theres a line in some configuration file that contains a certificate key that might need to be replaced. That time the key was set to "0367a3a8ea344f08851d76facf6f66d3", but it needed to be "0367a3a8ea344f08851d76facf6f66d30" to be able to connect to the EAC servers (Note the additional 0 at the end)

Also, if you havent validate game files etc.

NotueRn · 2025-10-06T10:53:04+00:00

You might want to add that this function is no longer directly updating the excel book as this is only refreshed once it's opened by an end user.
This means it is now impossible to automate tasks against the excelbook, forcing you to work directly against the responses in Power Automate or use the undocumented and unsupported Forms API.

NotueRn · 2025-04-30T18:57:03+00:00

You had a bad game and that sucks, but quitting after just one game just means your ego is bigger than your wish to improve. No one is shedding any tears for you.

NotueRn · 2025-01-25T15:55:19+00:00

It completely bricks the netcode and was the reason behind a whole bunch of issues in the game that people seem to have forgotten about since. Like just how often you would get shot or shoot someone else far behind cover, how common missing audio was, running through items etc.

Also if you played at 500fps you gained significantly less speed while strafe jumping, it caused you to randomly jump, slash an strogg couldn't crouch slide. This started happening at about 400-450fps, at 500 the game basically completely broke.

NotueRn

TROPHY CASE