Power Platform Community Forum Thread Details

Hello Community,
I create applications in PowerApps which is based on the SP list, I would like my application to download data from the SP list and automatically enter them into individual cells
That is why I have two questions:
1. Is it possible to create a condition, e.g. in the "Nr pierscienia" field that says:
If you fill in fields 1 to 6 and click "save / update", the last "Nr pierscienia" from the list SP + 1 will be entered in the "Nr pierscienia" field
or
If you do not fill in fields 1 to 6 and click "save / update", the last "Nr pierscienia" from the list SP will be entered in the "Nr pierscienia" field.

Now my formula doesn't include the "save / update" button and it sounds like this:

If (IsMatch (DataCardValue9.Text, MultipleDigits)
And IsMatch (DataCardValue14.Text, MultipleDigits)
And IsMatch (DataCardValue20.Text, MultipleDigits)
And IsMatch (DataCardValue16.Text, MultipleDigits)
And IsMatch (DataCardValue17.Text, MultipleDigits)
And IsMatch (DataCardValue19.Text, MultipleDigits),
First (SortByColumns (Tubes_1, "Nrpier_x015b_cienia", Descending). 'Ring number'). 'Ring number' + "1",
First (SortByColumns (Tubes_1, "Nrpier_x015b_cienia", Descending). 'Ring number'). 'Ring number')

Below screen nr1 from the view.

2. I want the last values of records from SP to be entered in the places marked in red. However
only the highest record values are shown.
Below is my formula:

"C" & Last (SortByColumns (Tubes_1, "NrC", Ascending) .NrC) .NrC

On screen 2, it shows the places where I would like the last values from the SP list to appear
Screen No. 3 shows the SP list with values

Could someone help me solve these problems?

Thanks in advance for your reply

Best regards
Łukasz

Categories:

Building Power Apps

Hi @Anonymous ,

To your first problem, do you want to add the "save / update" button condition into your code?

You can add Set(Var_ButtonClicked, True) to OnSelect property of button, and add Set(Var_ButtonClicked, False) OnVisble property of scrren to reset the variable. Then add the condition into code.

And Var_ButtonClicked,
First (SortByColumns (Tubes_1, "Nrpier_x015b_cienia", Descending). 'Ring number'). 'Ring number' + "1",
First (SortByColumns (Tubes_1, "Nrpier_x015b_cienia", Descending). 'Ring number'). 'Ring number')

To second problem:

If you want to lookup the last values , try to sort the ID column by ascend and get the last record.

"C" & Last (SortByColumns (Tubes_1, "ID", Ascending) .NrC) .NrC

Best regards,

Sik