Hi there!
I have managed to follow Shaun Young's great tutorial to create a gallery that stores and displays photos using Azure blob storage.
However, I don't want to show every photo in the collection - just the photos relating to the particular job number reference.
This is the OnSelect for the button to save the photos (using the AddPicture control):
AzureBlobStorage.CreateFile("powerappsphotos",Concatenate(DataCardValue2.Text,TextInput4_1.Text),AddMediaButton1_1)
This enables the photo filename to begin with the relevant job number (ie. DataCardValue2.Text). All good so far.
I have created another screen with the photo gallery itself, and it displays photos from the blob storage correctly
Screen 2: OnVisible: ClearCollect(CollectFiles,AzureBlobStorage.ListFolderV2("JTJmcG93ZXJhcHBzcGhvdG9z").value
But it displays all the photos in that blob storage container.
How can I make the gallery display only photos with filename that begins with the DataCardValue2.Text?
Perhaps I am going about this the wrong way - and I should be creating a new collection instance each time, that refers to the DataCardValue2.Text?
Either way, this is beyond my capabilities, so hoping you can help or send me in the right direction.
Many thanks in advance.
Solved! Go to Solution.
Hi @KQ ,
Do you want to filter the Blob metadata collection based on DataCardValue2.Text?
I've searched the structure of BlobMetadata:
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
The unique id of the file or folder. |
Name
|
Name | string |
The name of the file or folder. |
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
Path
|
Path | string |
The path of the file or folder. |
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
Size
|
Size | integer |
The size of the file or folder. |
MediaType
|
MediaType | string |
The media type of the file or folder. |
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
ETag
|
ETag | string |
The etag of the file or folder. |
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
Try this formula:
Filter(CollectFiles,StartsWith(DataCardValue2.Text,Name))
Here's a doc about this api for your reference:
https://docs.microsoft.com/en-us/connectors/azureblob/#blobmetadatapage
Best regards,
Hi @KQ ,
Do you want to filter the Blob metadata collection based on DataCardValue2.Text?
I've searched the structure of BlobMetadata:
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
The unique id of the file or folder. |
Name
|
Name | string |
The name of the file or folder. |
DisplayName
|
DisplayName | string |
The display name of the file or folder. |
Path
|
Path | string |
The path of the file or folder. |
LastModified
|
LastModified | date-time |
The date and time the file or folder was last modified. |
Size
|
Size | integer |
The size of the file or folder. |
MediaType
|
MediaType | string |
The media type of the file or folder. |
IsFolder
|
IsFolder | boolean |
A boolean value (true, false) to indicate whether or not the blob is a folder. |
ETag
|
ETag | string |
The etag of the file or folder. |
FileLocator
|
FileLocator | string |
The filelocator of the file or folder. |
Try this formula:
Filter(CollectFiles,StartsWith(DataCardValue2.Text,Name))
Here's a doc about this api for your reference:
https://docs.microsoft.com/en-us/connectors/azureblob/#blobmetadatapage
Best regards,
how did you do this ?
I have almost same case. But i simply have a textinput and a gallery. I want to insert some text then display images in the gallery based on the text thats inserted into the textfield, but i want to make a startswith filter. So show all images that startswith "example string"
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
202 | |
98 | |
60 | |
57 | |
52 |
User | Count |
---|---|
257 | |
161 | |
87 | |
79 | |
68 |