Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

SharePoint List preview shows no data

(0) ShareShare
ReportReport
Posted on by 15

Hi guys,

 

I have a SharePoint list connected to my Power App, which is not getting any data using it on an OnSelect of an icon

 

2021-12-01 17_57_02-Power Apps und 8 weitere Seiten - Geschäftlich – Microsoft​ Edge.jpg

 

 while it is showing me data in a galary

 

2021-12-01 17_49_59-Power Apps und 8 weitere Seiten - Geschäftlich – Microsoft​ Edge.jpg

 

Has someone experienced such behaviour befor and do you know how to fix this?  

Categories:
  • CU26100700-0 Profile Picture
    15 on at
    Re: SharePoint List preview shows no data

    I guess there is some confusion on what I am trying to achiev. I will try to explain it.

    I have a list with many items, each wit exactly one attached file. But there might be more then one of the same category. So my gallary should show all possible categories first. I already achived this by 

    Distinct(Trainings, Category)

    Now my galary looks like this:

    2021-12-02 09_41_21-Power Apps und 9 weitere Seiten - Geschäftlich – Microsoft​ Edge.jpg

    Now by selecting the download icon, I want to download the attached file of the first list item of the selected category. I tried with this:

    Download(First(First(Filter(Trainings, Category=ThisItem.Result)).Attachments).Value)

    as well as with this:

    Launch(First(First(Filter(Trainings, Category=ThisItem.Result)).Attachments).Value)

    The Download function gives me a Runtime error saying: The URL passed to the function is not valid.

    Launch instead opens a new tab with the about:blank page.

     

    I traced the issue to be that my Trainings list delivers no data in my IconDownload.OnSelect

    What I don't understand is why, since my galary works fine.

    But maybe I am having some other error. I am grateful for any help.

  • Pstork1 Profile Picture
    65,906 Most Valuable Professional on at
    Re: SharePoint List preview shows no data

    You can't launch the list item for download outside of the context of the app or the SharePoint list.  If you want to download some of the data the easiest way would be to create a display form on a print page and set the item property to do a lookup based on the Gallery.Selected.Category.someuniquevalue.  Then you could print the form or screenshot it.

  • CU26100700-0 Profile Picture
    15 on at
    Re: SharePoint List preview shows no data

    Hi @Pstork1

     

    thanks for your reply.

     

    Actually I am trying to make a download of the first SharePoint list item having the same "Category" as the gallary item.

    So this was somehow what I had, opening an empty tab.

     

     

    Launch(First(First(Filter(Trainings, Category=ThisItem.Result)).Attachments).Value)

     

     

     

  • Pstork1 Profile Picture
    65,906 Most Valuable Professional on at
    Re: SharePoint List preview shows no data

    Can you explain what you are trying to do in the OnSelect?  Are you trying to apply a filter to data showing in gallery or table?  If you are then the filter() statement needs to be in the items property of the gallery.  In the OnSelect you would normally set a variable value to be used in the filter function elsewhere.

    Set(varCategory, thisitem.category.result) <--code for onselect
    filter(Trainings, Category=varCategory) <-- items property of Gallery
    

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard