Message for no data found

(0) Share

Report

Posted on by bsoleti

Hello,

Need some direction on my task in power apps.

I have a form with few text input fields and a button . User inputs a value in a text input 1 field and presses the button which populates next of the text fields . The button is pulling the information from sharepoint library. This aspect is working fine.

What i want is to trigger a message or pop up saying 'no data found' when search button returns no data for the requested text input . How can i handle this ?

The code OnSelect button is as follows - ContractID is the text input 1 field entered to search for product type and customer name.

UpdateContext({AppIDVar:First(Filter(collect1,ContractID=TextInput1_ContractID.Text)).ApplicationID});

UpdateContext({ProductTypeVar:First(Filter(collect1, ContractID=TextInput1_ContractID.Text)).ProductType});

UpdateContext({CustomerNameVar:First(Filter(collect1, ContractID=TextInput1_ContractID.Text)).CustomerName});

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Pstork1 69,554 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I normally do this by creating a Label that has the text of the message I want to display in it and then set the visibility of that label based on the RowCount of the data in the gallery. If the RowCount is greater than 0 then hide the label, otherwise show it.

Was this reply helpful? Yes No
bsoleti 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You for the feedback. I tried adding to Onvisible property of the label this way.

If (CountRows(collect1) > 0,false)

Its not working as expected . There is always some data in the collection . I am missing something like adding Clear(collect1) ?

Please suggest any other alternatives.

Thanks

Was this reply helpful? Yes No
Pstork1 69,554 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You should Clear the collection before each search. So I would put the Clear() as the first statement in your Search button or when you refresh the filter. You should also make sure you set the visible to true if the value isn't >0 otherwise it will never reset.

Was this reply helpful? Yes No
Verified answer

bsoleti 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks very much . Your solution works.

Was this reply helpful? Yes No
ST1 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 Hi, please could you expand on what the whole formula should look like? Including the if<0, false and if not <0, true. Thanks!

Was this reply helpful? Yes No
Verified answer

Pstork1 69,554 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
The following formula goes in the visible property of the label.

If (CountRows(collect1) > 0,false,true)

Was this reply helpful? Yes No
bsoleti 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks very much . Your solution works

Regards

Was this reply helpful? Yes No