Updating gallery all items data into sql having an issue in powerapps

[manojrohit16]

Hello there,

I have two galleries on one screen where I have been facing an issue with updating those gallery data into SQL.

Issue:

The First Gallery data update perfectly into SQL but the 2nd gallery data update becomes blank when I try to update again then it's going to update perfectly.

The code is like below:

ForAll(
Gallery4_1.AllItems,
Patch(
,
{ID:Value(lblAPIS_ID.Text)},
{
api_Regulatory_Status:txtinputgallery4_1.Text
}
));

ForAll(
GalleryAPIB_1.AllItems,
Patch(
Datatable,
{ID:Value(lblgalleryapi.Text)},
{
column :txtinputgalleryapib_1.Text
}
)
);

Please let me now the issue as well as the solution.

Regards,

Manoj Roy

[manojrohit16]

I want to achieve result like below:

ID    Gallery1.col    Gallery2.col

1     Gallery1           Gallery2

2     Gallery1           Gallery2

[cha_cha]

Hello @manojrohit16 

Please check this video that I made, a similar case as yours. Please follow so you can copy your data from the gallery to SQL.

The video:

https://youtu.be/LNz5FwBmWD0

[manojrohit16 · Accepted solution]

Thank you for your kind response and help to solve this issue.

I solved it yesterday by creating a collection and pulling the data from that collection to update it in SQL.

Regards,

Manoj Roy

[cha_cha]

Glad you got it sorted. Please mark your response as the answer to close this topic and also for people to know what you did to got it sorted.