Posts

Showing posts from November, 2020

Implementing Radio buttons choice fields in Power Apps.

Image
 Another quick tip. By default even if you have created a radio button type choice column in SharePoint the mighty Power App will show it as Combobox. But there is a quick fix to this. Follow the below steps and have fun. 1. Select the combo box in the Data Card. You may have to unlock the card if it's not unlocked already. 2. Navigate to the item Property of the Combo box and copy it. 3. Delete the Combo box & insert a Radio control in the card. 4. Paste the copied item property of Combo box in Item property of Radio control 5. Set the update property of Data card as Radio1.Selected.     

Implementing "|| & ," in Filtering in Power Apps

Image
  Another filtering nuance i ran into today was how to implement Logical filters in Power Apps. You will find different blog posts and videos on how to implement multiple filter in Power Apps, but there isn't much showing how to implement logical filters in PowerApps.  From outset this is quiet a simple case.  Scenario: i have 3 people picker controls in my SharePoint list. Lets name them Project Manager, Sponsor and Follow Project. Now when i open my dashboard i want to see projects filtered based on these three fields. Like if a person's name is present in either Project manager, Sponsor or Follow Project fields he/ she will be seeing the project. Solution:   First of all People picker controls are still a pain in PowerApps, by pain i mean they are still treated as a complex field, filtering, delegation and controls fail to respond on using them. So what we will do is create 3 single line textbox fields in Sharepoint.  Then we will refresh the data source in power apps, so t

Multi Person People Picker control in SharePoint list forms customized via Power Apps behaviour

Image
  Today i ran into a weird issue. I had a People picker control on my SharePoint list form. Just to give you a background of my situation. i am customizing a SharePoint list forms using Power Apps. Yes, it totally sucks, but client is the king and specially when you have government client. Problem: Client wanted to have a column, lets say "Follow Project" which will be a people picker column. This column will be used for following a particular project, on which they may not be working on but are interested in. Also not to forget the higher executive, who randomly wants to check a project. Solution: i created a people picker column in SharePoint and added it to my Power Apps customized SharePoint form. i quickly tested the functionality and i was able to save, view and edit the person value. But then i realized that let me make it more flexible so as instead of users groups can also be added. Also, why not enable multiple person. All this looked out of the box, so i went to my