cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Dependence of parameters on each other

Hi
My data source is the SP list which contains many parameters.

I want to write a formula that depends on whether the "Nr pierscienia." parameter has a completed parameter, e.g. "NrC"
I would like to receive the value "true" if the parameter named "Nr pierscienia" contains the parameter "NrC" and if it does not contain "false"
Is it possible to write such a condition?

Best regards

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Dependence of parameters on each other

Hi @LukaszM ,

Do you list the "NrC" up to "NrA" using a Gallery?

Do you want to display the values for the "NrC" up to "NrA" in your Gallery based on the entered "Nr pierscienia" value?

 

Based on the needs that you mentioned, I think the If function could achieve your needs. Please consider take a try with the following workaround:

Within the Gallery, set the Default property of the Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.ColumnName,
   Blank()
)

 

If you do not use a Gallery control to list the "NrC" up to "NrA", please consider set the Default property of each Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrC',
   Blank()
)
If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrE',
   Blank()
)
If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrD',
   Blank()
)

...

...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Resident Rockstar
Resident Rockstar

Re: Dependence of parameters on each other

When you say ""Nr pierscienia." parameter" do you mean a column named "Nr pierscienia."?

 

In other words, you have a SP list and you want to receive a true/false based on whether or not the column "Nr pierscienia." says "NrC"?

 

If so, in SharePoint you can create a calculated column in the list. See my attachment. You can use a formula that returns true/false 
based on whatever you need and then use that column in PowerApps.

Here are formula examples: https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

Highlighted
Community Support
Community Support

Re: Dependence of parameters on each other

Hi @LukaszM ,

Do you want to check if the "Nr pierscienia" column (in your SP List) contains the specific "NrC" value?

 

I assume that you add a Gallery control in your app to list all available records from your SP list, is it true?

 

Please consider add a Label within above Gallery, set the Text property to following:

If(
    "NrC" in 'Nr pierscienia',
    "true",
    "false"
)

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I
Helper I

Re: Dependence of parameters on each other

Hi

Yes, I have galleries in my application. I wrote it wrong earlier, sorry.
I want to enter a value in "Nr pierscienia" and I would like to receive a value for "NrC" if the given "Nr pierscienia" has it and if it does not display anything.

Example:
1. In the sharepoint list I have a "Nr pierscienia" with a value of 22, I would like me to display the values for "NrC" up to "NrA"
2. However, if I enter in the "Nr pierscienia" a value of e.g. 30, which I do not have in the SP list, I want to have an empty field
Is it possible to do this?
At this moment he reads me the last value from the SP list.

In attachment :
- main view

Best regards

 

Highlighted
Community Support
Community Support

Re: Dependence of parameters on each other

Hi @LukaszM ,

Do you list the "NrC" up to "NrA" using a Gallery?

Do you want to display the values for the "NrC" up to "NrA" in your Gallery based on the entered "Nr pierscienia" value?

 

Based on the needs that you mentioned, I think the If function could achieve your needs. Please consider take a try with the following workaround:

Within the Gallery, set the Default property of the Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.ColumnName,
   Blank()
)

 

If you do not use a Gallery control to list the "NrC" up to "NrA", please consider set the Default property of each Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrC',
   Blank()
)
If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrE',
   Blank()
)
If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrD',
   Blank()
)

...

...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: Dependence of parameters on each other

Hi  ,
I  am using Gallery and I chose first proposition.
Thank you for your solution.

Best regards 
Łukasz

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

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

Top Solution Authors
Top Kudoed Authors
Users online (7,362)