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 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

{When a HTTP Request is received trigger Power Automate Additional Options}

-
Image
 Hello Everyone. Welcome to my blog. Hope you are doing well. Today's blog topic is an interesting feature from Power Automate flow. We all know about HTTP Request trigger " When a HTTP request is received " widely used in automation flows. Using this trigger we can invoke the flow from client side scripting as well now it has got new updates which is very beneficial and incorporates deeper control invocation. Create an automated flow and choose the trigger When a HTTP request is received trigger as shown below. You can see the new option " Who can trigger the flow?? " using this you can limit/restrict the users triggering the flow. Below are the list of options Anyone - any internal/external user can trigger the flow Any user in my tenant - only users respective to tenant can trigger the flow. Specific users in my tenant - only mentioned within the tenant can trigger the flow. Avail this option for better control of the flows. Hope this tip is useful for you....
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