cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
sandeepstw
Super User
Super User

Microsoft has unveiled its latest innovation within the AI Builder ecosystem: the ChatGPT model. This cutting-edge addition opens up a world of possibilities for businesses seeking to enhance customer interactions, streamline internal communication, and revolutionize their service offerings.  

Many businesses are adopting ChatGPT to fulfill their business requirements. Just imagine the convenience of automating ChatGPT tasks so you don't have to manually open it to compose emails. With Power Automate, all this can be automated. Whether it's responding to customer emails, selecting candidates, or identifying errors in your work, you can automate everything and utilize ChatGPT to enhance the quality of your work processes. 

Read more...

Amik
Super User
Super User

I recently came across the following scenario posted on the forums and I moved my response to this blog.

Read more...

Joseph_Fadero
Advocate V
Advocate V

The excitement around low code solutions and technological advancements has made everyone eager to see automation advances. Since we are technophiles and using low-code technology is our course of action, automating our process is not only an exciting but groundbreaking move for us. Even so, we need to take a moment to reflect and consider: Automation is undoubtedly beneficial, but is it necessary for everything to be automated? As digital automation becomes more prevalent, the dilemma of how to discern which jobs are appropriate for automation and which ones are not arises. We should not put off taking the initiative to search for indications of various parallels among these pointless initiatives.



Read more...

rampprakash
Super User
Super User

In this Blog, we will see how to use Multilingual Language in Canvas PowerApps.

Read more...

Rahman1005
Advocate II
Advocate II

User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address.

Step 1:  Navigate to make.powerapps.com, screen 1 àCreate a Blank Canvas App à Connect with Dynamics 365 Data Source à Connect Contact Entity as Dataset (You can connect other entity also as per your requirement)

Rahman1005_0-1710842494629.png

 

Rahman1005_1-1710842509874.png

 

Step 2:  Screen 2 - Insert a new Blank Screen to show Duplicate Detection Dialog

Rahman1005_2-1710842522609.png

 

Step 3:  Add few Text Input and Button Controls in Screen 1 or design as per your need.

Rahman1005_3-1710842533166.png

 

Step 4:  Add below formula on Button Control (onSelect property) to find Duplicate Record.

If(IsBlank(

LookUp(Contacts,emailaddress1 =Emailaddress_Text.Text)),

UpdateContext({result: "Duplicates Record not found"}),

Navigate(DuplicateDetectionDailogbox,ScreenTransition.CoverRight)

);

Rahman1005_4-1710842549409.png

 

You can use following formula also on Button Control (onSelect property) to find Duplicate Record

UpdateContext({recordCount: CountIf(Contacts,emailaddress1 = Emailaddress_Text.Text)});

 

If(recordCount > 0, Navigate(DuplicateDetectionDailogbox,ScreenTransition.Fade))

 

Step 5: Test the App

Rahman1005_5-1710842562069.png

 

Before running the App, I’ve taken the existing email address from an existing contact.

Rahman1005_6-1710842585847.png

 

 

And I’ve entered details into the App. Upon clicking 'Submit,' the Duplicate Detection Screen will appear.

Rahman1005_7-1710842596973.png

 

 

If you provide a new email address that does not exist in the contact records, the result will be display as “Duplicates Record not found”. You can find result from variables.

Rahman1005_8-1710842605865.png

 

Thank you..!

LaurensM
Super User
Super User

In this blog post we’ll explore how introducing a collection to our scanning approach can easily allow us to build our own ‘reset’ functionality for the Barcode Reader control.

Read more...

Amik
Super User
Super User

I recently came across the following scenario posted on the forums and I moved my response to this blog.

 

Scenario:

 

When a user selects a record from a Gallery control, an Edit Form is automatically populated with the selected record. The user wants to be able to copy the existing record, make a change to one or more fields, and then submit the Form as a new record.

Read more...

Rahman1005
Advocate II
Advocate II

A login screen acts as a barrier between the content of your application and unauthorized users.

with the help of logging screen, you can have control on access and sensitive information and maintain integrity of application by making users to authenticate them.

Let’s get started with creating a login screen in PowerApps.

Step 1: Create a New App

Log in to PowerApps and navigate to the 'Apps' section.

Click on 'Create an app' and choose the 'Canvas app from blank' option.

Step 2: Design the User Interface

Once the new app is created, you can open the app using PowerApps Studio.

Design the login screen interface by adding two input fields for ‘Email id and ‘Password along with a ‘Login’ and ‘Register’ buttons.

You can add two text labels to text input boxes as shown in below screen.

Rahman1005_0-1710161762178.png

 

 

Step 3: Connect to Data Source

Go to the ‘View’ tab and click on ‘Data sources’ à Add data and search for SharePoint, then click on Add a connection as shown in below screens.

Rahman1005_0-1710506025550.png

Once connection is added you can able to find data source.

Rahman1005_1-1710506057606.png

 

Step 4: Validate User Credentials

Double-click on the ‘Login’ button to open the formula bar.

Use the Lookup function to check if the entered username and password exist in your data source. The formula might look like:

If(!IsBlank(LookUp(EmployeeList, Email= TextInput1.Text And Password=TextInput2.Text).Title),Navigate(View_Screen_1),Navigate(Failed_Screen));

Reset(TextInput1);

Reset(TextInput2);

 

Rahman1005_4-1710161762189.png

 

 

Step 5: Handle Navigation

If the credentials are valid, navigate user to your app main screen else navigate user to error scree.

 Login error screen :

Rahman1005_5-1710161762190.png

 

Login successfully:

 

Rahman1005_2-1710506082242.png

Step 9: Publish and Share

Once testing is complete, publish your app.

Hope this article help!

AhmedSalih
Most Valuable Professional
Most Valuable Professional

Single Email with Multiple Dataverse Attachments via Power Automate" provides a comprehensive guide on using Power Automate to send out ONE email containing multiple attachments from a Dataverse table. In this video, I demonstrate the creation of an array variable with JSON from the 'Send Email' action to facilitate this process. We explore essential Dataverse actions, such as 'List Rows' and 'Download File or Image,' to efficiently handle and retrieve the required data and attachments for the email. Follow along with this detailed tutorial to learn how to consolidate multiple attachments into a single email using Power Automate.

One Email with Multiple Dataverse Attachments via Power Automate 

Read more...

AhmedSalih
Most Valuable Professional
Most Valuable Professional

Streamlining Your Workflow: How to Bulk Download Attachment Files from a Dataverse Table from a Canvas Power Apps
Are you managing data in Dataverse tables, and do you have a canvas app for your end-users that they can use to download multiple attachments from these tables? The process can be time-consuming and complex. This blog post introduces a streamlined solution using a Power Apps formula, making your workflow more efficient.

Download Multiple Attachments from Dataverse table using a Canvas Power Apps! 

Read more...

LaurensM
Super User
Super User

In this article we will first familiarize ourselves with the Left, Mid, Right and Find functions – the key building blocks required for text extraction. More importantly, we will explore ways in which we can combine these functions to meet our more complex, dynamic text extraction requirements.

Read more...

365-Assist
Multi Super User
Multi Super User

Based on my recent recruitment experience I wrote an article where I share who I believe would be a great Power Platform Specialist.

Read more...

Rahman1005
Advocate II
Advocate II

In this article, we will learn how we can create bar code with the help of Power Automate and have bar code in SharePoint list as attachment and scan barcodes with the help of Power Apps.

Read more...

sandeepstw
Super User
Super User

In the realm of business, we often encounter a myriad of document formats containing vital information crucial for our organizational needs. From resumes and invoices to contracts and reports, the task of manually extracting relevant data can be time-consuming and prone to errors. However, in this article, we delve into a transformative solution: leveraging AI Builder models to streamline and simplify this process. Join us as we explore how effortlessly you can create and train custom AI models to extract information tailored to your business requirements.

Read more...

DeviKrishna
Super User
Super User

In this blog we will see how to increase Do Until Loop in Microsoft Flow.

Read more...

Rahman1005
Advocate II
Advocate II

First, we need create simple form as show below using SharePoint list which has the following columns - Full Name, attachments inbuild column.

Read more...

Amik
Super User
Super User

I recently came across the following scenario posted on the forums and I moved my response to this blog.

 

Scenario:

 

We have a SharePoint List which has three SharePoint LookUp Columns:

 

  1. Country: configured in SharePoint as a Single-Select SharePoint LookUp column.
  2. City: configured in SharePoint as a Multi-Select SharePoint LookUp column.
  3. Town: configured in SharePoint as a Multi-Select SharePoint LookUp column.

 

We want to add these fields into an EditForm control, and cascade each Combobox selection according to the levels ordered above.

Read more...

LaurensM
Super User
Super User

In this blog post we will more explore ways to append & remove a user from a multi-select SharePoint Person column via the Power Apps Patch function.

Read more...

Rahman1005
Advocate II
Advocate II

User story: When a new account is created, there is a requirement to execute a curd operation via Power Apps, involving updating an existing record and deleting the record from the accounts.

Read more...

Inogic
Solution Supplier
Solution Supplier

Power Apps is its high-productivity development platform for business apps. The ability for Makers to interact with experienced advisors is certainly a valuable resource that can help them better understand any problems they may encounter while using Power Apps. As an advisor, your knowledge and expertise can help empower the Makers in your organization, making them more knowledgeable and productive contributors to the team.

Read more...

Inogic
Solution Supplier
Solution Supplier

In the realm of Microsoft Power Pages and Dataverse, the ability to track changes by Contacts (Portal users) in the auditing process is crucial for comprehensive data management. This blog has provided a step-by-step guide to overcoming the limitations, offering advanced configurations for enhanced user-specific auditing. By implementing these measures, organizations can ensure a transparent digital experience, aligning with the evolving landscape of low-code application development and data governance.

Read more...

sandeepstw
Super User
Super User

In today’s digital age, harnessing the power of artificial intelligence (AI) is no longer reserved for data scientists or developers. With Microsoft’s AI Builder, organizations of all sizes can now effortlessly infuse AI capabilities into their business processes without the need for extensive coding or technical expertise. In this article, we'll explore what AI Builder is and how you can leverage its capabilities within Power Automate to create intelligent workflows. 

Read more...

Rahman1005
Advocate II
Advocate II

In this Power Apps Tutorial, we will discuss what is the Power Apps Search function, it’s syntax, how to use the Power Apps search function in a canvas app. We will see how to apply a search box in Power Apps.

We will also see how to search for items from the Data Vase Account Entity using the Power Apps search function.

Also, We will see how to use the Search function in a Vertical Gallery Control and how can you do multiple searches.

Please fellow below screens.

Click on Create app à Give app name based on your requirement and click on Create

 

Rahman1005_0-1707453047679.png

 

 

Rename first screen as main screen it will be easy to understand.

Rahman1005_1-1707453047686.png

 

 

Step-1:

First of all, on your Power Apps Screen, Add a Blank Vertical Gallery Control (Insert -> Gallery -> Vertical). Then connect a Data Source as Account (As my records are present in Account Entity) as shown below.

Rahman1005_2-1707453047690.png

 

 

 

 

Rahman1005_3-1707453047694.png

 

 

Step-3:

 

In the below screenshot, you can see all the records are retrieved from the Account entity. Here, your Item property should be your Account Entity name (‘Account ‘).

Select the Gallery and go to the Properties pane. Select the Layout as “Name, Address “. Edit the fields and add the columns as per your choice.

 

Rahman1005_4-1707453047696.png

 

 

 

Rahman1005_5-1707453047699.png

 

 

 

Step-4:

 

Now to search the fields from the PowerApps vertical gallery, we need to add a search bar on the top of the Gallery. For that, go to Insert -> Text -> Add Text Input as shown below.

The Text input control will insert and it will show the default value as Text. Just remove the Default value and in Hint Text give as “Search by Account” as shown in below screen.

Rename Text input as Search Box for added text box. 

Rahman1005_6-1707453047702.png

 

 

Step-6:

 

Select the Vertical Gallery control and apply the below Search function formula on its Items property as:

Items = Search ('Event Registration Details', SearchBox.Text, "Title")

Rahman1005_7-1707453047705.png

 

 

 

Rahman1005_8-1707453047707.png

 

Thank you..!

elseb
Super User
Super User

If you need more custom Icons in your app, this post is for you! We will use the Formulas and experimental feature of User Defined Functions to create custom lightweight icons which you can reuse throughout your app and adjust the colours using function parameters!

Read more...

Inogic
Solution Supplier
Solution Supplier

This blog explained the process of invoking a custom action from Power Apps to close opportunities and create related records, emphasizing the importance of handling output parameters for a successful user experience. Overall, the guide showcased the flexibility of Power Apps in creating tailored solutions for efficient business processes.

Read more...

rampprakash
Super User
Super User

How to use Retrieve and Retrieve Multiple using PowerShell - Microsoft Dataverse

Read more...

Inogic
Solution Supplier
Solution Supplier

As technology continues to advance, the integration of offline capabilities remains a key aspect of providing a seamless and continuous user experience. As illustrated above, we can now easily use images and files within your Canvas app when there is no internet connectivity.

Read more...

Inogic
Solution Supplier
Solution Supplier

The “Mobile Offline for Canvas Apps (Preview)” feature serves as a pivotal component of the Power Platform, empowering users to design apps that prioritize both user experience and functionality. This functionality addresses the challenges posed by limited or no internet connectivity, enabling seamless interactions even in remote or unstable network environments. By embracing offline functionality, Canvas Apps are breaking barriers and providing users with a more flexible and robust app experience.

Read more...

365-Assist
Multi Super User
Multi Super User

Are you looking to add a personal touch or a brand-specific style to your Power Apps canvas app? The title bar, the vibrant strip at the top of your app, might be the perfect place to start.

Read more...