Unanswered

Automatic dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone

I have the following problem.
I would like the variable "Numer formy", which is "dropdown", to remember the last value and if the "Numer pierscienia" changes, to add + "1" to the last value.
In Items I gave ["1", "2", "3", "4", "7", "8"]
and on Onelect:
If (New ("Nrpier_x015b_cienia"), First(SortByColumns(Tubes_1, "Numer_x0020_formy", Descending).'Numer formy').'Numer formy'+"1", First(SortByColumns(Tubes_1, "Numery_x0020_kosza", Descending).'Nr pierścienia').'Nr pierścienia').
I was still thinking about the condition checking the readiness "Numer pierscienia = last value in the SP list but I don't know how to write it.

Thank you in advance for your help

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you please help answer below questions?

1. PowerApps does not have a "New" function, so what did you mean by New ("Nrpier_x015b_cienia") in this formula?

2. What is the control "Nrpier_x015b_cienia"? And by “if the "Numer pierscienia" changes”, how will it be changed? Within a form control or what?

3. "Numer formy" is the variable that you want to set with the OnSelect property of this dropdown control, right? If so, then what is "Numer pierscienia" ?

Please explain with some sample data or screenshots. Do mask sensitive data before uploading.

Regards,

Mona
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi v-monli-msft,
1. I understand this is my mistake. I meant if the new value
"Nrpier_x015b_cienia" will display the last value "Numer_x0020_formy". However, if the old value "Nrpier_x015b_cienia" then give the last value "Numer_x0020_formy" +1.
I want these values to be between 1 and 8.
In the above formula there should not be "Numery_x0020_kosza".
The answer to question 3 may more clearly illustrate the problem

2. The "Numer pierscienia" will be entered by the employee of the company.
The parameters of the "Numer pierscienia" are matched, i.e. (The SP list is based on it)
- "Numer formy"
- "Numery_x0020_kosza"
and other

3. That's right. „Numer pierscienia” is also the variable to which "Numer formy" matches.
Eg.
- „Numer pierscienia” = 1000 has the value "Numer formy"=1
- „Numer pierscienia” = 1001 has the value "Numer formy"= 2
....
- „Numer pierscienia” = 1008 has the value "Numer formy"= 8
- „Numer pierscienia” = 1009 has the value "Numer formy"= 1
I would like these "Numer formy" values to be assigned automatically. Screen attached below
I hope my answers are enough.

Best regards
Lukasz