Showing posts from March, 2024

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: