Remove decimals from Artikel #

(0) Share

Report

Posted on by Rapaille

162

Hello all,

I'm a new Power Apps user and I'm trying to build an app.

I have a list 'A' which pulls the 'Artikel #' from list 'B' by using the lookup function. In list 'B' the format of the 'Artikel #' column is value with no decimals and the number is shown as 3014470.

When I want to display the 'Artikel #' on the detail screen, the value shows with 7 zeros after a period (3014470.0000000). I tried to figure it out for a long time, but no success.

Who can help me with this issue?

Thank you in advance for you kind cooperation.

Kind regards,

Hans

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
You could use either:

Round(ThisItem.'Artikel #',0)

or

Text(ThisItem.'Artikel #', "#")

Was this reply helpful? Yes No
lucarios1705 16 on at

Like (0)

Report
Copy link

Link copied!

for me was working the function: Round(Substitute(Gallery1.Selected.xxxx;".";",");0)

Was this reply helpful? Yes No
Rapaille 162 on at

Like (1)

Report
Copy link

Link copied!

Thank you both for your help. I tried all three options, but still same issue.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Ah ok, inside a datacard like that probably going to be able to use parent.default:

Round(Parent.Default,0)

or

Text(Parent.Default, "#")

Was this reply helpful? Yes No
Rapaille 162 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately still same issue.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, you've put that in the displaymode property (which should be its original value of DisplayMode.View), the formula needs to go into the Text property to replace the Text its currently showing

Was this reply helpful? Yes No
Rapaille 162 on at

Like (0)

Report
Copy link

Link copied!

For this field text is not present in the dropdown. Could you please help me with the correct option?

Thank you in advance.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What type of control is it? Could you please post a screenshot of the tree view on the left with that control selected?

Was this reply helpful? Yes No
Rapaille 162 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
hmmm,

We could do something like this for your items property, but you will need to replace my column names and datasource names with your own:

ForAll(Choices([@YOURDATASOURCE].YOURCOLUMNNAME), First(Split(Value, ".")).Result)

Was this reply helpful? Yes No