Custom Pages use different controls than Canvas Apps

 Those who've worked with canvas apps and custom pages have probably noticed that there are some controls which are only available in canvas apps, like pen input, drop down and address input, but today I noticed that one a particular control that has been replaced. More specifically, the text input control. Canvas Apps has a control called Text Input , it's a basic input box with some nice properties, like Reset, and default value. Custom Pages does not have Text Input , they instead have something called a Text Box , and it does not have the abovementioned properties. Why is that important? Well say you've got a gallery and you use some controls to input text there, let's say you use it to be able to update multiple rows at the same time. Now you want to have any function to modify several items at the same time, in this example say we want a CLEAR button which reverts the changes you have done since last save. With a Text Input , you can simply put a variable in the

Using upsert in power fx with multiple records

There's a lot of good content to be found out there regarding Power FX and the different functions it has, but one I struggled to find (blame my lack of google-fu) was how to do upsert requests with multiple records. tl;dr For those who don't need/want any more context, here's an example on patching new and updated records using a defined collection of contacts: ClearCollect ( myContacts , Contacts @ {     'Last Name': "Wick" ,     'First Name': "John" ,     Contact: GUID ( "4d751116-985d-4fa2-ba96-cdf70511de13" ) }, Contacts @ {     'Last Name': "John" ,     'First Name': "Little" ,     Contact: Blank () }) ; Patch ( Contacts , myContacts ) ;   And here is one generating the records to be updated in the patch statement: ClearCollect ( myContacts ,     { GivenName: "Michael" , Surname: "Bolton" , Id: "a46a84cf-df57-48de-a418-a7b937a91363" },     { GivenName:

Adding new assets to a Power Pages solution

 In case you missed it, some weeks ago Microsoft made Power Pages solution aware for everyone (NB: Only for enhanced data model (NBNB: How to convert from the old to the new data model ))  🎉🎉🎉🎉 But did you notice this text box on the page? This means that if you are a decent human being and put your Power Pages project into a solution, whenver you add mode site components to your Page it won't automatically get added to the solution (tl;dr: table rows), you have to add them manually. To make matters worse there are of course no prefixes or anything to tell you where a certain site component belongs, so it looks like this Well do not fret anymore, for I have the best of news for you. The easiest way to add all the missing components, starts by removing something, namely the site itself. Step 1: Open the solution, and remove the site from the solution (NB! Don't delete from the environment) Step 2: Add the site back into the solution Step 3: Profit, you now have all the requ