cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Counter for Title in Sharepoint

Screenshot (20)_LI.jpg

 

 

 

Hello All,
I want a Counter for my List in Sharepoint for the Title. I have tried this, it works but If i delete an Item in Sharepoint, then this happends : (I delete Title 1 for example)
Title         ------> Title
1                            2

2                            3

3                           if I add new Count then it cames 3

 

I hope someone can Help me 🙂 Thanks.

 

9 REPLIES 9
Highlighted
Advocate II
Advocate II

Hello @Fatih1,

 

If I understood you right, the value will show three because you have the +1 after CountRows. If you remove "+1", it will count only the rows in the list. 

Highlighted

Hey NP1, I know that I need another way to make a counter for the Title.

Highlighted

Why? What doesnt work for you in CountRows?

Highlighted

If I delete the new entry should be get the highest title number. 

Highlighted

@Fatih1 

 

Could you please let me know wht is exactly your requirement?

 

Do you want the last entry +1 in title? OR, last saved+1? (even it is deleted)

Highlighted

let me explain with an example:

Title   (delete 2)                 Title

1                                         1

2                                         2

3                                         3

4                                         4 

5

 

So if I delete that the place is getting another one. 

OR

 

Title (delete 2)                               Title

1                                                       1

2                                                        3

3                                                        4  

4                                                        5

5

 

One of this two options i want 

 

Highlighted
Community Support
Community Support

Hi @Fatih1 ,

Do you mean that the count function counts include blank value?

If so, I suggest you try this formula:

CountIf(Besucher,!IsBlank(Title))

If you use countif function, you could exclude the items that have empty value.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

 

So If I count Title everything is okey. 

2.png

 

 

 

 

 

 

 

If I delete the Entry Title 1,


3.png

 

 

 

 

 

 

And put a new entry in my list, then this happens. I want that he show me Title 3, Not 2 again

Screenshot (29).png

 

Highlighted

@Fatih1 

 

To fulfill your requirment, there is another simple way,

 

Create a speerate list with only having Title field.

Update this new list title field with +1 every time when your main doc is submit.

Sets your main doc title field with value of existing counter title value from new list.

 

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,301)