Filter data between two dates in PowerApps


To filter data between two dates in PowerApps, you can use the Filter function. The Filter function allows you to return a subset of data based on specific criteria.

Here is an example of how to use the Filter function to return data between two dates:

  1. First, create two date picker controls in your PowerApp to select the start and end dates for the filter.
  2. In your data source, create a formula that uses the Filter function to return data based on the selected dates:
Filter(
   YourDataSource,
   YourDateColumn >= StartDatePicker.SelectedDate &&
   YourDateColumn <= EndDatePicker.SelectedDate
)

In this example, YourDataSource is the name of your data source and YourDateColumn is the name of the date column you want to filter on. The StartDatePicker.SelectedDate and EndDatePicker.SelectedDate are the values selected by the date picker controls in your PowerApp. You can then use this filtered data in a gallery or data table to display the results of the filter.

Comments

Post a Comment

Popular posts from this blog

InfoPath to PowerApps: Best Practices

Image
 Here are some best practices for converting InfoPath forms to PowerApps: Plan the conversion: Start by mapping out the fields and controls that are used in the InfoPath form and how they will be translated into PowerApps controls. This will help you understand the scope of the conversion and what needs to be done. Evaluate the form data: Determine where the data from the InfoPath form is stored and if it is accessible from PowerApps. If not, consider using an alternative data source that is accessible. Choose the right PowerApps control: Consider the type of data being entered and choose the appropriate control that matches the data type, such as text input, checkbox, drop-down, etc. Use custom formulas and expressions: PowerApps has a rich set of formulas and expressions that can be used to perform complex data manipulations. Utilize these to replace the InfoPath form rules and custom code. Test the conversion: Once the form has been converted, test it thoroughly to ensure that a...
Read more

Create Azure AD groups from a CSV file

Image
To create Azure AD groups from a CSV file, you can use Microsoft Graph API and the Azure AD Graph API to programmatically create groups in your Azure Active Directory tenant. Here are the steps to follow: Authenticate to Azure AD: You need to authenticate to Azure AD by acquiring a token using OAuth 2.0. Read the CSV file: Read the CSV file containing the group information into your code. Create the groups: Use the Microsoft Graph API or the Azure AD Graph API to create the groups in your Azure AD tenant. The API requires you to send an HTTP request to create a group, which includes the group name and other properties such as description and mailNickname. Import the members: You can also import the members of each group from the CSV file by sending an HTTP request to add members to a group. Note: To avoid making multiple API calls for each group, you can also batch multiple group creation and member addition requests in a single API call, if supported by the API you are using. Here...
Read more

PowerApps Governance: What to consider

Image
PowerApps governance refers to the policies, guidelines, and procedures for managing and administering PowerApps within an organization. It covers aspects such as the creation, deployment, and management of PowerApps, as well as the security and data management considerations. Some of the key components of PowerApps governance include data source management, user access and permissions, development and testing practices, and change management processes. The goal of PowerApps governance is to ensure that PowerApps are used effectively and efficiently while also protecting the organization's data and resources. Here are some steps to consider when implementing PowerApps governance: Define the Purpose: Clearly define what PowerApps will be used for within your organization and the expected outcomes. Establish Ownership: Assign a PowerApps administrator to oversee the platform and ensure compliance with governance policies. Define Security Requirements: Set up data security and privacy...
Read more