Unanswered

How not to update the "countrows/count if" formula when modifying a form ?

(1) Share

Report

Posted on by Alex_msb

Hello,

I am having issue with the "countrows"/countif formula. Indeed, I'm trying to have an automatic text written in a sharepoint list when creating a new form. The formula is like this :

"TSDL_" & Year(Today()) &" _ " & CountIf('Deviations';true)

Then I have a automatic codified list.

The problem occur when I try to modify any form created. The formula updates too. How can I solve this issue please ? I would like to count the row of the forms and not count every rows when modifying.

Thanks so much for any hints or help.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I assume you have two different buttons one for edit and one for create record.
just use a Variable to safe where you are comming from
//Create new Record Set(varNew, true) //Edit Record (Set(varNew,false)

And then just add an IF statement:
IF(varNEw, "TSDL_" & Year(Today()) &" _ " & CountIf('Deviations';true),Parent.Text)
Let me know if it helped you.
Alex_msb 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello thank you for the answer. To clarify, the create and edit buttons are directly in my sharepoint list. I cannot use a variable in the list I think.

Do you think there is a way to prevent an edit of the formula ?
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Maybe you could do it like this but I'm not sure you would need to test this.
If(IsBlank(Self.Text),"TSDL_" & Year(Today()) &" _ " & CountIf('Deviations';true))
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Just came to my mind can you display the CreatedOn column. If yes you can use it as a factor to create the logic. If it is Blank create the name otherwise do nothing or if the date is equal to today depending on how the column would be displayed.