cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Steelman70
Level 10

Connecting to SharePoint lists with Lookup, Person/Group, Choice, Calculated, Hyperlink/Picture cols

Here is what works for me, screenshots below.

 

  1. If you do not have such a list, create a SharePoint Online list including all the above column types.  However for Lookup, Person/Group, Choice columns you should NOT select the option to allow multiple values.  Say the list is called MyList and all columns are called MyLookup etc.
  2. In PowerApp Studio create a new blank app
  3. Add the data source to your new PowerApp as described here, say the data souce is called MyList
  4. Insert a text box to your PowerApp screen and set the Text property to any of the following:
    • First(MyList).MyLookup.Value
    • First(MyList).MyLookup.ID
    • First(MyList).MyPersonOrGroup.DisplayName
    • First(MyList).MyPersonOrGroup.Email
    • First(MyList).MyChoice
    • First(MyLIst).MyCalculated
  5. Insert an HTML Text control to your PowerApp screen and set its HtmlText property to the following
    • Concatenate("<a href='",First(MyList).MyHyperlink,"'>",First(MyList).MyHyperlink,"</a>")
  6. Insert an image control to your PowerApp screen and set its Image property to the following
    • First(MyList).MyPicture

The only issue I have not resolved is how to retrieve the Hypelink text or the picture Display text from the SharePoint list.  As you can see in 5 above I have cheated by using the hypelink itself as the text.

 

 The Lookup and Person or Group columns seem to be read only, whereas I have been able to Patch back a text value to a Choice column.

 

Capture_list.PNG

 

Capture_ouput.PNG

1 REPLY 1
Anonymous
Not applicable

Re: Connecting to SharePoint lists with Lookup, Person/Group, Choice, Calculated, Hyperlink/Picture

Thank you for your message. I would like to add my experience.For my part, I tried to display on the gallery the column choice. However this does not work with your formula. I think it does not work when there are other lines on the list.

 

My solution:

1) Click on the gallery> click on the pencil> add a drop-down control.

2) Click on the gallery> then on layout to display the new right side panel.

3) Assigned your column to the drop-down control.

4) This one appears on the gallery but it remains modifiable. To rectify this:

5) On the visual properties of the control (the right side panel). In the "display mode" section, I select "show" instead of "edit"

 

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (2,644)