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

SharePoint Multi choice column calculations

Good afternoon

 

how to create a variable within an application and a selection field and a quantity field

In this case, the total value below is the product of the item record selected by the user with the value entered by the user

It is not possible to assemble a variable that reads the selection data of the registered item

Can you help me

 

Attached images.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

Hi @Jonhnatam ,

Looking at the material you have sent, the value of the Variable should be

Set(
   VarValorTotal; 
   Value(DataCardValuel4.Selected.Especificaçâo) * 
   Value(DataCardValuel3.Text)
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Community Support
Community Support

Hi@Jonhnatam,

 

Based on the issue you mentioned, you want to assemble the Total variable that reads the selection data of the registered item.

 

Do you want to assemble the Total variable when you manually enter text or select options in your combo box? I have a test on my side under this premise.

 

Specific content you can refer to the attachment

 

Note: “DataCardValue14” is control rather than a value that can not be directly used to calculate.

 

Please modify your formula like this:

 

Set(VarTotal,If(IsBlank(DataCardValue7.Selected.Value),DataCardValue7.SearchText,DataCardValue7.Selected.Value)*Value(DataCardValue8.Text))

 

 operation.gif

Contact me if there is any doubt.

 

Best Regards,

Qi Qiao

View solution in original post

5 REPLIES 5
Super User III
Super User III

Hi @Jonhnatam ,

Looking at the material you have sent, the value of the Variable should be

Set(
   VarValorTotal; 
   Value(DataCardValuel4.Selected.Especificaçâo) * 
   Value(DataCardValuel3.Text)
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Community Support
Community Support

Hi@Jonhnatam,

 

Based on the issue you mentioned, you want to assemble the Total variable that reads the selection data of the registered item.

 

Do you want to assemble the Total variable when you manually enter text or select options in your combo box? I have a test on my side under this premise.

 

Specific content you can refer to the attachment

 

Note: “DataCardValue14” is control rather than a value that can not be directly used to calculate.

 

Please modify your formula like this:

 

Set(VarTotal,If(IsBlank(DataCardValue7.Selected.Value),DataCardValue7.SearchText,DataCardValue7.Selected.Value)*Value(DataCardValue8.Text))

 

 operation.gif

Contact me if there is any doubt.

 

Best Regards,

Qi Qiao

View solution in original post

Hi @Jonhnatam ,

My initial response was a correction of the formula you supplied - happy to continue the conversation further to achieve your outcome.

Tag whichever response you wish to continue the thread.

 

Thank you! the proposed solution worked, a big hug

Thank you

the proposed solution worked

a big hug

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (35,624)