{How to fetch more than 256 rows from Excel using Power Automate}

-

 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 Threshold limit to get your actual data.

Hope this blog helped you and please do subscribe/follow for more insights !!!!

Also, do let us know if you have any queries or you want me to write on any specific topic for you!!!!

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