{"id":913,"date":"2024-12-09T01:02:54","date_gmt":"2024-12-08T22:02:54","guid":{"rendered":"https:\/\/mryed.com\/?p=913"},"modified":"2024-12-09T01:39:46","modified_gmt":"2024-12-08T22:39:46","slug":"powerapps-dinamik-word-ve-excel-olusturma","status":"publish","type":"post","link":"https:\/\/mryed.com\/en\/yazilim\/kodlama\/power-platform\/powerapps-dinamik-word-ve-excel-olusturma\/","title":{"rendered":"Creating Dynamic Word and Excel with PowerApps"},"content":{"rendered":"

Creating dynamic documents using PowerApps automates your business processes, saving time and increasing productivity. In this article, I explain step by step how you can easily create Word and Excel documents by leveraging the power of SharePoint, Power Automate and PowerApps.<\/p>\n\n\n\n

Dynamic Word and Excel Creation<\/h2>\n\n\n\n

In my previous articles, I talked about creating excel with flutter.<\/a><\/em> Now I will talk about how we can do a similar process easily with powerapps.<\/p>\n\n\n\n

First of all, I will not go too much into the beginning of powerapps in the content of the article. I continue by assuming that you have created the design and forms on the Powerapps side.<\/p>\n\n\n\n

How to Create a Dynamic Word Document with PowerApps?<\/h3>\n\n\n\n

Let's start with word first. To create a dynamic word document in Powerapps, we need to open a document library in sharepoint. We can import the columns in this document library into the word document as it is. For this reason, when we assign the data we receive from the user in powerapps to the columns in the sharepoint document library, the process is almost complete. So how can we write data from powerapps to the document library;<\/p>\n\n\n\n

For this, let's first create a word document to use as a template in the document library we have opened. Then let's create some columns to throw into this document. Our infrastructure is almost ready. Now we will throw the data we receive on the Powerapps side to Automate and from there we will write data to the columns in the document library we have opened. For this, I convert my data into JSON in Powerapps.<\/p>\n\n\n\n

\/*\nPowerapps json olu\u015fturarak ak\u0131\u015fa bu json verimizi g\u00f6nderiyoruz ve d\u00f6n\u00fc\u015f olarak bir link al\u0131yoruz. Daha sonra Launch komutu ile bu linki a\u00e7\u0131yoruz. \n*\/\n\nSet(\n    jsonData,\n    JSON(\n        {\n            Name: Txt_Name.Value,\n            Lastname: Txt_Lastname.Value,\n            City: Txt_City.Value,\n            AktifMi: Cb_AktifMi.Checked\n        }\n    )\n);\nSet(\n    wordLink,\n    'Dinamik-Word'.Run(jsonData).url\n);\nLaunch(wordLink)<\/code><\/pre>\n\n\n\n
This code converted the data in the application into JSON and sent this JSON to the stream named \u201cDynamic Word\u201d.It also saved a text returned from the stream in a variable named \u201cwordLink\u201d.Then it opened this link with the \u201cLaunch\u201d command. <\/p>\n\n\n\n
Now let's move on to the streaming part.In the flow, we first get the JSON data that will come from Powerapps.We can also get data one by one here, but when the number of data increases, it can be a problem. For this reason, I generally work with JSON. Then I access my data by parsing the incoming JSON file. Then I copy the template word document I created earlier in the document library. In the next step, I create new data with this copied document. Then I save my JSON data that comes as a parameter in the columns of the new data created. In this way, we have created a data in the sharepoint document library.<\/p>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
To write the columns in the Sharepoint library to the word document, we open the word document we added as a template. From the Insert section at the top, we click on the Document Property field in Quick Sections. Here we can see the columns we opened in sharepoint. You can add the column you want to the desired area of the word document.<\/p>\n\n\n\n
How to Create Dynamic Excel with PowerApps?<\/h3>\n\n\n\n
Creating a dynamic excel is a bit more complicated. But you have more possibilities. In the word document we followed the progression PowerApps - Power Automate - Word, but in the excel phase we will follow the progression PowerApps<\/a><\/em> - Power Automate - Excel Script - Excel. Excel scripts are special codes written for excel. I like it more than Word because it gives me more freedom. I can do almost everything I want very easily here.
<\/p>\n\n\n\n