Learning SharePoint

I ts good to be back with some new learning that I recently did. Recently I was trying to generate a report to identify ideal time of the resource in my team. There I came to know an interesting thing about PowerApps GroupBy function. Before we discuss on the limitation, lets first look at syntax. GroupBy (Table, ColumnName1 [, ColumnName2, ... ], GroupColumnName) Table - Required. Table to be grouped. ColumnName(s) - Required. The column names in Table by which to group records. These columns become columns in the resulting table. GroupColumnName - Required. The column name for the storage of record data not in the ColumnName(s). Note: For SharePoint and Excel data sources that contain column names with spaces, specify each space as "_x0020_". For example, specify "Column Name" as "Column_x0020_Name". Now, this Group By will work fine with text, number, date, Duration and other simple column types. However, these doesn’t work with Choices and lookup colum

Since a few months I am working for a client who is trying to do miracles using Power Platform. I am fortunate enough that he picked me as a developer lead for this project. We have been working with PowerApps, Power Automate and Dataverse and now I thought of sharing a few tips to ease your work if you are new to Power Automate + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Lets take choices columns. Unlike SharePoint or any other data source, Dataverse choices are different so basically I cannot go to my powerapp and check Department = "SharePoint" in dataverse. You will keep on getting error. Dataverse assigns a ID to each choice that we add to a dataverse column. Something like below. How do I know what is the ID of my choice? You need to go to the table that you are using in Dataverse, click on column. From panel on right select "Edit Choices" and then Click on Eclipses besides choice and click on "