Sharepoint List Calculated Number column showing as type TEXT

(0) Share

Report

Posted on by FoDelement

435

Hello all,

I have a sharepoint list that has a calculated column with that returns a "Number". However, in Powerapps, this column shows up as a text column, so I cant use math functions against it. (And more importantly, it's not delegatable)

Is this by design, or a bug?

Sharepoint treats it as a number.

But PowerApps sees it as text.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Wrap the Test in the formula with value like;

&& Value(TEST)>0

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
FoDelement 435 on at

Like (0)

Report
Copy link

Link copied!

Hello!

I know this will fix the fact that it's a text column and not a number column, but this does not make it delegatable. 😞

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Create a collection Onvisible of the screen:

ClearCollect (ReclaimWf, 'Reclamation Workflow')

The replace the Datasource in your formula with ReclaimWf

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi there is the column in sharepoint indeed a number. the behavior is not normal or by design.

the sorting will behave that way on text and a number, can you please check that list setting in SharePoint. Your code should work

Was this reply helpful? Yes No
repatt01 10 on at

Like (0)

Report
Copy link

Link copied!

Hi I think I am having a similar issue, I have a sharepoint list that has a calculated field Hours*Rate returns a total, all have been set to return a number. I am trying to populate a word document with Sharepoint list fields and the number are not maintaining formatting, specifically currency fields.

I have built a workflow that uses numberformat that properly formats an output of the rate field and places in a word document formatted as a currency. However when I try the same with calculated column "Total" I get an error message:

Is there a work around, or code that I am missing.

Was this reply helpful? Yes No
repatt01 10 on at

Like (0)

Report
Copy link

Link copied!

Specially as it relates to the calculated fields

Was this reply helpful? Yes No