The following is an excerpt on restoring Power Platform environments
To restore to a production environment, you must first change its type to sandbox.
Administration mode
You can set a sandbox, production, or trial (subscription-based) environment in administration mode so that only users with System Administrator or System Customizer security roles are able to sign in to that environment.
Administration mode is useful when you want to make operational changes and not have regular users affect your work, and not have your work affect end users (non-admins).
You can optionally disable background operations such as all asynchronous operations including Dataverse workflows and email server-side synchronization.
The following is an excerpt regarding the backups of Power Platform.
System backups
System backups occur continuously and aren’t counted towards capacity.
If you use Microsoft Power Platform to create production environments that have a database and Dynamics 365 applications enabled, you can benefit from the system backups that are automatically performed for those environments. The system backups are stored for up to 28 days.
For environments that don’t have Dynamics 365 applications enabled, the default backup retention period is only seven days. However, for managed environments, admins can use PowerShell to change the setting and extend the backup retention period. The available options are 7, 14, 21, and 28 days.
All environments, except Trial environments are backed up.
Manual backups
Automated system backups are great, but you should make your own backups before making significant customizations or applying a version update.
About manual backups:
A backup is created for you when Microsoft updates your environment.
You can back up production and sandbox environments.
You can back up developer environments.
You can’t back up the default environment.
Sandbox backups are retained for up to seven days.
Developer backups are retained for up to seven days.
Manual backups for production environments that are created with Dataverse and Dynamics 365 applications enabled are retained up to 28 days.
In 2023 a slew of gaming laptops were launched with a 16:10 ratio resolution. This gives more screen real estate for people like me who also do development/coding.
When you do a game capture like Nvidia’s game capture, with a screen resolution based of 16:10 and import that into video editing software like DaVinci Resolve, it will add black bars if you set the project resolution to 16:9 ratio.
The following solutions will result in a game capture of 16:9 ratio. In addition to this, this also will use the native resolution of the monitor since the scaling is applied at the GPU level and not in the monitor.
When configuring Thunderbird with Outlook 365 account, the password fails when using IMAP account type.
I use multi factor authentication and hence this is little difficult than using plain old password. The following configuration is the recommended method across almost all articles in the Internet, but still the password will fail. There is a solution which I came across in the forums, which worked for me and I’m documenting it here.
IMAP configuration
Incoming server configuration
outlook.office365.com
SSL/TLS
Port 993
OAuth2
Full email address as username
SMTP server configuration
smtp.office365.com
STARTTLS
Port 587
Full email address as username
User configuration at Microsoft Admin Center
Go to tenant admin center. The URL at the time of writing this article is https://admin.microsoft.com.
Go to Users > Active users.
Click/press on the user who has get the incorrect password error.
In the properties panel, click/press the “Mail” tab.
Under the “Email apps” section, click the link “Manage email apps”.
Look at the check box “Authenticated SMTP”.
Check it if not already checked. If already checked, un check it, press save changes, follow the above steps and check it again.
Finally save the changes.
Wait for some 5 to 15 minutes.
Now try adding the account in Thunderbird and most probably this should resolve the issue.
For me the app password didn’t work but the above with OAuth worked!
Generating a PDF from SharePoint used to be a common requirement and when using server-side object model, it was easy to use some kind of PDF library and generate PDFs. But in SharePoint Online we can use Power Automate to generate PDFs and the following are the steps that can be used for this.
There are two ways by which a PDF can be generated.
Using OneDrive for Business’s “Convert HTML file to PDF”
Word Online’s “Populate a Microsoft Word Template” & “Convert Word Document to PDF” (These are premium action so a premium license is required and is in preview as of Feb 2021.)
In my example the scenario is to generate an invite pass for attendees attending a conference.
The generated PDF
The generated PDF will look like the following.
The data source
SharePoint List
Here we are using SharePoint Online and the data source is a simple SharePoint list which contains the following.
OneDrive for Business
The OneDrive for Business has two artificats
A Logo image is used for both methods.
A Microsoft Word Document (This will be used for the second method and not for the first method)
Please note that for both methods, the Power Automate is triggered whenever the SharePoint list item is created or modified.
In the below article when the product “OneDrive” is mentioned, it’s actually “OneDrive for Business”.
Method 1: Using OneDrive for Business’s “Convert HTML file to PDF”
The trigger is when a SharePoint List item is created or modified.
The next action would be to fetch the image of the logo located in the OneDrive.
Now we have to convert the logo into a Uri format using the expression editor and initialize a variable with it.
For the seasoned HTML developer who is well versed with HTML & CSS, he/she/they can create the HTML content or the other easiest method is to use the Microsoft Word desktop software to create the HTML.
If you use a simple method, do make sure the CSS is perfect. For the most part I tried, the conversion from HTML to PDF kept ignore the CSS, hence the second method.
HTML Content Method 2: Using Microsoft Word
Open the Microsoft Word.
Design the contents.
Save the file as “Web Page, Filtered”.
Open that file using an HTML Editor or Notepad and copy the contents.
Create an action to initialise a variable and paste the contents. Replace the image source with “LogoUri” variable, Title & ID from the trigger “When an item is created or modified”.
variables('LogoUri')
triggerOutputs()?['body/Title']
triggerOutputs()?['body/ID']
Now the HTML contents should be saved to a HTML file. We are going to use OneDrive’s “Create file” action and will use the same “Dev” folder to create the file and use the ID as file name to uniquely generate a file for each item and the file content as the “HTMLContent” variable.
triggerOutputs()?['body/ID']
variables('HTMLContent')
The created HTML file now can be converted to a PDF file and we will use OneDrive’s “Convert file using path” action. The “File Path” will rely on the “Create HTML file” action’s “Path” property.
Converting HTML Content to PDF
outputs('Create_HTML_file')?['body/Path']
Once converted the PDF content will be saved as a file using OneDrive’s “Create file” action.
Open a word and if the developer tab is not available, configure the word to make it visible as shown below.
Click on the tab “File.
Click on the menu “Options”
Click on the tab “Customize Ribbon”
Check the item “Developer” if not already checked.
Now you should have a developer tab in the ribbon.
Now use the “Picture Control Content” to add a place holder for the logo.
Once added, click on the placed “Picture Control Content” and then click on “Properties” in the ribbon to set the “Title” as “Logo” & “Tag” as “Logo”
Repeat the same for Title & ID using the “Rich Text Content Control”
Once added, click on the properties to set a “Title” as “Title” & “Tag” as “Title” for the title place holder and “Title” as “Id” & “Tag” as “Id” for ID place holder and use formats like alignment and text styles in the “Home tab”.
The word document should look like below.
Now save the file as a normal Word document with .docx extension. Upload the word document into OneDrive as “Invite-Template.docx”
Now lets go back to the Power Automate and add an action “Populate a Microsoft Word template” of “Word Online”. Choose the location of “File” where the template file was uploaded. For Logo use the “File Content” from the “Get logo file content” (Note: We are not using the “LogoUri” variable here). For “Title” & “Id”, use the “Title” & “ID” from the trigger “When an item is created or modified”.
outputs('Get_logo_file_content')?['body']
triggerOutputs()?['body/Title']
triggerOutputs()?['body/ID']
Now add OneDrive’s “Create File” action. Choose the “Folder Path” from OneDrive, where the filled Word document should be saved, along with the “File Name” being ID of the SharePoint item and “File Content” from the action “Populate a Microosft Word template”.
Now lets convert the Word document into PDF by creating the action “Convert Word Document to PDF” of “Word Online” pointing the “File” to the path returned by “Create Word file via Word template”.
Sometimes when an item is created we might need to set item level permission for those items. Fortunately, SharePoint’s REST API can help with this and Power Automate / Flow supports SharePoint HTTP calls.
First the basics of how this works
Step 1 is to identify to whom the permissions should be granted to. It can be either a person or a group.
Step 2 is to identify what kind of permission i.e. role should be granted.
Step 3 is breaking the inheritance.
Step 4 is assigning the permission.
Second is knowing the supporting APIs to gather the information
Step 1: To whom the permission should be granted?
Individual user
To identify the individual user the following API can be used. Commonly everyone relies on e-mail ID so lets take that as an example
URL: _api/web/SiteUsers/getByEmail('email@domain.com')
Method: Get
When you use Power Automate, make sure to extract the ID and place it in a variable.
body('Get_User_Id')['d']['Id']
Site Group
To identify the site group the following API can be used.
URL: _api/web/sitegroups/getbyname('Group Name')
Method: Get
When you use Power Automate, make sure to extract the ID and place it in a variable.
body('Get_Group_Id')['d']['Id']
Step 2: What kind of permission?
This is defined by the role definitions available in the site. The following API will help in identifying the role definitions and their ID.
URL: _api/roledefinitions/getbyname('Full Control')
Method: Get
When you use Power Automate, make sure to extract the ID and place it in a variable.
body('Get_Role_Definition_Id')['d']['Id']
Step 3: Breaking the inheritance
For this first thing is we need to identify the target for which the inheritance should be broken. In the following example it’s a list item.
URL: _api/lists/getByTitle('<List Name>')/items(<Item ID>)/breakroleinheritance(copyRoleAssignments=false,clearSubscopes=true)
Method: POST
As said before permission can be assigned to an individual or a group. The following API will help with that
URL: _api/lists/getByTitle('<List Name>')/items(<Item ID>)/roleassignments/addroleassignment(principalid=<User ID or Group ID>,roledefid=<Role ID>)
Method: POST
In SharePoint online, sometimes we need to hide the JSON Column formatting. For this a visibility condition can be added based on the folder content type.