Share
Report
31Hi all,
I have a very large, very complicated excel workbook that is also macro-enabled (xlsm) and about 25 mb. The standard excel connectors have had great difficulty working with this book due to the size and amount of data within it. I understand that Microsoft Graph is the better connector to use with large data sets.
In my workbook, I have a tab "Portal" that is 110 rows by 620 columns. Every cell is formula driven off other tabs in the workbook.
I am trying to do a Graph API call with values only set to true, but I keep timing out with a 504 gateway. Am I doing something wrong? Is my data just to complex to make anything work and am I doomed to forever have to copy the data manually?
Below is the flow I'm using to test. The flow times out on Invoke an HTTP Request 2.
Ultimately, if I get the Graph Call working, I will blend it into another working flow that goes like this:
- My associate updates Workbook 1 and Workbook 2, then initiates the approval flow.
- I receive notification for approval, review both Workbooks for accuracy, and then approve.
- After approval, the flow replicates the working copies to the master files, and also creates copies for organizational use in a separate folder.
- Use Graph to copy values from the portal tab from Workbook 1 and the portal tab for Workbook 2, append together, and create a master portal file
- Flow finishes
- Manual step - I upload the master portal file to our corporate website to update the daily data.
Any help or insights are appreciated. I'm trying to get a better working knowledge of the GET/POST functions and Graph so I can build more automated flows on updating these Workbooks.
All responses (
Answers (
