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

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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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