Update end submit fields to a Microsoft list with a PowerApp button

(0) Share

Report

Posted on by Calcioscacchi

413

Hi guys,

First try to build an app, sorry for my ignorance with these issues.

I make a Microsoft list with:

Linea: text Field

Evento: text field

Inizio: Date/Time field

Fine: Date/Time field

Durata: calculated column.

Now, i have to update the rows of my list with just a button.

For example, we have button1 wich have to:

-set Linea field to "T6" value

-set Inizio field to now

-set the Fine field field of the previous row to now

-set Evento field to "Blocco"

and then publish these info on my list.

I try both the set and update context apporach (I prefer "set()" because i lice to use global variables) but the corrector says that i'm using unexpected characters:

For example:

Set(Linea: "T6");

seems that ";" is unexpected".

Am I doing this on the right way?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (27)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Calcioscacchi

The set function would be used as such:

Set(Linea, "T6");

But keep in mind, this is only setting a variable. This has nothing to do with what you are trying to accomplish with your data in the list.

I hope this is helpful for you.

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Set is used to update the value of variables. Patch() is used to update the value of a record in a data source like SharePoint. Here's an article on how to use Patch().

Patch function in Power Apps (contains video) - Power Platform | Microsoft Docs

For the ';' the problem may be your region. Different areas and languages around the world use different separators. ';' is what is used in the US. Take a look at the table here that explains the differences for different regions. Build global support into canvas apps - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, i'll start to study patch function.

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Pstork1 , it works!
Last question, i need to edit a field of the previous row. Is that possible?

Thanks.

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

There are two forms of the Patch() function. One uses defaults(datasourcename) as the second parameter. The other uses something to identify the specific row being edited. This could be the selected value of a Gallery if the gallery shows the records or it could be a Lookup() that uses a specific value of one of the fields to find the matching record. That's covered in the article also.

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!
According to what you say, i'm trying to identify the ID of the row that I want to edit (see this as start point:
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-change-value-of-previous-record-s-field-while-submitting/td-p/494985)

Now, i'm trying, without setting a gallery, to identify my row:

Patch('Segnalazione eventi macchina';Defaults('Segnalazione eventi macchina');{Linea: "T6";Evento: "Blocco";Inizio: Now()});; Patch('Segnalazione eventi macchina';LookUp('Segnalazione eventi macchina';ID=ThisRecord.ID-1);{Fine: Now()});; Notify("Inserimento OK")

Question: the first patch function create a row itself? Because if the answer is yes, this code should work. Instead, the "ID=Thisrecord.ID-1" is not correct.

I think that I need to set a gallery, but do you know how to fix this "easily"? Maybe is just my code wrote in a wrong way 😛

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The first line is correct for creating a new record. It is not required when updating an existing record. Your second line is correct also, but thisrecord.ID-1 won't give you the right value. You have to know what the ID is or use a different field, like Title, to find the record you want. In the post you reference they are using a gallery. In your case there is no thisrecord to get the ID from.

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 wrote:
Your second line is correct also, but thisrecord.ID-1 won't give you the right value. You have to know what the ID is or use a different field, like Title, to find the record you want.
Do you mean that without a gallery the ID column is useless? Isn't it a number format column that I can use as a table index?
Or you are trying to say that "Thisrecord" is not the right function in my case?

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I'm saying there is no thisrecord without a form or gallery. You could put a textinput control on the page and use that to get the ID if you knew what it was and your code would work. Knowing the exact ID isn't common so usually you work with something else that is known.

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks.

Why are you saying that knowing the ID in not common? As you can see here, I have the ID column, just showing it from the "Show/Hide columns".

Was this reply helpful? Yes No