In today’s blog, we will continue with the security side of SharePoint document integration within the model-driven app. The feature of security roles within Dataverse takes security to another level. It’s one of the best features! So far, we have enabled the OOB integration of SharePoint documents, which you can read here. Let us now see how we can control the access. In this blog, I am sharing references for the contact table. Let us go to Advanced settings in Power Apps and navigate to security roles. You can either upgrade an existing security role or copy a security role and make the ch ..read more

In today’s blog, I am sharing how can you enable SharePoint integration with Dataverse. Are you wondering why & when you should use this? Well, this could be a use case where you had moved data to Dataverse but still want to keep all your documents in SharePoint. However, if the size of the document is huge, and you don’t want to keep it in SharePoint or there are organizational reasons you can choose to move your data to may be Azure blob storage. Let us open advanced settings and navigate to document management Let us start the easy steps of enabling the server-based SharePoint integra ..read more

In today’s blog, I am sharing two different ways how to retrieve related entities from Dataverse. The use case considered for the blog is to retrieve all attachments associated with the contact entity. I will be using a manual trigger for this blog, but the trigger will vary depending upon your use case could be a Power Apps trigger or any other trigger from the connectors list. Let us get started with the Power Automate flow. Method 1 – Use OData You can read more about Odata (Open data protocol) here Let us get all contacts with attachments columns. Use Expand query and mention the column n ..read more

In my previous blog, I shared how we can transfer SharePoint list data & its attachments to Dataverse. In today’s blog, I will show how we can move the attachments from Dataverse to One drive using Power Automate. Again, this is one of the ways of data migration & related entities could be any. When to use – It can be used for archiving your data which is old in Dataverse. It would also help you keep your Dataverse capacity under the limit. For testing purposes, I have used the Manual trigger. It could be a scheduled trigger (like run every Saturday for data older than 2-3 years maybe ..read more

Have you read about Forms, when to use them & how to use them? If not, let’s have a quick read and build our understanding. By the end of the blog, you will have a demo ready. Forms are a quick and efficient way of creating, displaying, and modifying your data. It connects to your data source and gives you quick access to easily add required fields. This is a much simpler way in comparison to adding each field and then submitting data individually on a screen. Let us add two screens. One screen with Gallery to display the list of records & some icons for adding, viewing, and editing d ..read more

Ever wondered about the different ways of moving data from SharePoint to Dataverse? There are many ways via – SSIS, Azure Data Factory, Dataflow, Scribe, and other migration tools. Let us add Power Automate to the list as well. In today’s blog, I am sharing how to move data & its attachments using Power Automate flow. This example of flow works for multiple attachments as well. First things first – Always add comments to your Power Automate flow. It helps you & your team to understand what this step is doing. Avoid customizing the step name. It will be overwhelming for people who do ..read more

A very quick read! I was working on Power Automate related to attachments & found the below error. Invalid character in field ‘documentbody’: ”, hexadecimal value 0x10, is an invalid character.  “message”: “Invalid character in field ‘documentbody’: ‘\u001a’, hexadecimal value 0x1A, is an invalid character.”, After a few research and some time later, I found the solution. Let us replicate the error first. The data source could vary from where you are reading the attachment. I have used SharePoint here for example. The A ..read more

Today’s blog is a kind of continuation of my previous blog. However, there is no sequence to it so you can always enjoy reading it after this blog. Let’s think about Apps differently would be more appropriate, isn’t it? To enhance the Power App, we will see some quick things to do and customize the properties of controls to make it stand out from the classic controls. As part of today’s blog, we will cover the below –  Enhance buttons Enhance forms Enhance Buttons When you insert a button, a classic button is added to the screen. Based on the space you have on the app screen you can cu ..read more

In our earlier blog, we saw how to create a simple & basic Power App. In this blog, I will share some tips on enhancing some of the features. We will cover the below features today – Name the landing page of the app Show the logged-in User Enhance Gallery Experience First thing first –  Always follow a naming convention – It will be easy for you and your team to read and update when some enhancement is required.  Always write comments in your Power apps – It will be easy to read and understand the code as well helps in code review Every organization has a naming co ..read more

In today’s blog, we will see how to perform basic operations of Power Apps. And, then in the next blog, we will take it to an advanced level. We will see how to add & submit a new data record, view the data, and then modify the data. Navigate to make.powerapps.com, go to your environment & create a canvas app. I have selected the mobile format. Add and Submit new record Next, let’s add a blank screen & rename it to Home Screen. Let’s put a vertical gallery (Insert > Gallery > Vertical) & add accounts table as the data source. Items property of the gallery control is Acc ..read more