Unanswered

I want update all the filter records inside gallery same value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I want to update all the filter gallery in a single click with the same value(I want to update flag value with "YES" or "NO" value and user mail Id and time )...could you please help on that

Thanks,
Ra

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

To configure this, you can use the below configuration:

Button outside Gallery -> OnSelect -> Set(CheckAll,!CheckAll)

Checkbox inside Gallery-> Default -> CheckAll

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @yashag2255

Thanks that checkbox is working fine.
But I wanted to mark the only filter gallery and I want to update all the records only filter gallery value with same value

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous

Can you please share the logical implementation of the scenario that you are trying to build? This is a bit confusing. We might be able to help you better if we know the exact requirement.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi yashag2255
1) in the above image, there is one filter button I want to filter a gallery based on the sales group.
2) whatever the filter gallery is there if I will press the mark all It will mark all the filter gallery, not all the value,
@yashag2255 wrote:
Hey @Anonymous

Can you please share the logical implementation of the scenario that you are trying to build? This is a bit confusing. We might be able to help you better if we know the exact requirement.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@yashag2255 wrote:
Hey @Anonymous

Can you please share the logical implementation of the scenario that you are trying to build? This is a bit confusing. We might be able to help you better if we know the exact requirement.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

If I press the submit button then it will update all the same value(User mail, the flag should be yes, and Time) inside the DB

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

1) In the attachment image. there is one filter button. I wanted to mark all button it will It will mark all the filter gallery information,
If I press the submit button then it will update the record and value should be same
suppose I press the filter button based on the sales group(Q69) , It will show only 3 lines, If I press mark all the It will update only 3 lines in the backend Database (It will update flag should be yes, edited by -raj@raj.com, edited -time)

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous

I am assuming that the checkbox is working fine even for the group filters, it is only selecting the value currently getting displayed in the gallery.

To perform a bulk update:

Submit Button -> OnSelect -> ForAll(Gallery1.AllItems, Patch('Table Name',Lookup('Table Name','Sender Serial Number' = Label1.Text),{UserColumn:User().Email, Date: Today(), Flag: Checkbox1.Value}))

This is a sample snippet, which you can modify based on your data source and controls.

Here, Table Name is the name of table to perform operation, 'Sender Serial Number' is the column used to identify the record. Label1.Text is the name of control which holds 'Sender Serial Number' inside the gallery. Inside curly brackets { }, you need to pass the columns you want to update.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help.
I'm not able to understand why are using the lookup function...could you please explain me

in my application, I used this code. but its updating one records
ForAll(
Gallery1.AllItems,
Patch(
'[dbo].[PerferctOrder_EDI_PA]',
LookUp(
'[dbo].[PerferctOrder_EDI_PA]',
Exclude_Flag = Exclude_Flag
),
{
Exclude_Flag: Checkbox1.Value,
Created_by: User().Email,
Created_On: Today()
}
)
)

could you please help me

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous wrote:
Thanks for your help.
I'm not able to understand why are using the lookup function...could you please explain me

in my application, I used this code. but its updating one records
ForAll(
Gallery1.AllItems,
Patch(
'[dbo].[PerferctOrder_EDI_PA]',
LookUp(
'[dbo].[PerferctOrder_EDI_PA]',
Exclude_Flag = Exclude_Flag
),
{
Exclude_Flag: Checkbox1.Value,
Created_by: User().Email,
Created_On: Today()
}
)
)

could you please help me

Hi yashag2255

could you please help me above topic

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Lookup is used to identify which record you want to update. Since patch requires the context of the record that needs to be updated, hence we need a lookup function as the second argument.

Can you update your expression as:

ForAll(
Gallery1.AllItems,
Patch(
'[dbo].[PerferctOrder_EDI_PA]',
LookUp(
'[dbo].[PerferctOrder_EDI_PA]',
Exclude_Flag = Exclude_Flag // not a unique key to identiy, you should use some column which is unique for its own row like Name/Title or any other column.
),
{
Exclude_Flag: Checkbox1.Value,
Created_by: User().Email,
Created_On: Today()
}
)
)

Also, which updating the highlighted part, left argument should be column name name and right argument will be the control to get the value, like Label1.Text.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi yashag2255

Shall I use ID Column auto increment ?

Was this reply helpful? Yes No