Unanswered

SharePoint Yes / No field appearing in display form as True / False

(3) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have created a PowerApp that connects to a SharePoint list.

The SharePoint list is just used to create a daily check list and virtually all the fields on the list are of type Yes / No.

When adding / editing a list item via the PowerApp everything appears correctly, but when viewing the form in the PowerApp display mode the options appear as True / False?

I want them to appear as Yes / No as this is what the user selected and it is inconcistent to then ask them to view forms that are full of True / False.

has anyone experienced this issue before? The only options for the Yes / No field in the display for is the toggle option, or the text option (True / False)

Any help on this issue would be greatly appreciated.

Thanks,
Chris

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Chriscolohan,

Thanks for your feedback.

I have an app based on SharePoint list, about the Yes/No(check box) column type, I am getting the same issue with you.
>On the Browse Screen, it is shown as true/false.

>On Display Screen, there are two options for the Yes/No field, View Text(true/false) and View Toggle.

>On Edit Screen, there are four options for the Yes/No field, Edit Options(Yes/No), Edit Toggle, View Toggle, View Text(true/false).

So the Yes/No field is inconsistent on each screen. As a temporary, may I suggest you use Toggle instead of using Viet Text or Edit Options? As we can easily understand what it means. I am trying to report this issue from my side, and I will back to you once I got any response.

Best regards,
Mabel Mao
rklbrady 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Have you found how to change this? I am having the same issue and it is causing some confusion in both appearance and in coding the visibility of other cards for me.

Thanks!
nickduxfield 497 on at

Like
a
(1)

Report
Copy link

Link copied!

For sharePoint Lists.
If the amount of columns are small say 1-3.
Create a calculated column at the site columns level preferrably in the content type. If you cant get to those, just add one in for each item in the list. If(BooleanColumn1=True,"Yes,"No")

Tackle all of them with an ifstatement on the Display Form with the Boolean control set to ViewText instead of toggle.
Now go to the default field: If(ThisItem.Boolean=true,"Yes","No")
yhlow 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I use Json for the column formatting with some help from the team is work perfectly. https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#style-guidelines ============== Yhlow 20 hours ago how to replace the Boolean display as true/false to something like "active/inactive" ?Edit (0) DeleteLikeReply Avatar for AmyH_ms AmyH_ms 4 hours ago @yhlow { "elmType":"div", "txtContent": { "operator": "?", "operands": [ "@currentField", "Active", "InActive" ] } } LikeReply Avatar for yhlow Yhlow 46 minutes ago Thanks @AmyH_ms is work.Edit (0) =======================================
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried to change control of the Yes/No to another one?
yhlow 36 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous
powerapps and sharepoint
Hope this is help, as display in powerapps as enable/disbale and same to sharepoint list view. but the actual is boolean yes/no.
041780957 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow man it's cool it's work for me.. thank you dude
mstavra 247 on at

Like
a
(0)

Report
Copy link

Link copied!

I know that this is a very old question but since i wanted also to change the printing result from true/false to yes/no i used the following formula on the label i print the result:

Text: If(ThisItem.Training ,"Yes","No") where training is the yes/no column on my sharepoint list.