Power Platform Community Forum Thread Details

How can I access the "Item Child Count" column from a Sharepoint list from within PowerApps.

I am writing an app that provides a link in a gallery to another directory that is related to the gallery record. The problem is there is nothing in the gallery that indicates whether the user has uploaded files to that directory, so rather than provide a link to an empty directory, I'd prefer to just display a message of "No Attachments" otherwise, if there is data, provide a link.

I can't think of a way to do this without examining the Item Child Count for the directory, something like

If (gallery.'Item Child Count' < 1, "No Attachments", Link) except I can't access Item Child Count when creating the collection that is the datasource for the gallery.

Using a sharepoint connector to access the directory.

I've seen some examples out there using power automate but I really don't want to go there if possible. Also, could a component be used to do something like this? Some kind of stand-alone component that could accept a URL to a sharepoint directory and return Item Child Count (or other such columns)?

Any and all help and suggestions are appreciated... so brainstorming is encouraged!!

Thanks

Categories:

Connecting to Data

General Questions