PowerApps Ideas

New Idea

Would like the ability to be able to have some action occur whenever the HEADER row of a Data Table is clicked/touched.  When this occurs should also be able to know where in the header the click occurred (ie: which column header).

 

Most likely this would have an OnSelect property or something.

 

Main use case is the ability to be able to let the user (for instance) sort the table in the table (ascending/descending) by the column header that was clicked (under app control - it would decide what to do and which column).

 

Currently the only way this can be done is to look at the OnSelect property for each column/field in the table, which only appears to fire whenever an actual row that has data (not the header) is clicked.  It would be acceptable to have this (optionally perhaps) fire when the header row is selected - assuming there is the ability to know it was the header row and not one of the rows of data.

 

Hide the Sharepoint button bar, so that we can instead put our own "Submit" and "Cancel" buttons at the bottom of the form. Creating a custom "Submit" button works fine at the moment, but a custom "Cancel" Button does not seem to work like it should.  However it defeats the purpose if users can just use the default save which does not have the custom actions.

Date Picker - Needs a "HintText" property

Status: New
by tism Monday - last edited Monday

The Date Picker control needs a "HintText" property.

 

I have created a customized SharePoint form in PowerApps, and I have two fields on the SharePoint list: "Commencement Date" and "End Date".  The fields are not mandatory, and have been configured with a default of "(None)".

 

When you go to create a new list item, the customized PowerApps form appears, and for each date field it shows a hint text of "31/12/2001" (The date format for the date pickers was set to "dd/mm/yyyy").  This is confusing users, as they are trying to specify "No Date" somehow.

 

It's also confusing them even more when they view an existing list item, because even though no date was set, it's still showing as "31/12/2001".  Even though the date appears greyed out, it's not obvious to the user that "no date" was set.

 

HintTextDate.PNGForm in Edit ModeHintTextDate2.PNGForm in Display Mode

 'By adding a "HintText" property, instructions could be placed in the picker, such as "select a commencement date". Then in display mode, if nothing is selected, the HintText is not shown so that the viewing user is not confused.

Quite often I have the need to skip/offset the first few records of a table/items of a gallery.

 

In SQL the offset function allows you to specify offset -1 to skip the first row.

 

I have managed to faciliate this with the help of this community with the below, but it's somewhat complex for such a simple function.

 

LastN( SortByColumns( Filter( '[dbo].[MyTable]', TextColumn = TextInput1.Text), "DateColumn", Descending), CountRows(Filter('[dbo].[MyTable]', TextColumn = TextInput1.Text)) - 1)

Alt has been introduced as to ease PowerApp testing during development. On Visible can run if we move from one screen to another but the OnStart will not run until I save, close and repoen my app. Also can be COPIED to a OnSelect of a Button so to say, but the fact that I should copy everytime I make a change leads to mistakes when I forget!

 

Please add a button in the Rubbon to Run the PowerApp OnStart event.

 

Thanks!

Hi,

Would be nice if we had an OnSubmit/OnSaving event on the form controls that we could use to do validations. Kind of like the PreSave function on sharepoint forms. If the event retured true powerapps would wubmit the form , otherwise it would not. We could put validation logic in the event and show/hide custom error messages as needed, 

 

As it is now, we need to scatter this logic throughout different controls. With various nested dependencies it can be difficult to understand where such logic should be declared. Providing a single place where such logic could be declared would make it much easier to develop and also much easier for a new person to understand what the form is doing.

 

I see the Validate method can be used to peroform some validations based on the schema, but there are other validations we often need-- which cannot be expressed in the schema-- that would be ideal candidates for a OnSubmit event.  Particularly when there are a lot of interdependancies between fiels on a form.

 

Would be great if we could have an API we could use to generate our apps.  The app generators provided bt microsoft are ok, but it would be great if we had an api to build our own. 

 

For instance creating a genereator that lets users select tables/list in a database /sharepoint site, and generating screens for each list/table and a menu to access each.

Currently, the only way to reorder fields in a form is to drag them up or down. While this is somewhat intuitive and seems like a good idea, it's a huge pain when reordering many fields. Also, it's sometimes unreliable.  For example, sometime when you drag a field up or down, then when you move another field, the first one snaps back to its previous position. I've experienced this behavior in Edge (when it decides to not crash on me - another gripe for another time) and Chrome (which seems to be what the vast majority of folks - even Microsoft MVPs and employees - use for PowerApps). 

 

If you need some inspiration on what a "better means" might look like, this is what is available in the Blackboard Learn LMS. They call this the "keyboard accessible" reordering method. I call it the "elevator button", and it's a lifesaver when you want to move things up or down on a page, particularly when doing so would involve the page content scrolling. PLEASE, PLEASE, PLEASE put something like this in PowerApps. Heck, I'd even settle for something like the control for reordering columns in a modern list view. But the current mechanism is driving me insane.

 

 

As one of the most common scenarios of using PowerApps while having SharePoint lists as a data source. 

It would be great if we can Export/Import this developed apps with it's associated SharePoint list(s) templates to be reused with different tenante (customer).

 

This can be added in the site collection Admin page as Install SharePoint PowerApp where a the exported file can be uploaded.

As an application developer, I need to be able to label the PowerApps application releases I produce so that I can track changes to application features over time within the publishing tool instead of separately, outside the tool.

Hi All,

 

Having the option to have the date picker permenantly expanded could create a very rich user experience.

For such a date picker the selected date property should change any time a new date is clicked rather than when OK is clicked.

 

image.png

 

PLEASE give us a real code editor. This dropdown thing has to go. How about using Monaco?

Is that possible to make PowerApps can refer to a column via a variable?

 

I want to use "Patch" function to update column in Data Source. But the number of columns to be updated and columns name is not fixed. So it would be great of PowerApps to allow dynamically refer to a column.

 

 

For example, is it possible to replace the "DataField_8" below with dynamic variable such as "Dropdown2.Selected.Value"?

 

 
Patch(dbo_Update, LookUp(dbo_Update, ProductCode=Dropdown1.Selected.Value), {
    DataField_8 : TextInput1.Text
})

Powerapps has the capability to automatically create a phone app.  There must be some API to do this.  Provide the API so users can automatically create phone and tablet apps with specific formatting and naming.   I would like a C# interface but others are ok. 

Published Version Number

Status: New
by philashby a month ago

It would be useful if the published version number of the app was available as a variable within the app. By displaying in a text field, you then have an immediate and dynamic way of seeing if a user is running the latest version.

I work in an organization which has thousands of employees across North America.

 

A common scenario will be that someone develops a PowerApp which they will have to share with, let's say, 300 people. Currently the person sharing the app would have to type in each person's name ONE AT A TIME to share it with them (that's 300 names typed and 300 tabs or clicks to accept them).

 

Most "Power Users" or "Citizen Developers" of PowerApps do not have the ability to create security groups in the Azure Common Directory so that is not a solution. Creating different environments based on geography is also not a solution since apps will be shared with no regard for geographical location.

 

Please provide a solution for sharing PowerApps with a large number of users which can be done easily. Or, let us know how you envisioned this being done.

MySQL connector currently does not support cloud but supported only when using On-premises data gateway. Thus, we cannot get direct connection on cloud services such as Amazon RDS.

As this is something affecting critically all our cloud customer base and their productive environments, it would be nice if MySQL connector does support cloud service in hope that it will attract more people to get to use/know Flow.

 

As we are getting connection through On-premises data gateway on Azure VM, here are some things for us that was hard to comprehend:

-The error stating that MySQL Connector/Net is required to connect MySQL connector to On-premises data gateway, however, there is no description in the Technet or other documents. It will be nice if you could describe that in those documents.

-The error stating that 64-bit version of MySQL Connector/Net is required is displayed with an URL. However, there is no 64-bit found in the link page of that URL. Please correct the information in the error.

-I hope you to change the background color of the error window because the red background color might not good for users’ eyes.

 

Thank you for your consideration.

Some services on Office 365 such as Power Apps or Flow will be restricted when the IP restriction is set for other services. We need to allow IPs manually with hundreds of settings for those Office 365 services, and this setting is related to AD and this setting increase workload for users.

 

Since I have heard that SharePoint and Dynamics relations are enhanced like users are able to customize SharePoint forms on PowerApps, it will be very helpful if some preset setting will be added such as “Allow access to Power Apps and Flow or Allow access all services of Office 365 when users manage the IP restriction for SharePoint and OneDrive for business.

 

Thank you for your considerations.

Currently in block of code (such as in an OnSelect property), while semicolons (in at least US English) are used to separate functions/actions, the LAST one cannot have a semicolon without PowerApps complaining (often confusingly).   


From a coding perspective, this is very annoying and wastes a lot of the time, especially when one may add or remove functions from a code block, especially when nested in If() and other statements.  For example in the below:

 

 

 

Set( VarA, 123 );
Set( VarB, 456 );
ClearCollect( MyCollection, 
     {     A: 1, B: 2, C: 3    },
     {     A: 4, B: 5, C: 6   }
);
Set( VarC, 789 )

 

The last statement must NOT have a semicolon at the end.  However, if I remove this, then I'll also need to remove the semicolon after the end of the ClearCollect().  

 

But then if I again add another statement at the end again - I'll not only have to readd the semicolon to the end of the ClearCollect(), but will also have to make sure not to have one at the end of the last statement.

 

While this makes sense from a "list" perspective (where you only use a comma for instance between items), from a coding perspective this is annoying, wastes time, and goes against what most other languages allow.  In some languages everything must end in a semicolon whether last one or not.  But virtually all at least ALLOW the final statement to have a semicolon (Yes, I can think of a few other exceptions).  

 

This just simply wastes time of the user.  Please change the parser to allow an OPTIONAL semicolon at the end of statements at the end of a code block (including code blocks within other calls, like If(), etc).

 

Sharepoint Powerapp webpart for classic sites

Status: New
by mzandegiacomo 2 weeks ago - last edited 2 weeks ago

The Sharepoint Powerapps Webpart for modern sites looks good and the performance is very well. Can you please also make the Webpart 

available for classic pages? I think this would help a lot of Users since classic pages still are used a lot.

Labels
Idea Statuses
Labels