cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Champion
Community Champion

Re: SharePoint Multi choice column calculations

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

Highlighted
Microsoft
Microsoft

Re: SharePoint Multi choice column calculations

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
Highlighted
Community Champion
Community Champion

Re: SharePoint Multi choice column calculations

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

Highlighted
Microsoft
Microsoft

Re: SharePoint Multi choice column calculations

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

Highlighted
Community Champion
Community Champion

Re: SharePoint Multi choice column calculations

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.

 

Highlighted
Regular Visitor

Re: SharePoint Multi choice column calculations

Thank you! the proposed solution worked, a big hug

Highlighted
Regular Visitor

Re: SharePoint Multi choice column calculations

Thank you

the proposed solution worked

a big hug

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,132)