Answered

Display No Data Entered in a blank person/group column in display form

(0) Share

Report

Posted on by KevinGador

822 Super User 2025 Season 2

I have fields in a display form. I want to recreate the ff:
If there is no data in the current item displayed, I want it to display like <No Data Entered>
The problem is that Hiring Partner is a person/group column type

This is the code i used for the request created in the display field(I know that the request created should have an input always, its just newly added this column that's why it has no value but you get my point)

If(
 IsBlank(Parent.Default),
 "<No Data Entered>",
 Parent.Default
)

How can I implement this in my person/group column type in display form?

I tried this but it doesn't work

If(
 IsBlank(<SOURCE>.HiringPartner),
 "No Data Entered",
 [<SOURCE>].HiringPartner
)

//SOURCE is just a placeholder for a sharepoint list

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

KevinGador 822 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
okay this worked. but I wanted to know how will this detect a blank value? am quite confused sry.

update had chatgpt explain it to me and for future viewers of this topic here is the explanation:

Here's the breakdown: Parent.Default: This is typically used to get the default value of a control from its parent container (like a form or gallery). If Parent.Default is not blank, it will be the result. {Value: "No data entered"}: This is a single-item collection with a property named Value having the value "No data entered". If Parent.Default is blank, this will be the result. So, the Coalesce function is essentially saying: "If Parent.Default is not blank, use it; otherwise, use the single-item collection {Value: "No data entered"}." This is often used when you want to provide a default value for a control, and if the parent default is not available (blank), you use a specified default value.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,512 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @kej ,

The formula I posted earlier should completely replace the formula you originally posted for the Default SelectedItems property ofthe Combo box (DataCardValue) as it should contain exactly the functionality you describe.

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hello. I am working with a display form that is connected to a gallery.
the display form items property is GalleryName.Selected, basically the display form will display the details of the gallery item selected

I wanted to check if there is a detail containing in ThisItems.HiringPartner which is a person/group column type in sharepoint list hence it added a dropdown when the display form was created.

the default items property of the HiringPartner datacard is

Choices([DATA SOURCE].HiringPartner)

now I want to display in the dropdown whether if the gallery item selected has no information input on HiringPartner(person/group type) then I will display No Data Entered in the dropdown

I tried using your solution but it doesnt work
please note that the value that was gotten from this can only contain 1 person.

this is the formula I tried with what you suggested that isn't working

If( IsBlank(Choices([DATA SOURCE].HiringPartner)), Coalesce(DataCardValue39.Selected, {Value: "No data entered"} ), Choices([DATA SOURCE].HiringPartner) )

Was this reply helpful? Yes No
BCBuizer 22,512 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @kej ,

To get this to work, you need to pass a record instead of a literal value. Also you can use the Coalesce function which will return the first non-blank argument, for instance:

Coalesce( Parent.Default, {Value: "No data entered"} )

Was this reply helpful? Yes No