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

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

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

Community Support
Community Support

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.

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

 

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

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

Best regards 
Łukasz

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,215)