how to patch gallery items based on certain ID

(0) Share

Report

Posted on by Mythran

Hello folks,

I am struggling to patch gallery items which is filtered on certain ID.

Use Case: there are one form (above in pic) and one gallery whose DBs are different. i just want to update the changes in both area. i can make it for form but cannot patch updates for certain ID for Gallery.

The Code;

Filter(colDeneme2,refID=Value(DataCardValue27.Text));

ForAll(
 colDeneme2,
 Patch(
 DenemeFormDetay,
 {
 Proses: ddproses2.Selected,
 'İş Akışı': txtIsakıs2.Text,
 Sorumlu: ddSorumlu2.Selected,
 Termin: ddTermin2.SelectedDate
 }
 )
);
Patch(
 DenemeFormAna,
 {ID: Value(DataCardValue27.Text)},
 Form3.Updates
);
UpdateItem.Run(DataCardValue27.Text);

In DB side, the item which i want to patch, is being recorded in separate row multiple times (Only the last row) not not getting "refID" value.

how can make this happen?

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
While updating item you need to pass record in Patch function.
Assuming there is 1:1 ratio. You can try using below formula -
Patch(
DenemeFormDetay,
LookUp(colDeneme2,refID=Value(DataCardValue27.Text)),
{
Proses: ddproses2.Selected,
'İş Akışı': txtIsakıs2.Text,
Sorumlu: ddSorumlu2.Selected,
Termin: ddTermin2.SelectedDate
}
)

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!

Hello @NandiniBhagya20

there are more than one record with same refID. İn that case would that same formula work ?

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In that case you can try using below formula:
ClearCollect(colDataToLoop,Filter(colDeneme2,refID=Value(DataCardValue27.Text)));
ForAll(colDataToLoop,
Patch(
DenemeFormDetay,
LookUp(colDeneme2,refID=ID),
{
Proses: ddproses2.Selected,
'İş Akışı': txtIsakıs2.Text,
Sorumlu: ddSorumlu2.Selected,
Termin: ddTermin2.SelectedDate
}
)
)

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!

@NandiniBhagya20

With that formula i can only change first item of gallery. however second item remained same.

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!

Hello Folks,
is there any other solution?

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!
Hello Folks,

the latest situation i can only patch latest item. with the code i share below. why could that happen i didn't figure out. could you please help me?

Gallery onSelect:
ClearCollect(colDeneme2,ThisItem,{Proses:ddproses2.Selected, 'İş Akışı':txtIsakıs2.Text, Sorumlu:ddSorumlu2.Selected,Termin:ddTermin2.SelectedDate })

Save onSelect

Collect(colDatatoLoop,Filter(colDeneme2,refID=Value(DataCardValue27.Text))); ForAll( colDatatoLoop, Patch( DenemeFormDetay, LookUp(colDeneme2,ID=Value(lblID.Text)), { Proses: ddproses2.Selected, 'İş Akışı': txtIsakıs2.Text, Sorumlu: ddSorumlu2.Selected, Termin: ddTermin2.SelectedDate } ) ); Clear(colDatatoLoop); Patch( DenemeFormAna, {ID: Value(DataCardValue27.Text)}, Form3.Updates ); UpdateItem.Run(DataCardValue27.Text);

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
With Gallery onselect formula,
Instead of using ClearCollect use Collect and Clear the collection on screen visible.
OnScreen Visible property:
Gallery onselect: Clear(colDeneme2)
Collect(colDeneme2,ThisItem,{Proses:ddproses2.Selected, 'İş Akışı':txtIsakıs2.Text, Sorumlu:ddSorumlu2.Selected,Termin:ddTermin2.SelectedDate })
You should collect either ThisItem or this object : {Proses:ddproses2.Selected, 'İş Akışı':txtIsakıs2.Text, Sorumlu:ddSorumlu2.Selected,Termin:ddTermin2.SelectedDate }
Collecting both will create 2 entries
If you want to update you collection with the object properties than you can use below function:
Collect(colDeneme2,ThisItem); UpdateIf(colDeneme2, <condition>, {<columns to update with value for ex Title: "test">})

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!

@NandiniBhagya20

Hello, it doesn't change anything. the problem is in "ForAll" formula. because i can patch it but only last record. it's really frustrating

Was this reply helpful? Yes No
MuFeR 31 on at

Like (0)

Report
Copy link

Link copied!

I think this suggestion can still work just by replacing the LookUp part with ThisRecord since you already got all the records you need to patch. By doing a LookUp you're always getting the first record in your loop and patch the same thing.

ClearCollect(colDataToLoop,Filter(colDeneme2,refID=Value(DataCardValue27.Text)));
ForAll(colDataToLoop,
Patch(
DenemeFormDetay,
ThisRecord,
{
Proses: ddproses2.Selected,
'İş Akışı': txtIsakıs2.Text,
Sorumlu: ddSorumlu2.Selected,
Termin: ddTermin2.SelectedDate
}
)
)

Was this reply helpful? Yes No
Mythran 57 on at

Like (0)

Report
Copy link

Link copied!

hello @MuFeR

i changed with "ThisRecord" however this time all items became identical and take the values of last item.

Was this reply helpful? Yes No