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
Super User III
Super User III

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
Super User III
Super User III

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
Super User III
Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,917)