Image Based on Multiple Condition File Name

[Anonymous]

I have an Image field in a Gallery. The image is in a separate SP library for which I have created a Collection that runs on start.

I need the Image field to display the specific certification or qualification based on the content of the file name in the library.

The file names are formatted as such:      AA0000_2008_FirstName__LastName_Driver

Is it possible to edit the following so that it forces the exact image based all or any part of the files name. If only part - the UnqID, Year, CQTitle (all columns on the Member list).

First(Filter(DocumentsCollection,Name=ThisItem.     )).'Link to item'

[v-siky-msft]

Hi @Anonymous ,

Could you please share more details about your scenario? What is the items of the Gallery? Is the Gallery bound to the Member list?

Is the file name composed by all column value from gallery Items(Member List)?

Does the following codes make sense for your case?

LookUp(
DocumentsCollection,
Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.Year,"_", ThisItem.FirstName,"_" ,ThisItem.LastName,"_", ThisItem.CQTitle)  // all conditions
||
(StartsWith(Name, Concatenate(ThisItem.UnqID,"_" ,ThisItem.Year,"_") && ThisItem.CQTitle in Name)  // part conditions
).'Link to item'

 Hope this helps.

Sik

[Anonymous]

Could you please share more details about your scenario? What is the items of the Gallery?

     Items property of Gallery where Image field was 'installed' is:

             Filter(CQCollection, FullNm = MmbrFullNmDD.SelectedText.FullNm)

     The Gallery is pulling from the list that includes columns for UnqID, CQYr, FrstNm, LstNm, and CQTitle.

Is the Gallery bound to the Member list? 

     The Dropdown that trigger the Gallery is bound to the Member list.
     The Gallery is bound to the Member Training List.
     The Image is in the Member Cert Qual List.

Is the file name composed by all column value from gallery Items(Member List)?

      The Image files in the Library are all imports from another environment. The files names appear in two ways:

             UnqID_CQYr_Jane_Doe_CQTitle.(whatever file type)

                    AA0000_2020_FirstNm_LastNm_Driver_II.pdf    

                    AA0000_2008_FirstNameLastName_DriverII.jpg

Does the following codes make sense for your case?

I tried the below and go the following error: The function 'Concatenate' has some invalid arguments.

                                                                        The function 'StartsWith' has some invalid arguments.

LookUp(CQDocumentsCollection, Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_" ,ThisItem.FrstNm,"_" ,ThisItem.LstNm,"_" ,ThisItem.CQTitle) || (StartsWith(Name, Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_") && ThisItem.CQTitle in Name),'Link to item' (<when I used .'Link to item' it errored: Improper use of '.' but it took a comma.

Starting a new system. If it is more prudent to rename the files. That may be an option; however, should that really matter?

It is my plan to have any new documents created/uploaded through the new Power Apps form to have file names forced by the system to look as: UnqID-CQYr-CQTitle.

Can you help me with that, too?!

I have a flow that uploads the files already working. I need to change the 'Create File Name' parameter in the flow through the expression writer to a concatenate function that grabs the Member's UnqID-CQYr-CQTitle from the Power Apps Upload (through a trigger in the flow) form and apply it to the file name of the document also being uploaded to the SP document library by the flow.

[Anonymous]

Also, I changed the name of several of the test files for one of the Members to different potential variations of the file name nomenclature, including to UnqID.

In this case we'll assume the Member's UnqID is AA0000. I changed one of the files names in the library to AA000 and entered the below into the Image property. This should have returned the CertQual file for the Member titled 'AA0000'. It did not. There is no error in the formula, yet still no imag.

First(Filter(DocumentsCollection,Name=ThisItem.UnqID)).'Link to item'

I use this in a similar screen to pull an image of the site, and it works fine.

     First(Filter(SiteImgCollection,'{Name}'=ThisItem.Site)).'{Link}'

[v-siky-msft]

Hi  @Anonymous ,

If the image file names are formatted as 'UnqID_CQYr_Jane_Doe_CQTitle' , Please try with the following code to Image inside gallery

LookUp(CQDocumentsCollection,
Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_" ,ThisItem.FrstNm,"_" ,ThisItem.LstNm,"_" ,ThisItem.CQTitle) ||
Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_",ThisItem.CQTitle)
).'Link to item'

For your second question, if want to pass the concatenated file name to flow, just also use Concatenate() function to compose the file name with the Member's UnqID-CQYr-CQTitle column value.

For your third question, since the UnqID is 'AA0000',and file name is 'AA000', they aren't the same. so the logic should be that the file name is contained in UnqID, or the file name is the same five characters to the left of the ID.

First(Filter(DocumentsCollection,StartsWith(Name, ThisItem.UnqID))).'Link to item'

Or

First(Filter(DocumentsCollection, Left(Name,5) = ThisItem.UnqID)).'Link to item'

Hope this helps.

Sik

[Anonymous]

I placed the following in the Image property:

LookUp(DocumentsCollection,Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_" ,ThisItem.FrstNm,"_" ,ThisItem.LstNm,"_" ,ThisItem.CQTitle) || Name= Concatenate(ThisItem.UnqID,"_" ,ThisItem.CQYr,"_",ThisItem.CQTitle) ).'Link to item'

It kicked back the following error:

1. The function Concatenate has some invalid arguments (for both the segments)

2. Type Error: Concatenate: expects either Text or a table column of Text type

For question 2; I'm having issue with the concatenate configuration in the flow. Is it triggerBody()...(blah, blah)? I've tried a hundred different ways can't get any to take. Though I know I did get it to work at one time. I'd like the concatenate formulate to name the file UnqID-CQYr-CQTitle.

For question 3: the UnqID are identical on all list/collections. My question had a typo. All UnqIDs are formatted the same (1st initial 1st Frst Name, 1st initial Lst Name, Last Four).

[v-siky-msft]

Hi @Anonymous ,

I can find any formula syntax error. Could you please share some screenshots on your app to elaborate the issue?

Sik

[Anonymous]

Not sure what to tell you. I placed the following in the Image properties and got the same error(s).

     -'Title' is the actual name of the column holding the UnqID in the SP list/collection

    - Error Message: "The function 'Concatenate' has some invalid arguments."

LookUp(CertsQualsDocumentsCollection,
Name= Concatenate(ThisItem.Title,"_" ,ThisItem.CQYr,"_" ,ThisItem.FrstNm,"_" ,ThisItem.LstNm,"_" ,ThisItem.CQTitle) ||
Name= Concatenate(ThisItem.Title,"_" ,ThisItem.CQYr,"_" ,ThisItem.CQTitle)
).'Link to item'

The dropdown is connected to a Member list(collection). The Gallery is connected to a Member Training list(collection). The Image needs to pull .pdf files from an SP document library, based on the formula above.

There are several files in the folder named in several configurations. Below is my test Member account. I have at least nine Certs and Quals in the SP library. One of those files should appear in the Gallery as I scroll though. None do.

[Anonymous]

Also, to be clear these are .pdf files I am talking about trying to pull into and Image field in the Gallery.

Is THAT even possible? Or, should I be using another process to retrieve these documents?

[v-siky-msft · Accepted solution]

Hi @Anonymous ,

Since we use ThisItem.Title to retain the Title column value from gallery, I just want to confirm if these column(Title, CQYr, FrstNm, LstNm, CQTitle)  belong to Member Training list, the Items of Gallery?  If the Concatenate still doesn't work, please change to use & operator to concatenate all text.

In addition, I suggest use Thumbnail to retrieve the image since it supports both PDF files and image files. Please try this:

LookUp(CertsQualsDocumentsCollection,
Name= ThisItem.Title&"_" &ThisItem.CQYr&"_" &ThisItem.FrstNm&"_" &ThisItem.LstNm&"_" &ThisItem.CQTitle ||
Name= ThisItem.Title&"_" &ThisItem.CQYr&"_" &ThisItem.CQTitle).Thumbnail.Large

Hope this helps.

Sik