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

We have been working with PowerApps, PowerApps and Dataverse and now I thought of sharing a few tips to ease your work if you are new to PowerApps + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Let’s take Multi Choice Columns this time. Unlike SharePoint or any other data source, Dataverse Multi choice columns are different so basically, I cannot go to my PowerApp and directly print selected value in a label. So, this is how you can show multi choice values in label. You need to use concat that allows to concat multiple selection. PowerApps has concat function that takes. Concat function syntax :  Concat (  Table ,  Formula  ) In my case I am trying to render a multi choice column values into a vertical gallery webpart. I have added a label control to a vertical gallery and then added below code.   Concat(ThisItem.ColumnName,Value & "") Hope this helps, Thanks, Keyur

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, Let’s take Lookup Columns this time. Unlike SharePoint or any other data source, Dataverse Lookup columns are different so basically, I cannot go to my Power Automate and directly update a lookup field with just the ID. You will keep on getting error and flow will keep on failing. So, this is how you can update lookup columns. We need to provide Dataverse table name and GUID in parentheses. Contacts(83c259e2-1039-4110-af70-79f353dc92a5)   This will handle lookup. In you add new item/update action we put the source table name with GUID of lookup. Regards, Keyur Pandya