Answered

Datacard value not showing

(0) Share

Report

Posted on by BrigitteL

Hi all,

I have a Sharepoint Form built using PowerApps and I'm having issues with only one datacard when re-opening an already existing record. If I open the form for an existing entry (let's say Record 1), this shows correctly except for an amount datacard which is shown as empty in the form. However, if I look at the Sharepoint list, Record 1 has a corresponding amount.

I think the issue is limited to the specific datacard in the form, but I can't spot where. The Datacardvalue is set as visible, and the "DisplayMode" property is Parent.DisplayMode.

Has anyone any idea of where the issue may be?

Thanks in advance

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@BrigitteL

What modifications, if any, have you made to the DataCard?

What do you have in the Default property of the DataCard?

What is the data type of the SharePoint field bound to the DataCard? e.g. Single Line Text, Choice, Date etc
BrigitteL 21 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Amik,

Thank you for your response.
Please see the below answers.

What modifications, if any, have you made to the DataCard? The modifications done were to allow number formatting to show thousand separator
Within this datacard group I added TextInput1
Its Default property is
Text(Value(DataCardValue19.Text),"#,##0.00")
Amended Default property of DataCardValue19 to
UpdateContext({VarTempTextInput:Text(Value(DataCardValue19.Text),"#,##0.00")})

What do you have in the Default property of the DataCard? VarTempTextInput

What is the data type of the SharePoint field bound to the DataCard? e.g. Single Line Text, Choice, Date etc
The type shown in the Sharepoint list settings for this field is Number
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@BrigitteL - I do not understand how you are deriving "VarTempTextInput",

However, before getting into that. As I understand it, you want to display formatting of the Data Card Value to display numbers with a thousand separator.

If that is all you want to do, I suggest we took a step bac, and focused on what you're trying to do, rather than trying to fix your solution:

It is not currently possible to apply number formatting to a Text Input control. Consider the following workaround:

1. Remove the DataCard from your Form

2. Add the DataCard back into your Form

3. Unlock the DataCard

4. Inside your DataCard, add a Label control.

5. Adjust the height, width and position properties so that it matches the DataCardValue field.

6. In the Text property of the Label, use:

Text(Value(DataCardValue1.Text),"#,#")

On the Visible property of the Label, use:

'Your Form'.Mode = FormMode.View

For the Visible property of the DataCardValue, use:

'Your Form'.Mode = FormMode.Edit
BrigitteL 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Amik,

The suggested solution works when displaying an existing record, but when trying to create a new record it doesn't look like I can type in that field.
Also, I was wondering if it would be possible to show the comma separated number while editing, or creating a new entry.

Thanks in advance
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrigitteL - I suspect the reason is not because of the suggested solution, but because you made some additional modifications I am not aware of. I would start by looking at the DisplayMode property of the text input field.

Regarding the 2nd question, as already stated, it is not currently possible to apply number formatting to a Text Input control (which is why we're using this workaround in the first place).