Answered

Change sharepoint data value from checkmark to be Yes or No

(0) Share

Report

Posted on by etharAli

I would like to change the display to yes or no instead of a checkmark. Here is a couple of the change I mad but the issue still exists:

1- Changed the true text property to" Yes"

2- Changed the false text property to "No"

3- Changed Update property to be datacradvalue.Value. " The actual name of the data card is test".

4- On select, I used If statement " If(test.Value= true, "Yes", "No")

I still see the data stores in SharePoint as a checkmark. Please help !!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@etharAli

This has nothing to do with your app or PowerApps. If it is a Yes/No column, then from PowerApps you should only be setting it to true or false.

This has everything to do with your SharePoint list view.

If you want it to appear as Yes or No, then set the JSON formatting of that column in your list definition to:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(@currentField, 'Yes', 'No') " }

I hope this is helpful for you.

Was this reply helpful? Yes No
etharAli 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!! The data is showing now as Yes / No in the Sharepoint list, but when I call the data from the SharePoint to be displayed in another power app screen, it still shows as true/ false.
Please advise what I should do in this case. ?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@etharAli

Showing it in PowerApps is something different as well.

Your column, being a Yes/No column, will always be either true or false.

If you want to format differently, then you need to employ a formula such as:

If(yourColumn, "Yes", "No")

Where yourColumn is reference to the column value.

So, for example, if you are showing this in a Gallery, then your Label text property should be:

If(ThisItem.yourYesNoColumnNameHere, "Yes", "No")

Was this reply helpful? Yes No
etharAli 40 on at

Like
a
(0)

Report
Copy link

Link copied!

I need to use the data to be displayed inside the RichTextEditor. I'm not sure what property needs to be adjusted in this case ?
I use the code: " All data required ? {frSubmitRequest.LastSubmit.'All_Data _Required?'}" to pull the last submission from SharePoint and display it inside the RichTextEditor.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@etharAli

It would be as I mentioned...

{If(frSubmitRequest.LastSubmit.'All_Data _Required?', "Yes", "No")}

Was this reply helpful? Yes No