Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by

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. 

 

Ajwou_0-1615557255164.png

The column in SP has the following settings:

Ajwou_1-1615557401941.png

Please would anyone be able to help. 

 

Kind Regards, 

 

Ivo

 

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @RandyHayes 

    Thank you for the information. I was trying to make it easier for the app, however I can now see the issues it might also bring. 

     

    As for the AbsoluteUri, I used the code provided earlier, however when printed to PDF the 'links' do not contain the link for the actual files. I am probably missing something here. 

    Ajwou_0-1615880761410.png

    I was wondering if that might be due to having multiple attachments

     

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @Ajwou 

    If you have a datasource that you cannot delegate filters to or exceeds the 2000 record limit (after delegable filter), then collections would be needed to accommodate.  However, this is usually rare for most apps, so the datasource can (and should) be used at the items source.

     

    You should be utilizing the AbsoluteUri property of the attachment to get to the attachment. The attachments are stored in the record, so they are definitely not a local file.  Typically you would set the OnSelect action of your label with the file name in it to Launch(ThisItem.AbsoluteUri)

     

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @RandyHayes 

    Tried using the Source data SP and it works - the attachments are shown on the PDF but the links are only to the actual PDF file on a local HDD

     

    Ajwou_0-1615831358605.png

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @RandyHayes 

    The main reason was only the warning from PA in terms of Delegation for large datasets. Other than that there was no other reason. 

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @Ajwou 

    Is there a particular reason that you are using a collection for the items source on the Gallery?

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @RandyHayes 

     

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

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @Ajwou 

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

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @RandyHayes 

    I have a Search formula for Browse Gallery1_1

    Ajwou_0-1615822090859.png

     

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @Ajwou 

    What is the Items formula for BrowseGallery1_1 ?

  • Ajwou Profile Picture
    Ajwou on at
    Re: Retrieve names (choices) collected through multi selecting Combo box to one column in SharePoint

    @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

     

    Ajwou_0-1615802450009.png

    Any suggestions?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard