Here is what works for me, screenshots below.
- 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.
- In PowerApp Studio create a new blank app
- Add the data source to your new PowerApp as described here, say the data souce is called MyList
- 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
- 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>")
- 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.


Report
All responses (
Answers (