cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
stavrinio85
Level: Powered On

Error received when trying to patch datatable from checkbox

Trying to update datatable value when checkbox is checked on Gallery.

Patch(Table7_1,Search(Table7_1,ThisItem.Branch,Branch),{Column9:"1"})

I need to match the id of the datatable and the gallery checkbox to update datatable's column9 from 0 to 1.

I am getting an error:

The function search has invalid arguments

I also tried this function but still getting error when trying to update the datatable.

If(!IsBlank(LookUp(Table7_1,Branch = ThisItem.Branch)),Patch(Table7_1,LookUp(Table7_1,Branch = ThisItem.Branch,Column9),{Column9:1}),"")

 

and this 

 

ForAll(CheckedItems,Patch(ChecklistItemsSource,LookUp(ChecklistItemsSource, Id = CheckedItems[@Id]),{Status:"Done"}))

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
stavrinio85
Level: Powered On

Re: Error received when trying to patch datatable from checkbox

Sorry for the posting i think i resolved it by doing the below:

Patch(Table7_1,First(Search(Table7_1,Text(ThisItem.Branch),"Branch")),{Column9: 1})

 

If anyone is interested.

View solution in original post

1 REPLY 1
stavrinio85
Level: Powered On

Re: Error received when trying to patch datatable from checkbox

Sorry for the posting i think i resolved it by doing the below:

Patch(Table7_1,First(Search(Table7_1,Text(ThisItem.Branch),"Branch")),{Column9: 1})

 

If anyone is interested.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 121 members 2,008 guests
Please welcome our newest community members: