Bulk update a set of records

(0) Share

Report

Posted on by WebPortal

2,297

Hello,

I'm trying to bulk update a set of records in datasource "Investments" - a SharePoint list with the value the user enters into TextInput2:

Patch(Investments, LookUp(Investments, Cod_Projeto_Key = CodigoProjeto), {Cod_Projeto_Key: TextInput2.Text});

But this is only updating the First record of the list.

Why? The Lookup returns a set of records or only the first it finds?

I'm trying to understand the article How to bulk update records in PowerApps

But since I'm not using collections here, it gets a bit too confusing...

Categories:

Building Power Apps

All responses (14)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@WebPortal

LookUp returns a record...not a table.

What you are looking for is this:

UpdateIf(Investments, Cod_Projeto_Key = CodigoProjeto, {Cod_Projeto_Key: TextInput2.Text})

I hope this is helpful for you.
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Thanks, but Filter does return a table, right?
So, this one should work:
Patch(Investments, Filter(Investments,Cod_Projeto_Key = CodigoProjeto), {Cod_Projeto_Key: TextInput2.Text});
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@WebPortal

Yes, filter returns a Table, but then your Patch will not work because you are trying to patch a table to the datasource, which is fine, but then trying to also patch a record into that, which will mismatch.

You could do this:

Patch(Investments, ForAll( Filter(Investments, Cod_Projeto_Key = CodigoProjeto), Patch(ThisRecord, {Cod_Projeto_Key: TextInput2.Text}) ) )

But why?? When you can just do this:

UpdateIf(Investments, Cod_Projeto_Key = CodigoProjeto, {Cod_Projeto_Key: TextInput2.Text})
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes thanks, that makes more sense.
But, after trying that expression, I get empty cells for column Cod_Projeto_Key where the values should be changed to TextInput2.Text
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@WebPortal

Which formula are you referring to that gives you empty cells - the long one with patch or the UpdateIf?

What kind of column is Cod_Projeto_Key in your list?
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, the UpdateIf
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@WebPortal

What kind of column is Cod_Projeto_Key in your list?
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

It is a single line of text.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@WebPortal

How many records are in your list?
WebPortal 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

300.
I want to update 5 for a test I'm making.