如何添加和显示后缀m＆＃xb2;到PowerApps中的SharePoint编号列

发布于 2025-02-11 17:12:53 字数 522 浏览 1 评论 0原文

在SharePoint列表中，一列被声明为数字，并使用SharePoint自己的“后缀添加工具”，我将m²分配给列值。然后，输入 1000 在列表视图中正确显示为 1000m²。

但是，在以源为源的PowerApps自定义表单中，同一DataCardValue仅显示为 1000 ，而无需显示m²。

dataCardValue默认格式设置为=＆gt; textformat.number

...我已经尝试了几件事以显示 1000m²，无效：

TextFormat.Number & "m²"
Parent.Default, "m²"
Text(Parent.Default, "m²")
DataCardValue3.Text & "m²"

有人对此有解决方案（没有添加额外的标签）？非常感谢

原文

In a SharePoint list one column is declared as numeric, and with SharePoint's own "suffix adding tool" I assigned m² to the column value. The input 1000 is then correctly displayed in the list view as 1000 m².

But in the Powerapps customized form with this list as source, same DataCardValue is displayed only as 1000, without displaying m².

DataCardValue default Format-Setting is => TextFormat.Number

...and I have already tried several things with it to display 1000 m², none works:

TextFormat.Number & "m²"
Parent.Default, "m²"
Text(Parent.Default, "m²")
DataCardValue3.Text & "m²"

Does anyone have a solution for this (without having to add an additional label)? Many thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

梦与时光遇 2025-02-18 17:12:53

您可以在输入顶部添加标签。然后根据formmode有条件地显示/隐藏标签。在将数据输入表单（又称编辑模式）中时，用户不会看到“m²”，但是当表单处于视图模式时，他们会看到“m²”。

如果这是一个选项，则将格式从数字更改为文本将允许您这样做。

您也可以在SP列表中使用列格式添加后缀：

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "='@currentField' + 'm²'"
}

< img src =“ https://i.sstatic.net/wclyx.png” alt =“在此处输入图像说明”>

You could add a label on top of the input. Then conditionally show/hide the label based on the formMode. Users wouldn't see the "m²" when entering data into the form (aka form in edit mode), but they would see the "m²" when the form is in view mode.

Changing the format from number to text will allow you to do it, if that's an option.

You can also use the column formatting in SP list to add the suffix:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "='@currentField' + 'm²'"
}