Answered

How to make a cell editable only if in a new form

(0) Share

Report

Posted on by jdrm1

I have a form where once it has been saved if they go back to edit that form anything that has data in cannot be editable but anything blank they can edit.

I have tried the below is the display mode of the field that they type in but getting an error:

If(
IsBlank(ThisItem.Datcardvalue65.text),
DisplayMode.Edit,
DisplayMode.View
)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Try: If(IsBlank(Self.Text), DisplayMode.Edit, DispalyMode.View)

This would be on the actual input where the text goes.

Was this reply helpful? Yes No
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

that works but then when you typing in the box it suddenly changes it to view before you have finished mid typing

Was this reply helpful? Yes No
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe I need it to look at the data source to check if it can see anything that way when typing it should not suddenly change before they click save

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jdrm1 ,
If you are using a form control, try below -
If(
IsBlank(Parent.Default),
DisplayMode.Edit,
DisplayMode.View
)
OR

If(
FormName.Mode=FormMode.New,
DisplayMode.Edit,
DisplayMode.View
)
OR
If(
IsBlank(LookUp(DataSourceName, ID=<ID of the item>)),
DisplayMode.Edit,
DisplayMode.View
)

Was this reply helpful? Yes No
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

What do you mean by ID of the item? how do I check that.
Also just so you know you should not use a capital R in Or

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jdrm1 ,
Apologies for the confusion. You can use any formula from the below three options (I would suggest to go with option 1) -
1. If(
IsBlank(Parent.Default),
DisplayMode.Edit,
DisplayMode.View
)

2. If(
FormName.Mode=FormMode.New,
DisplayMode.Edit,
DisplayMode.View
)

3. If(
IsBlank(LookUp(DataSourceName, ID=<ID of the item>)),
DisplayMode.Edit,
DisplayMode.View
)

Answering to your query, ID is current item ID (it will only be there in edit and view form). ID gets created when you create a new item. It's kind of a unique identifier.

Was this reply helpful? Yes No
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you that seems to work. I think I was making it more complicated than need to.

Was this reply helpful? Yes No
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

I know you got that working, but just realised if it is yes no slider option that changes it to text and then you can no longer use the slider. Any ideas?

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @jdrm1 ,
Do have a toggle control (yes/no) in your form which is responsible for visibility (hide/show) of "Datcardvalue65" control and you want to incorporate this control in the formula?

Was this reply helpful? Yes No