cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Christian91
Regular Visitor

Make an item calculated

Hi,

I have an application based on a sharepoint list and I would like an item to be calculated with two items. In the list the item "Frais km." is calculated by multiplying the value of the item "Puissance fiscale du véhicule" by "Distance parcourue". In the powerapps application, this item does not appear to be calculated. How to make "Frais km." calculated ?

I have put in the Text property of the item this value "DataCardValue18*DataCardValue19" but I get an error message "Invalid argument type. Expecting one of the follow type : Boolean, text or number".

 

 

Snap 2020-06-15 at 16.38.14.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Christian91 :

DataCardValue18.numberfiled

numberfiled is field name,for example:

1.JPG

List A is my data source.Title/statusActive/ColumnLinktoChec…… are filed name.

If you still can't solve the problem, please show me a screenshot of your data source.(Like my screenshot)

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

Best Regards,

Bof

View solution in original post

6 REPLIES 6
JayMagness
Solution Specialist
Solution Specialist

Hi,

 

This looks to me to be you are trying to calculate lets and numbers?

 

If you want send me an email and we can get on teams and look into your issues further jay@research-nest.com

v-bofeng-msft
Community Support
Community Support

Hi @Christian91 :

Could you show me the name and items property of these two controls?(combobox/textinput box)

1.JPG

Could you tell me what Puissance fiscale du véhicule's data type is?

Best Regards,

Bof

Hin

 

The name of Puissance fiscale du véhicule is "DataCardValue18". Here are its properties :

Snap 2020-06-16 at 09.05.45.png

 

The name of "Puissance parcourue" is DataCardValue19; here are its properties :

 

Snap 2020-06-16 at 09.23.54.png

 

The item Puissance fiscale du vehicule is an item from a SharePoint list. It displays text but returns a number.

 

Regards.

Hi @Christian91 :

Please try :

Value(DataCardValue19.Text)*DataCardValue18.numberfiled /*numberfiled is the filed name in Remboursement……*/

Best Regards,

Bof

Hi 

I get an error in the formula bar :

 

Snap 2020-06-16 at 10.05.02.png

Hi @Christian91 :

DataCardValue18.numberfiled

numberfiled is field name,for example:

1.JPG

List A is my data source.Title/statusActive/ColumnLinktoChec…… are filed name.

If you still can't solve the problem, please show me a screenshot of your data source.(Like my screenshot)

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,623)