web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Office Script Error : ...
Power Automate
Unanswered

Office Script Error : primitive range

(0) ShareShare
ReportReport
Posted on by

My requirement:

'Workbook1': 'SDG', sheet 1, table: 'WHODDSDG'

'Workbook2': Dynamically created, get stored in SharePoint library. I can run the script using Power automate flow, when the file is created. 'Workbook2': name- dynamic, sheet 1 which has table Power App, and sheet 3 which has table 'WHODD'.

When this new file ('Workbook2' is created, data is entered into table 'Power App').

 

Note: Table 'Power App' in sheet 1 of 'Workbook2' only has 'one column' with the header 'All Hierarchy'.

 

Now I want to run the script(s), whereby column 'A' in table Power App in sheet 1 of 'Workbook2' matches the data in column 'N' ('Final Hierarchy') of table "WHODDSDG" in sheet 1 of 'Workbook1' (that is SDG). Once the data is matched, I want the matched data from all the columns of table 'WHODDSDG' in sheet 1 of 'Workbook1' (SDG) to be pasted onto table 'WHODD' of sheet 3 of 'Workbook2'.

 

Note: table 'WHODD' has headers exactly same as headers in table 'WHODDSDG'. Identical. 

 

@DamoBird365  Can you please help. I have many videos and trying to replicate but not getting it right.part1.pngpart2.png

 
I was thinking of leveraging power automate flow to pass string from one to another. 
Reason to run the script: 'WHODDSDG' has over 5 lacs rows so looping each in power automate might take years 
Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 271

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard