cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
viki_makki
New Member

Patch don't work on filtered date by dropdown

Hi,

 

I create new screen on gallery, and make five drop down to filtered lot of data, and result show in label, but patch by checkbox to update filtered date on label not work.

 

Here is screen on app

Please help 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Patch don't work on filtered date by dropdown

Hi @viki_makki ,

I think you should not set the patch function on the check box's OnSelect.

"OnCheck" property could represent the action of "check" the red checkbox.

"OnUncheck"property could represent the action of "uncheck" the red checkbox.

I suggest you set the red checkbox's OnCheck:

Patch(...,.....,{new_status:"Red"})

set the green checkbox's OnCheck:

Patch(...,.....,{new_status:"Green"})

 Then if you choose red check box, the new_status field will updated with "Red".If you choose green check box, the new_status will be updated with "Green".

 

If the problem still exists, please tell me the data type of new_status field.

And can you sure you could get the right record by using "First(Filter(...,Metric=Dropdown1_4.SelectedText.Value))"?

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
eka24 Community Champion
Community Champion

Re: Patch don't work on filtered date by dropdown

Some clarification. Is the checkbox inside the Gallery? If the Gallery is already filtered by the dropdowns then you can take it out of the formula. Kindly check this if it can help

https://powerusers.microsoft.com/t5/Building-Power-Apps/Patch-and-Checkboxes/m-p/474128
viki_makki
New Member

Re: Patch don't work on filtered date by dropdown

Yes, the checkbox is inside in gallery, but this link not help me. Please help

eka24 Community Champion
Community Champion

Re: Patch don't work on filtered date by dropdown

Try this on the OnUncheck Property of the Checkbox:

Patch('[dbo].[avlist] ',ThisItem, {new_Status:"Red"})

 

That is anytime someone checks the red Checkbox, then this the patch will trigger

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

Community Support
Community Support

Re: Patch don't work on filtered date by dropdown

Hi @viki_makki ,

I think you should not set the patch function on the check box's OnSelect.

"OnCheck" property could represent the action of "check" the red checkbox.

"OnUncheck"property could represent the action of "uncheck" the red checkbox.

I suggest you set the red checkbox's OnCheck:

Patch(...,.....,{new_status:"Red"})

set the green checkbox's OnCheck:

Patch(...,.....,{new_status:"Green"})

 Then if you choose red check box, the new_status field will updated with "Red".If you choose green check box, the new_status will be updated with "Green".

 

If the problem still exists, please tell me the data type of new_status field.

And can you sure you could get the right record by using "First(Filter(...,Metric=Dropdown1_4.SelectedText.Value))"?

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,588)