Answered

Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

(0) Share

Report

Posted on by Ajwou

Hello,

I have collected some 'Names' from Office365Users through Combo box (multi choice selection) into one column in ShareFile. I am now trying to retrieve that information from the SharePoint column into HTML Text (for PDF printing via flow). See below the code - SITE TEAM section is where I struggle.

The column in SP has the following settings:

Please would anyone be able to help.

Kind Regards,

Ivo

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Ajwou

You did not mention what information you wanted to have in your Html from the Person column - Display Name, Email, Title, etc.

I will assume DisplayName in this case.

Please consider changing your Formula to the following:

... ... <td class='thirdWidth'>" & Concat(BrowseGallery1_1.Selected.SiteTeam, DisplayName & ", ") & "</td> ... ...

This will give you a text of all of the DisplayNames in your column concatenated together with a comma-space.

If the ending comma-space is an annoyance then also consider the following:

... ... <td class='thirdWidth'>" & With({_n:Concat(BrowseGallery1_1.Selected.SiteTeam, DisplayName & ", ")}, Left(n, Len(n)-2)) & "</td> ... ...

I hope this is helpful for you.

Was this reply helpful? Yes No
Ajwou on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes

Thank you very much for your help. Yes, I was after DisplayName. Both suggestions worked so went with the second one (adding _ to the n argument).

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ajwou

Yes...oops, I forgot to put the underscore in on the n's. Glad you spotted that and that it is working for you now.

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
Please would there be also a way how to retrieve attachments from the SP list? Something like link to the attachment so when printed on PDF if could be either clicked on or copied and pasted to a web browser

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ajwou

Yes, you can put in your Html something along these lines:

... <ul> " & Concat(BrowseGallery1_1.Selected.Attachments, "<li><a src=" & AbsoluteUri & ">" & DisplayName & "</a></li>") & "</ul> ...

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
Thankyou for getting back this. The formula seems to struggle with the Attachment part - it only offers 'Has Attachments' column for some reason, however the Attachment column is in SP

Any suggestions?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ajwou

What is the Items formula for BrowseGallery1_1 ?

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
I have a Search formula for Browse Gallery1_1

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ajwou

Is SharePointData the name of your DataSource or is that a variable/collection?

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

I see - SharePointData is a variable/collection. Is there a way to read the data from the actual Data Source ShareFile?

Was this reply helpful? Yes No