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

[cha_cha]

Hello @manojrohit16 

Is this right?

[manojrohit16]

Yes it is.

[cha_cha]

If the first one work, how about removing datatable in 2nd one?

[manojrohit16]

ForAll(
Gallery4_1.AllItems,
Patch(

SqlDB,
{ID:Value(lblAPIS_ID.Text)},
{
api_Regulatory_Status:txtinputgallery4_1.Text
}
));

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

[cha_cha]

Hello @manojrohit16 

Your code should be something like this:

ForAll(
	Gallery4_1.AllItems,
		Patch(
			SqlDB,
			LookUp(SqlDB, ID=Value(lblAPIS.Text)),
			{
				api_Regulatory_Status:txtinputgallery4_1.Text
			}
	)
);

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

[manojrohit16]

Yes, you are right.

[cha_cha]

It worked? 

---

✔️	Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION.  This helps community members if they experience a similar issue in the future.

🔗	🕸bistek.space  🐦 @cha_bistek  📺 @BisTekSpace

[manojrohit16]

No, facing the same issue.

[cha_cha]

Can you please screenshot and annotate the thing that you want to achieve?