You’re offline. This is a read only version of the page.
20
Hi All - I am trying to create a flow that automatically create a dynamic table range.
Based on my research I should be able to use this formula:
OFFSET(Incentive_KPI_TL!B2,0,-(N - 1),SUBTOTAL(103,Incentive_KPI_TL!$B:$N),12)
My data from paginated reports contains data starting from column B through N and after adding the above in Table range it generates an error :
The argument is invalid or missing or has an incorrect format and status code 400:
And my actual create table step is below:
Thank you in advance for anyone who can assist.
Hi @jhauw ,
You just need to use the function of Flow to combine a string similar to 'A1:B2'.
For example, assuming that the length of the dynamic table depends on the number of records in an array, the formula can be written like this:
Share
Report
All responses (
Answers (
A1:B@{add(length(variables('theArray')),1)}
Best Regards,
Bof
Thanks @v-bofeng-msft - do you have any article to show how to do dynamic range in a flow at all? Or it is not possible to do it in the flow?
Hi @jhauw ,
OFFSET is just an excel function , it will not work in a flow.
I think this link will help you a lot:
https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
Best Regards,
Bof
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
