Power Platform · SharePoint

Patch function to update a lookup column in SharePoint list using PowerApps

I have two lists and I wanted to submit some data into the first list (projects), then get that record and “link” it in a lookup column, with a new record in my second list (phases).Pretty standard parent:child or linked records by a ‘foreign key’ type setup (even though they say we shouldn’t use SharePoint… Continue reading Patch function to update a lookup column in SharePoint list using PowerApps

Power Platform · SharePoint

Choices column in SharePoint: adding new item with PowerApps customised form

I have a choice column in SharePoint that allows a user to choose an option in a select menu when viewing a form.In the default SharePoint form, when the option “Can add values manually” is enabled, a user is able to enter a new option to be added to the existing choices – it’s pretty… Continue reading Choices column in SharePoint: adding new item with PowerApps customised form

Power Platform

Saving datepickers and dropdowns into a collection using the Patch function in PowerApps

In this post I’m going to unravel some of the key points of saving datepicker & dropdown values into a collection, and then displaying them in a gallery.I have a collection with details of trips, and so I needed a way to add more line items and have them saved in the collection before submitting… Continue reading Saving datepickers and dropdowns into a collection using the Patch function in PowerApps

Power Platform

Convert strings to date format for SharePoint in MS Flow

Ok, so my SharePoint column is expecting a date/time per item in a loop, but all I have is a set of strings. Challenge accepted.I’m documenting this here for my own future reference, but this is also to show you how to get strings to date format in microsoft flow using expressions. I’ve done it… Continue reading Convert strings to date format for SharePoint in MS Flow