Learning SharePoint

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