Answered

Populate Gallery Label and Image Control

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Gallery1.

Gallery1 is returning content from SPLibrary based on the 'Invoice Number'
in a Dropdown outside of Gallery1.

I am not able to get the 'Name' and the 'Thumbnail' content to populate.

Galley1 formula -

Filter(Activity_Documents_Collection,

'Name' in Activity_Invoice_Number_Dropdown.Selected.Value)

Gallery1, Document Name Field formula -

ThisItem.'File name with extension'

Gallery1, Image control formula -

ThisItem.Thumbnail.Large

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

Assuming Activity_Documents_Collection is your Library and your filter is returning records, the Image could be

ThisItem.'{Thumbnail}'.Large

However there are two additional possible issues here - not all file types will resolve a thumbnail and also neither Name nor the in filter are Delegable, so it is possible in a large Library that you will not find the desired record.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, I understand the delegation issue. I'll switch to the collection once I figure this out.

I placed the following in the 'items' of the image control. Still no image. The document is a picture (.jpg).
ThisItem.'{Thumbnail}'.Large

Also, there is a '4' in the document name field.

Doesn't that indicate data is being returned, just not the correct data?

Attachment Submit Button Formula -
UploadActivityDocumentFlow.Run(Label5_9.Text, Label5_2.Text &" - "& Label5_5.Text,
{
file:
{
contentBytes: First(Activity_Attachments_Control_DataCardValue.Attachments).Value,
name: Activity_Invoice_Number_Dropdown.Selected.Value &" - "& Label5_2.Text &" - "& Activity_Document_Type_Dropdown.Selected.Value &" - "& Label5_5.Text &"."&
Last(
Split(
First(Activity_Attachments_Control_DataCardValue.Attachments).Name,
"."
)
).Value
}

});

My formula is creating three levels of folders, with the First, Last, Split.

I only want one Folder (named by the formula), with the file inside.

How do I update my submit formula to correct how the folder/file are being created?

SP Library -

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

To answer the question you posted regarding displaying the file name and thumbnail, you appear to be filtering a collection Activity_Documents_Collection, rather than the 'Shared Documents' Library, so have you looked in the collection to see if the file is present. I can assure you that if it is then

ThisItem.'{Thumbnail}'.Large

will display the image and

ThisItem.'File name with extension'

will display the file name.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I know your rules.

In this case the extra context is important, as I believe the multiple layers of folder may be having an impact and wanted to get your thoughts.

Yes, the document name and thumbnail appear in tables in the collection and not just as data.

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

It is more the forum protocol when users are looking for your subject Populate Gallery Label and Image Control, however most responders greatly prefer (and it is a good courtesy) to see the entire issue in the initial post, so they know what they are dealing with.

If you simply collect directly from the Library, folders are not relevant to the field 'File name with extension' and any search is directly on this or on the Name field, which is the same without the extension. An additional field FullPath contains the full folder patch and can be searched separately if necessary. Does your Collection fields follow what I have mentioned above ?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Not sure if this helps; here is the collection.

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

What is your collection code ?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

The OnStart is -
- ClearCollect(Activity_Documents_Collection,Documents_1)

The Gallery is -
- Filter(Activity_Documents_Collection,
Name in Activity_Invoice_Number_Dropdown.Selected.Value)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

The problem with that is you are also picking up the folders - if you do this (which is unfortunately not Delegable)

ClearCollect( Activity_Documents_Collection, Filter( Documents_1, !IsFolder ) )

you will remove these, however a better plan is not have your search string in the folder name path as it appears you are picking up a folder record (4) which naturally is not a file and does not have a thumbnail.

An even better plan is to have a text field in your Library with the file name and search on that.

Was this reply helpful? Yes No