There are some known issues you might need to know when connecting from Microsoft PowerApps to SharePoint
Known issues
You can add data from a custom list but not a library. In addition, not all types of columns are supported, and not all types of columns support all types of cards.
| Column type | Support | Default cards |
| Single line of text | Yes | View text |
| Multiple lines of text | Yes | View text |
| Choice | Yes (single values only) | View lookup |
| Number | Yes | View percentage View rating View text |
| Currency | Yes | View percentage View rating View text |
| Date and Time | Yes | View text |
| Lookup | Yes (single values only) | View lookup Edit lookup |
| Boolean (Yes/No) | Yes | View text View toggle |
| Person or Group | Yes (single values only) | View lookup Edit lookup |
| Hyperlink | Yes | View URL View text |
| Picture | Yes (read-only) | View image View text |
| Calculated | Yes (read-only) | |
| Task Outcome | No | |
| External data | No | |
| Managed Metadata | Yes (read-only) | |
| Rating | No |
Moreover, PowerApps doesn’t support columns that support multiple values or selections.
- For Lookup columns, the Allow multiple values checkbox must be cleared.
- For Managed Metadata columns, the Allow multiple values checkbox must be cleared.
- For Person or Group columns, the No option under Allow multiple selections must be selected.
- For Choice columns, the Drop-Down Menu or Radio Buttons option under Display choices using must be selected.
Source: https://powerapps.microsoft.com/en-us/tutorials/connection-sharepoint-online/#known-issues
Discover more from SharePoint Monkey
Subscribe to get the latest posts sent to your email.
