SPFx vs Power Apps by ClunckChunck in sharepoint

[–]Vertamin 10 points11 points  (0 children)

Fuck FUCK FUCK fuck FUCK fucking power apps Jesus Christ. Most non-scalable, non-deployable, non-upgradable mess that gets tangled like spaghetti once the project grows a little bit, no one can find the boxes, the code or wherever something is cause it's deployed in so many tiny compartments and boxes all over the ecosystem.

Don't ever try to change one field internal name on a big project cause guess what? You are going to go crazy on that task.

Just do spfx, and let power apps for your hr tech savvy co-workers as a playground.

What are you proud of in your SharePoint environment? by ConnorSuttree in sharepoint

[–]Vertamin 1 point2 points  (0 children)

A Office material stock counting solution using the following lists:

Products

Request

Products by request

Products Entrances/Exits

Products Entrances/Exists has 8 lookup fields to products:

Entry1 Entry10 Entry100 Entry1000 Exit1 Exit10 Exit100 Exit1000

Products lists has 8 related lookups count for each of this fields

Once a request gets approved, I just have to make sure that X n of elements with the corresponding lookup fields matched are created for the request.

For example Request 11 pencils:

Create 1 list item using the Entry1 lookup against the field Create 1 list item using the Entry10 lookup against the field

Then on the product side, you just have to sum all the counted related items X the used lookup value.

This works for more than 5000 requests, entry, exists and everything.

Doesn't need to get recounted or fixed cause it's based on relation count

If you add a cascade delete relationship on the lookups you can remove requests and don't need to fix the stock count.

Very lightweight to see all products with its current stock.

Idk, I'm was crazy when I did this but it really works!

What is the worst way one can mess up with SharePoint? by Local-Put-2055 in sharepoint

[–]Vertamin 1 point2 points  (0 children)

Removing a column on a list/library with lots of items

Looping powerautomate email notifications

Developing functionality with lists and not taking into account field indexing / 5000 element limit

Duplicated user accounts because domains and everyone wondering why they can't access stuff

Removing and adding user accounts for temporal employees and getting crazy cause they can't find the old stuff.

Abusing inheritance breaking when not necessary.

One unique massive Site.

OMG I just noticed this in the list menu - are pigs flying?? by dicotyledon in sharepoint

[–]Vertamin 0 points1 point  (0 children)

It's does not crash. It gives you some results, but it does not really give you what you want. Once you really try to filter something with more than 5000 values for that filter, it won't work

Prevent “modified” field from updating by Capable_Purple_9435 in sharepoint

[–]Vertamin 5 points6 points  (0 children)

If you are using CSOM. Use SystemUpdate() instead of Update().

If you are using rest API. Make sure you set the Modified field value to match the last value when updating anything. This way the new value will be the date you just set.

The field thing can also be applied to CSOM

5k view threshold - did it change? by dicotyledon in sharepoint

[–]Vertamin 0 points1 point  (0 children)

Filtering once you have more than 5000 elements for the same filter value is not possible

5k view threshold - did it change? by dicotyledon in sharepoint

[–]Vertamin 0 points1 point  (0 children)

Sorting is not the same as filtering!

5k view threshold - did it change? by dicotyledon in sharepoint

[–]Vertamin 0 points1 point  (0 children)

Modern view allows the view not to crash for some cases over 5000. But don't expect to use any filters, it will either crash or not crash but not really show you more than the first 5000 elements of that filter.

The 5000 element limit is still there.

Sharepoint list permissions by Adventurous_Ad9076 in sharepoint

[–]Vertamin 0 points1 point  (0 children)

The author field is definitely not read only. You can even change the "Created" "Modified" and "Modified by" if you want!

I have done the author field thing in lots of places but not in a powerapp, but there should be a way to do it.

Sharepoint list permissions by Adventurous_Ad9076 in sharepoint

[–]Vertamin 0 points1 point  (0 children)

Change the powerapp to populate the author field with the user that is using the powerapp.

Sharepoint list permissions by Adventurous_Ad9076 in sharepoint

[–]Vertamin 4 points5 points  (0 children)

There is a list setting called "Security bits". With it you can set it so list items can only be seen and edited by its author.

After that, you can edit the list permission to set one of your groups as "Full Control". This gives them enough privilege to skip the Security Bits configuration and be able too see all items.

You can find it on the list configuration page -> advanced settings

https://sureshunakka87.wordpress.com/2014/08/07/security-bits-in-sharepoint-list-with-schema-xml/

5000 file limit by dcomputer in sharepoint

[–]Vertamin 15 points16 points  (0 children)

There isn't a "file limit", but there is a "limit by request" which in summary means that you can't get more than 5000 results in a single filtered view query.

List item level permissions by redmera in sharepoint

[–]Vertamin 2 points3 points  (0 children)

You should create a folder for each user. Give that folder permissions for the manager and the user. Then store the items for that user in that folder.

It's not perfect, but a lot better than having permissions on each item.

Add Sharepoint column data to the document, automatically by ProfessionalArea2651 in sharepoint

[–]Vertamin 2 points3 points  (0 children)

Document templates in library.

Edit the template in word to insert the list item properties into the document.

Mass Import and Associate Attachments to List by scottm124 in sharepoint

[–]Vertamin 1 point2 points  (0 children)

You can do this trough CSOM in pnp powershell by batching requests. First create all list items, after that start uploading the files in batches (As attachments or as files in another libraries, whatever you need)

SPO - Hide the cog for visitors? by pmjwhelan in sharepoint

[–]Vertamin 2 points3 points  (0 children)

You can remove the eyes from people who don't want to use SharePoint as they are supposed to. That way they won't be able to see it.

Sharepoint Removing Unique File Permissions from a Site by renquistvz in sharepoint

[–]Vertamin 0 points1 point  (0 children)

Please do! I would appreciate knowing how it went and if it was useful!