Display Separate SharePoint List Items in Single Gallery

[PVLove]

Hello All!

I am at a loss on how to display input from two SharePoint list items in the BrowseGallery's "Text" field. This is what I'm trying accomplish, if possible.

If the list item is a company contact (DSIContactName) I want the BrowseGallery's Title field to display the DSIContactName (Person or Group column that allows multiple selections) and the Subtitle field should display the DSIContactTitle (Choice column); the Body field will display the DSIContactEmail (Single Line of Text column).

If the list item is contractor contact (GCContactName) I want the BrowseGallery's Title field to display the GCContactName (Single line of Text column) and the Subtitle field should display the GCContactTitle (Choice column); the Body field will display the GCContactEmail (Single Line of Text column).

I used this statement, Concat(ThisItem.DSIContactName, DisplayName, " "), to display the DSIContactName, but I don't know how to include the GCContactName.

Any assistance is sincerely appreciated!

PLove

[yashag2255]

Hi @PVLove 

How do you identify if a contact is company contact or if it is a contract contact? If you can share more details about the schema of the SP List/Lists and how they are configured to be used, we might be able to help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PVLove]

Hi yashag2255,

Thank you for the quick response!!  I'm attaching screenshots of the SharePoint list columns as well as the list with test items.  A third screenshot displays the contractor information when I set the Title 'Text' field to ThisItem.GCContactName, ThisItem.GCContactTitle, etc.  Please let me know if additional information is needed; I'm not sure if I'm communicating the correct information or details.

Patti

PowerApps Form w/Contractor InfoSharePoint ListSharePoint List Columns

[yashag2255]

@PVLove 

Thank you for sharing the details. Can you update the configuration of the Gallery to below expressions?

Gallery -> Title -> Text -> Coalesce(ThisItem.DSIContactName,ThisItem.GCContactName)

SubTitle -> Text -> Coalesce(ThisItem.DSIContactTitle,ThisItem.GCContactTitle)

Body -> Text -> Coalesce(ThisItem.DSIEmail,ThisItem.GCContactEmail)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PVLove]

yashag2255,

The results of the Coalesce function for each Gallery configuration.

Gallery -> Title -> Text -> Coalesce(ThisItem.DSIContactName,ThisItem.GCContactName) > Error Message: The function 'Coalesce' has some invalid arguments. (I added .Value to each ThisItem, but that did not work either.)

SubTitle -> Text -> Coalesce(ThisItem.DSIContactTitle.Value,ThisItem.GCContactTitle.Value) > I added '.Value' to each ThisItem and it worked perfectly!

Body -> Text -> Coalesce(ThisItem.DSIEmail,ThisItem.GCContactEmail) > Worked perfectly as well!

Patti

[yashag2255]

@PVLove 

What is the type of field that you are trying to parse in Title? If this is a Person type column, then try .DisplayName

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PVLove]

The 'DSIContactName' is a SharePoint Person or Group column that allows multiple selections.  The 'GCContactName' is a SharePoint Single line of Text column.  The Coalesce argument is still invalid.

[yashag2255 · Accepted solution]

@PVLove 

In that case, can you update the expression to:

Coalesce(ThisItem.GCContactName,Concat(ThisItem.DSIContactName,DisplayName,";"))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[PVLove]

 yashag2255,

You are my hero ... it worked like a charm!  Thank you so very much.

Patti

[PVLove]

@yashag2255 

Can you help me with this issue once again?

Three additional columns were added to the SharePoint list, VendorContactName (Single line of Text), VendorContactTitle (Single line of Text) and VendorEmail (Single line of Text). I was able to update the Coalesce statements for the Body and Subtitle fields, but the Title field is not as simple.

Original expression: Gallery > Title > Text > Coalesce(ThisItem.GCContactName,Concat(ThisItem.DSIContactName,DisplayName,";"))

Updated expression: Gallery > Title > Text > Coalesce(ThisItem.GCContactName,Concat(ThisItem.DSIContactName,DisplayName,";"),Concatenate(ThisItem.VendorContactName,";"))

This expression displays the VendorContactName, but adds a semicolon ";" at the end of the Vendor name in the Gallery. I'm not sure if Concatenate is correct.  A screenshot is below.

Thank you for all your help!

Patti