web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps with SharePo...
Power Apps
Unanswered

PowerApps with SharePoint Online

(2) ShareShare
ReportReport
Posted on by 2,129

Content migrated from TechNet.  Post attribution to:  Benjamin Niaulin

 

Hi,

 

Coming from a SharePoint space, looking at PowerApps to solve a lot of business requirements for mobile apps with SharePoint list.

 

However, it seems that at the moment of preview there are certain things that are not supported by PowerApps. Is there a list somewhere available that will be maintained?

 

List of supported column types, list of supported list templates.

 

Also, I don't see a control for Data and Time.

 

SharePoint is great for organizations to store and work with their data and not just documents. For example, we have a very simple list at the office to order lunch. A mobile PowerApp would be awesome to allow people on the go to "order". But at the moment most of the fields are not supported and they can't easily enter a date from a date picker.

 

Thanks,

Benjamin Niaulin

Benjamin Niaulin Blog: http://bniaulin.wordpress.com

Twitter: @bniaulin

Categories:
I have the same question (0)
  • Migrated_User Profile Picture
    2,129 on at

    Hi Benjamin Niaulin,

     

    So far, there is no documentation with list of supported column/list types.

     

    If you want to use Data and Time in PowerApp, I suggest you use DateTimeValue functions to convert a date and time string to a date/time value.

     

    More information about the DateTimeValue for your reference:

    https://powerapps.microsoft.com/en-us/tutorials/function-datevalue-timevalue/

     

    Thanks,

     

    Dean Wang

  • Migrated_User Profile Picture
    2,129 on at

    Hi

    In fact, I have designed an Mobile App for Order on the go. BUT, the apps is for Enterprise used. So, sharing with external might not be supported at the moment until PG open-up for public use but the chances is every slim.


    PK Hong

  • Migrated_User Profile Picture
    2,129 on at

    Custom lists with basic data types such as string, number, yes/no (Boolean) and date are supported for both blank or app from data creation. For datetime types, you need to covert to string in Patch formulas.

     

    We are interested to learn what your high priority needs are for SharePoint scenarios, please share your feature request here, we'll make sure we capture them.

     

    For Dates we have a picker control under Insert>Controls. For editing scenarios such as  involving date, time or datetime you can use the Date/Time cards from QuickTools>Content tab

  • Migrated_User Profile Picture
    2,129 on at

    Hi Benjamin Niaulin,

     

    https://powerapps.uservoice.com/forums/331617-general​

     

    It is a place for customers provide feedback about PowerApps. What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Thanks,

     

    Dean Wang

     

  • Migrated_User Profile Picture
    2,129 on at

    Will go to Uservoice most definitely, did not know it existed, is it somewhere in the app during the preview? 

     

    As for SharePoint Online needs I am more than happy to talk about a few and we can meet at the next MVP Summit perhaps or even before to discuss some of it.

    Here is the gist of it, SharePoint aims to provide a user-driven platform for organizations to build what they need without that developer know-how necessarily. We create sites for different teams or business units and within them have tables. These are as you know our Lists and Libraries. They add value to organization because it allows them to easily create them, manage the columns themselves and tag content accordingly. Then we use pages, views and the search engine to surface that content in whatever way we want.

    We've lost InfoPath to create forms for these lists, connecting to our lists and making a better way for people to enter data within these lists. It allowed us to make them branded as well as adding some logic to them "if you select this and filter that and submit the info to these multiple places or start this document approval process using this info"

    We are also no longer getting any improvements on the SharePoint Designer front, which today is basically only used for building Workflows. I think is comparable to your Logic Flows.

    If PowerApps could make it easier for the SharePoint audience to adopt it, I am convinced it would fit the needs we have for forms which at the moment could start with mobile apps and eventually go to browser app (which is like a form) and of course the workflows or logic flows.

    If I for example create a SharePoint list for people to enter data (see image below)

    I'd expect as a SharePoint user to be able to open this PowerApps tool and quickly generate a mobile app that represents my columns in the same way in the app. Remember the audience we have in the SharePoint/Office 365 world which is not always developer. Also explained the success of SharePoint Designer because it was a "for the people tool" that information workers could pick up and go, build something for their company.

    I see PowerApps filling that if possible.

    If I connect my list shown above wit the default SharePoint form to PowerApps, I'd like to see the same controls automatically done.

    A date and time control, not the date that I need to convert and have people type in manually but the usual calendar control we see everywhere online these days.

    If I have a choice column or lookup, I expect it to be the same when I add the field on my form.

    Same for people and groups column.

     

    This would allow anyone allowed to use PowerApps to just connect and build something mobile, that looks good and perhaps take it even further with all the power available in PowerApps.

    Right now, Logic Flows is the same in that it's too complicated for those Power Users that we have and which would be the people in charge of building these as it is not the IT or the Developers in charge of the various sites. Right now, I need to know the internal name of a column created or somehow know how to add an ODATA filter to create a logic flow from SharePoint Lists.

    It's not the right audience in my opinion. And I am worried that the product owners of PowerApps decide not to invest any more within these connections because of the data you will get back from the preview and not enough people using it. 

     

    @LauraOnu thanks for the tip on the Date/Time cards, I had seen it and tried it once. But after connecting my SharePoint list it would not let me get it to work with errors like invalid name. I will continue to look into this.


    Benjamin Niaulin Blog: http://en.share-gate.com/blog Twitter: http://twitter.com/bniaulin

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 633

#2
11manish Profile Picture

11manish 588

#3
Valantis Profile Picture

Valantis 457

Last 30 days Overall leaderboard