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

Gallery not showing data

Hello,

 

i have an excel and the column is filled using formula to take the value like this 

Capture55.PNG

however, when i want to show it in powerapps. it show nothing 

Capture555.PNG

is it because i was using formula in my excel ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Gallery not showing data

Hi @AdhamFH ,

Please try to add an if statement to justify whether there's data in textinput.

Try to set the gallery's Items:

SortByColumns(
              If(IsBlank(TextSearchBox.Text),
                 Table1,
                 Search(Table1,TextSearchBox.Text,"Voucher")
                 ),"Voucher"
              )

If there's no data in the search box, the gallery will display all the items of the table.

 

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

13 REPLIES 13
DocWHCI
Level: Powered On

Re: Gallery not showing data

What fields to you have in your gallery item?

ThisItem.Nama?

Have you tried ThisItem.Nama.Value?
AdhamFH
Level: Powered On

Re: Gallery not showing data

Thank you @DocWHCI for your response,

i tried it and shows error " invalid use of '.' "

gabibalaban
Level 8

Re: Gallery not showing data

Have you put a label in gallery ?

Dual Super User
Dual Super User

Re: Gallery not showing data

Hey @AdhamFH 

 

Can you check the controls inside the Gallery control if they point to the correct value?

If you want to show "Nama" column, then the expression on the Text property of the label inside gallery should be:
ThisItem.Nama (I just tested on my end and it works as expected)

 

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!

AdhamFH
Level: Powered On

Re: Gallery not showing data

@yashag2255 i have checked it and point to correct value. in your test, is your column using formula to get value ? or manually type? because i have tried using column which i type it manually and it success to show in gallery but it shows nothing when i use column which use formula to get the value

Dual Super User
Dual Super User

Re: Gallery not showing data

Hey @AdhamFH 

 

Yes, I have used the column which had a formula similar to your expression as:
=IF([@ID] <> "***","sdf","")

and I was able to see the below results as:

ddd.png

 

Can you share more details about the "Grab!B8", which I am guessing is a column Name.

 

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!

AdhamFH
Level: Powered On

Re: Gallery not showing data

@yashag2255 Grab is reffered to my name sheet and b8 is to cell in sheet grab

Capture5555.PNG

is my formula in excel is incorrect? 

Dual Super User
Dual Super User

Re: Gallery not showing data

Hey @AdhamFH 

 

No I don't think there is any issue with referring to a different sheet. I carried out a test on my side and it was populating data from a different sheet.

Can you share more details about the configuration of the excel sheet and the application? What is in the Items property of the gallery control? Where is this excel file stored?

 

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!

 

 

AdhamFH
Level: Powered On

Re: Gallery not showing data

@yashag2255

 Capture55555.PNG

i was using "Nama" just for example. actually every columns are show nothing in gallery, but i can show it from table 2 which i type it manually not using formula like table 1.

i stored my excel in my onedrive

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,018)