Power Platform Community Forum Thread Details

Hello All. Thank you for looking. I appreciate any advice. Desperation has set in!!

Environment: O365 Power Automate Cloud Flow

Data: Two excel tables, uploaded to SharePoint Online. Table A is a control log, ~4,000 rows. Table B will change weekly ~ 4,000 rows.

Key Value: General format. All values in this column are unique. Some are numeric (Ex.'123456789'), some alpha numeric(Ex.'A12345678'), and with leading zeros(Ex.'001234567'). All values are the same length (when the leading zeros are present).

Challenge: I want to compare the two tables and if the Kay Value is found in both tables then "Update a Row" in Table A- Control Log. I will them preform other actions like sending notifications based on the status in the control log.

I have found ways to quickly compare the data with arrays. I am using Filter and Condition at times. I am also using OData filter in "List Rows in Excel" step, to break up that comparison into smaller pieces (for faster processing).

Settings: List Rows - Pagination = ON with Threshold of 5,000; Apply to each- Concurrency Control = ON with degree of parallelism of 50.

Issue: The flow works! Yay!... sort of... It's way too slow for use in a regular process. I found a way to compare the data in the tables but then what to do with it? Updating Excel Table A, the control log has been the last issue in my process. After the status of the rows in Table A- Control Log are all updated I can then run all flows off the control log with no issue. I just can not update the rows in Table A- control log in any decent amount of time.

Help! All suggestions welcome. Any tricks I can use to update a row in excel faster? Do you think I am setting it up all wrong? Tell me what you think. I am willing to explore all options. I've got a beautiful process that is stuck on one fatal bottleneck.

Thank you for reading.

~"LongRuntime in Louisville"

Categories:

Building flows