How to populate Look up column in SharePoint List using Canvas Apps

-

 Hello !!!! Hope you are doing well. Welcome to Anything & Everything in Tech blog. In this blog, I will explain you how to populate look up column while creating a list row in SharePoint using Canvas Apps. I have a list called "User Report Log" and a look up column named "Acknowledgement" which is derived from Acknowledgements list. 



For every operation in my canvas app I am creating a list item nothing but recording the user activities. Was wondering how to populate the Acknowledgement column? Well no issues, I used Patch request to create list item with the below format.

Patch( 'User Report',

        Defaults('User Report'),

        {

            Acknowledgement: {

                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

                Id: ThisItem.ID,

                Value: ThisItem.'Title'

            }

        }

    )

ThisItem is the Acknowledgement list item. To populate look up column in a list basically you need to pass the Id and Value properties and prepare an object with the mentioned construct.

Hope this blog helped you. Please subscribe/follow for more insights.


Comments

Post a Comment

Popular posts from this blog

How to use Google fonts in your Web Page

-
Image
Welcome to Anything and Everything in Tech blog! Today's tip is how to use google fonts in your web applications. CSS has inbuilt support for a wide variety of fonts. However, Google fonts are not recognized by CSS. Let's look at the sample HTML. This is a sample text that should be displayed in Noto Sans It uses Noto Sans as font. When I browse the HTML file, the font does not take effect. To refer to Google fonts, we need to refer to Google stylesheet. <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=<google-font-family>" /> In our case, the URL should be referring to Noto Sans format. <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Noto+Sans" /> Hope this helped! Please subscribe to our blog for more interesting posts on tech.
Read more

How to populate Person column in SharePoint List in Canvas Apps

-
Image
 Hello Everyone!!! Welcome to Anything & Everything in Tech. In this blog I will guide you how to create SharePoint list record which has Person column. I have a list called User Report which has a person column named User On each and every operation of the user a log record is created from the canvas apps. We all know using patch request we can create a row in the list but there comes the problem how to pass the person value in it??. Well the rescue steps are here by, use the below format in your patch request to populate the person column  User: {             '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",             Department: "",             Claims: "i:0#.f|membership|" & Lower(User().Email),             DisplayName: User().FullName,             Email: User().Email,       ...
Read more

How to display AM/PM for a Date field in Canvas Apps

-
Image
Hello All !!!!.  Welcome to our  Anything & Everything  in tech blog 😊😊.  The topic for today is on Microsoft Power Apps and in this post I will show show AM/PM for your date fields. Canvas apps are the leading low code framework for mobile apps and custom user interfaces. One of the powerful feature being able to bring in data from multiple data sources using just connectors. They are just termed as One Click Data from Multiple Platforms Let me jump in to the topic. I have a requirement to display display a date with AM/PM.  Unfortunately, Canvas apps function reference does not have any function to do this. However you can use the ubiquitous Text function to do it. $"{Text(Today(), "dd/mm/yyyy, hh:mm am/pm ")}" Within the Text() you can pass your date field and specify the desired format. Observe the part highlighted in bold - am/pm . I have seen implementations where makers end up using switch case on the hour field to determine AM/PM time. In the belo...
Read more