how to patch with one button for the item select in gallery and also who error message in search box??? help please. thanks

[bbsin]

Hi

I have a gallery of item that need to be update, I don't want the update button in each item.  How to have one outside the gallery and only patch the select item when user search and appeared in Gallery?  the item can show one or many.

 

2)  I have a text box message for error if they search the wrong number that does not exist in the SP list.  How to make it appear and disappear when they key in the wrong number?

Do I use visible on error text box as below? as it doesn't wrong

visible = If(Or(IsBlank(Searchbox),IsBlank(LookUp('list', StartsWith(updatenumber,Searchox.Text))), true, false)

kindly advise. thanks 

[RusselThomas]

Hi @bbsin ,

There are a couple of features of Galleries that are quite cool - one of which is that they behave like collections - meaning you can filter them and access their records just like a collection.  Not only that, but you can also access their child control properties as fields.

1) If you place the update button outside the gallery, you can set it to patch all updated items using the ForAll() function.

Button OnSelect:

ForAll(
     Filter(Gallery.AllItems, !IsBlank(TextInput1.Text)), 
     Patch(Source, ThisRecord, {PONumberColumn: ThisRecord.TextInput.Text})
)

2) If your gallery is the result of PO numbers searched and found, then it might be faster and easier to just pop up the error message if the gallery is empty instead of doing another lookup to the same source.

Error Label Visible: 

IsEmpty(Gallery1.AllItems)

Hope this helps,

RT

[bbsin]

Hi @RusselThomas 

The one button to patch all is working . Thanks

But the error text box not working - I cannot get it to pop when search box didn't match with PO number 

eg SP list only have 1223, 1234 but use input 1221.. how to show please entre correct number as there is no such number?  How to ensure the search box matched the list number? Thanks

Also one item - how to disable edit box for item that has been update and moved to the bottom , new records should be at the top instead.  thanks

my sample its not showing the error messag when I put wrong description

---

Visble - If(IsBlank(SearchBox),IsBlank(LookUp('list', StartsWith(Description,SearchDesInput.Text))), true, false)

What did I do wrong?   Thanks

Do advise thanks.

[Ashwin7104]

Hi @bbsin ,

Trying using search function since it would match the search string in the specified column and also its case-insensitive compared to Lookup.

Visible - If(!IsBlank(SearchBox), If(CountRows(Search('list', SearchDesInput.Text,"Description")) >0, true, false))

Thank you.

[bbsin]

Hi @Ashwin7104 

There's error, what is wrong ?  Do advise Thanks.

[Ashwin7104]

Hi @bbsin ,

Apologies, Kindly refer to my edited code above. Also note that search is not Delegable. In case, if you want to search more than 100 records use combination of filter and StartsWith.

https://powerusers.microsoft.com/t5/Building-Power-Apps/delegation-warning-the-search-part-of-this-f...

[RusselThomas]

Hi @bbsin ,

What is the Items: property of your Gallery set to please?

Kind regards,

RT

[bbsin]

HI RusselThomas, 

Sure, I created a variable as InvQuery -is search description 

item - Filter('list (Invoices)',StartsWith(Description,InvQuery))

Is it possible to search description and POnumber either one if the user input into the search box? 

Thanks

[RusselThomas · Accepted solution]

Hi @bbsin ,

One question at a time - otherwise we'll get way too confused 😊

First - let's deal with your error message when the result is empty. 

There are usually many different ways to achieve the same result in Power Apps, so this is sometimes a question of preference.  Personally, I would prefer to do as few queries back to the source as possible - so in this respect we can use your Gallery to see if the result was successful or not - instead of repeating the query with the label and testing the result again.

Set your error label Visible: property to 

!IsBlank(InvQuery) && IsEmpty(Gallery.AllItems)

This will rely on the Gallery items: call and save you running another call back to the source - but it might also show the message while the query is still being run, which might not be ideal. 

In that case, you might be forced to duplicate your Items: query on your label Visible: property, but test whether it's empty - so your label Visible: property might then just be;

IsEmpty(Filter('HRFA Procurement List_2021 (Invoices)',StartsWith(Description,InvQuery)))

Lastly, yes you can use the Search() function as @Ashwin7104 mentioned to check multiple columns for a value, however as he also pointed out, this function is not delegable.  This means, you can't rely on it for accuracy if your source contains more than 500 records (or whatever you set your return record limit to if you changed the default).

For this you would be better off using an OR operator on your filter;

Filter( 'HRFA Procurement List_2021 (Invoices)', 
  StartsWith(Description,InvQuery) || 
  StartsWith(PO,InvQuery) 
)

Hope this helps,

RT 

[bbsin]

@RusselThomas

You are a great help. it works.. Appreciated

Two questions

1) after I click off the search box text , the gallery still show the last record how to make it empty?

and 

2) how to show the latest record and push the old record down?  Thanks.  

As of now, the list of gallery appeared all with completed one too.

Regards