Anything & Everything

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

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

 Hello Everyone!!!. Welcome to Anything & Everything in Tech knowledge store. Today I have a very simple topic to share with all my readers. Let me dive into the topic very quickly. I have a simple task using Power Automate I need to fetch all rows of excel and get the count of Unique Customers. I have an excel with the necessary columns and I am using List rows present in table action from Excel online business connector as shown below. I mentioned all the necessary inputs required to pull the data and everything seems to be fine. Unfortunately, I am able to fetch only 256 rows but my Excel has 10,000 rows. Now I am stuck as I could not get the actual data of the table. After exploring the options of the action I figured out, there is something called Pagination  turning it on can bring in more data. Just click on Settings of the List rows present in a table action and you will see something called Pagination and threshold . Turn on the Pagination and specify the Thre...