cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
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.

Step 1:

First, we have to go to https://sharepoint.com/, then we must create a team site as preferable.

Now, create a SharePoint list with the following columns.

Rahman1005_0-1709539503198.png

 

Step 2:

Now go to https://make.powerautomate.com/ click on My flows on left navigation you can able to see new flow on top ribbon from there select automated cloud flow, as show in below screen.

Rahman1005_1-1709539503203.png

 

 

Next give the flow name as preferable and choose flow trigger as when an item is created in SharePoint. Refer blow screen.

Rahman1005_2-1709539503210.png

 

Step 3:

In the "When an item is created" box provide the site URL and select the list name as "Employeelist".

Rahman1005_3-1709539503211.png

 

Step 4:

Next click on "Add an action" then search for "Encodian" and select it.

After that search for "Create BarCode" and select it.

Rahman1005_4-1709539503215.png

 

 

Next, select "BarCode Type" like code128 or as preferable.

add "Employee ID" then a separator like "|" and "Full Name" SharePoint Dynamic Values in BarCode Data box as shown in blow screen.

Rahman1005_5-1709539503217.png

 

Step 5:

Next, click on "Add an action".

Search for "SharePoint". Then search for "Add attachment" and select it.

Rahman1005_6-1709539503221.png

 

Step 6:

Then add "Site Address", "List Name" and "ID" SharePoint dynamic value.

In "File Name" section set the file name as preferable as here "Bar-EmployeeID-Name.jpg" With dynamic value.

Rahman1005_7-1709539503222.png

 

Step 7:

 

Click on Save Flow.

To test the flow, click on the Test button from the right side of the top menu and click the Run flow button.

Step 8:

Now go to "Employeelist" in SharePoint.

Added a name here, Barcode has generated as below.

Rahman1005_8-1709539503223.png

 

Step 9:

Now Go to https://make.powerapps.com/

Next, click on "Create", and select start from Blank canvas app give the name of your app and click on create.

Rahman1005_9-1709539503230.png

 

 

Add a Barcode Reader control to the Power Apps screen and give a text to this control (i.e., Click Here to Scan)

 

Rahman1005_10-1709539503231.png

 

Add a Barcode Reader control to the Power Apps screen and give a text to this control (i.e., Click Here to Scan)

Rahman1005_11-1709539503234.png

 

 

Next, add a Power Apps Display Form to the Power Apps screen.

Connect that Display form to the SharePoint data source (i.e., Employee List). Go to the right-side Properties Panel > Fileds > Add fields.

Add all the fields to the Display Form. As a result, the form will appear as shown below:

 

Rahman1005_12-1709539503236.png

 

By default, we don't want to display the above data fields when the app will visible.

The data fields will visible only when the user scans a valid barcode. To implement this I have created a variable in the Barcode reader’s OnScan property.

OnScan = Set(VarOnScan, true)

Rahman1005_13-1709539503240.png

 

 

Use variable “ VarOnScan” on the display form’s Visible property.

Rahman1005_14-1709539503242.png

 

 

Again, insert the below expression on the Screen’s OnVisible control as shown in below screen.

OnVisible = FormViewer1.Visible = VarOnScan

Rahman1005_15-1709539503245.png

 

 

Next, add a Power Apps text label control and place it on the display form and add texts to the label control i.e., "Click on The Scanner and Scan the Barcode To Get The Employee Information"

Insert the below expression on the label’s Visible property.

Visible = !VarOnScan

Rahman1005_16-1709539503248.png

 

 

Rahman1005_17-1709539503251.png

 

 

To display the scanned item’s information, insert the below expression on the Display Form’s Item property.

LookUp(

    EmployeeList,'Employee ID' = First(BarcodeReader2_1.Barcodes).Value

)

 

Rahman1005_18-1709539503253.png

 

Save and publish the app.

Navigate to SharePoint list and create a new items in list.

Now Open the "Employee list". Click on one of the attachments you can able to find bar code.

Rahman1005_19-1709539503256.png

 

Now download the “Power Apps” Mobile Application to test the app you have created.

Now, Open the canvas app you have created via mobile application.

Scan the Barcode.

After scanning the barcode, the Employee information is visible in display form in your app as shown in below screen.

 

Rahman1005_20-1709539535721.png

Thank you..!

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.

 

Rahman1005_0-1708921824439.png

 

Next, we need add two attachments “datacard” by navigating to field property of the form has shown in below screen.

Rahman1005_1-1708921824442.png

 

By Clicking on fields, we can add multiple “data cards” on the form.

 

Rahman1005_2-1708921824444.png

 

 

Now, basically if we submit the form what will happens is all the “data fields” inside the “data cards” get submitted into the list. But you will see only one attachment will get submitted.

Rahman1005_3-1708921824447.png

 

Rahman1005_4-1708921824448.png

 

To Resolve this issue, we will get all the attachments from the attachments controls, and we need to remove the “data fields” from the both attachments has shown in below screens.

Rahman1005_5-1708921824451.png

 

 

Rahman1005_6-1708921824454.png

 

Next, we need to add another form inside the screen and must connect same “data source” as the previous form and add one more attachment control.

we need to set collection to the need added attachment control, later we need hide this form from screen.

Rahman1005_7-1708921824455.png

 

 

Rahman1005_8-1708921824459.png

 

 

Then simply by submitting the main form which is form1. then we need to patch the 2nd form and updates function into the same record by using "Form1.LastSubmit.ID".

Rahman1005_9-1708921824463.png

 

 

Now if we submit the form we will see all the attachments from both the controls are there inside the list and before the form gets reset you need to turn on the visibility of the 2nd form, you will see something like below screen.

 

Rahman1005_10-1708921824465.png

 

This Data is finally submitted list.

 

Rahman1005_11-1708921873854.png

 

Thank you..!

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.

If we want to few complete records in accounts entity on welcome screen:

Navigate to vertical Gallery and select Items property should be Item=Accounts.

Rahman1005_0-1708329533849.png

 

 

To create a new record, one must click on the plus icon displayed on the screen and input the formula provided below, as illustrated in the following screen. This action will prompt a new screen to open for the creation of the new record.

 

Navigate(CreateScreen);ResetForm('Account Create Form')

 

Rahman1005_1-1708329533853.png

 

 

After navigating to the creation screen, a new form will be displayed, and it is necessary to configure the data source to 'Account,' as shown in the screen below.

And Items property = Defaults (Accounts)

 

Rahman1005_2-1708329533858.png

 

 

Next, upon clicking the submit button, we should save the data in the account entity and return to the main screen.

We need to write below formula on Onselect property of button in app.

SubmitForm('Account Create Form');Navigate(GridScreen)

 

 

Rahman1005_3-1708329533863.png

 

 

Next, on click on cancel button we need to navigate back main screen.

Write formula on OnSelect = Navigate(GridScreen).

Rahman1005_4-1708329533866.png

 

When the edit icon is clicked, we should navigate to the edit screen, where the editing interface will open.

Add below formula on edit icon as show in blow screens and DataSource to Accounts

OnSelect = Select(Parent); Navigate(EditScreen, ScreenTransition.Cover, {})

Rahman1005_5-1708329533868.png

 

 

Rahman1005_6-1708329533871.png

 

On Item property set AccountGrid.Selected to open selected account will open in the edit form refer below screen.

Rahman1005_7-1708329533874.png

 

 

OnSelect = SubmitForm('EditForm'), Navigate (GridScreen) When the save button is clicked, the account will be updated, and the user will be navigated back to the Main Screen.

 

Rahman1005_8-1708329533877.png

 

 

OnSelect = Navigate(GridScreen) When the Cancel button is clicked, it will navigate back to the Home grid screen.

Rahman1005_9-1708329533880.png

 

 

Next, if we wish to delete a record from the account entity, we need to apply the code below to the delete icon. This will result in the deletion of the corresponding selected record.

OnSelect = Select(Parent); Remove(Account, ThisItem);

 

Rahman1005_10-1708329533883.png

 

 

Thank you..!

 

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...

sandeepstw
Super User
Super User

In the vibrant world of automation and artificial intelligence, tools like Microsoft's Power Automate are transforming the way we interact with information and manage our workflows. Today, let's dive into the interesting process of creating a Power Automate flow, specifically designed to send notifications based on the sentiment of an email received from a manager, utilizing AI Builder's capabilities. 

Read more...

rampprakash
Super User
Super User

In this blog we will see how to use Dataverse Accelerator with Low Code Plugin

Read more...

Inogic
Solution Supplier
Solution Supplier

 In this blog, we can automate the process of generating survey invitations in Power Automate Flow along with the personalized variables in the Customer Voice Survey, making it easier to collect and analyze valuable customer feedback.

Read more...

mhopus
Advocate II
Advocate II

The article unveils the intricacies of game design, emphasizing the implementation of various functionalities rather than offering a step-by-step tutorial. Explore the technical nuances of mapping, timers, triggers, and the "tick" that orchestrates game mechanics. Delve into the intricacies of point-and-click movement, a clever path-finding algorithm, and the atmospheric Fog of War. The narrative unfolds a fascinating blend of creativity, technical prowess, and the joy of bringing a vintage gaming vibe to life in a modern canvas app.

Read more...

egregorich
Frequent Visitor

The modern and updated TabList control can serve multiple purposes, such as changing views in a gallery, displaying and hiding sections on a screen, and more. One of its potential applications is to use it for simple screen-to-screen navigation. While there are other alternatives to the TabList control for screen navigation, it is still feasible. Here is how to use it:

Read more...