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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report

Hello @manojrohit16

Is this right?

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

Yes it is.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

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
}
)
);

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (1)

Report
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 } ) );

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

Yes, you are right.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

No, facing the same issue.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

I want to achieve result like below:

ID Gallery1.col Gallery2.col
1 Gallery1 Gallery2
2 Gallery1 Gallery2

Was this reply helpful? Yes No