Brasil

How do I create a validation in which the user can only access the row after the data is saved and clicks edit. To be clear… the entry will only be visible for him to click edit. It’s because I want to make this line mandatory, however, only if the user clicks on edit data. On the first occasion it would be invisible to the user. There is a method

Can you share some visuals and explain a little more?

It sounds like you want a column to appear only after the row has been added: the column is not available while the user is adding the row, but is available if the user edits the same row again later.

Use this in the Show? or Editable? expression for the column:

IN([_RowNumber], Table[_RowNumber])

Replace Table with the name of the table. Every row has a _RowNumber column, but the value of that column only occurs in the table after the row has been saved. A new row has a _RowNumber value but the value won’t be in the table until the row is saved.

2 Likes

Now that you’ve explained it I get it. I used your recommended solution before. Good stuff :+1:

1 Like

You are brilliant! Thank you very much! It worked.

1 Like