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)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @manojrohit16

Is this right?

Was this reply helpful? Yes No
manojrohit16 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it is.

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

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
manojrohit16 on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Yes, you are right.

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

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

No, facing the same issue.

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

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
manojrohit16 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to achieve result like below:

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

Was this reply helpful? Yes No