SharePoint Multi choice column calculations

[Jonhnatam]

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.

[WarrenBelz · Accepted solution]

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.

[v-qiaqi-msft · Accepted solution]

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))

 

Contact me if there is any doubt.

Best Regards,

Qi Qiao

[WarrenBelz]

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.

[Jonhnatam]

Thank you! the proposed solution worked, a big hug

[Jonhnatam]

Thank you

the proposed solution worked

a big hug