web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How can I create a dyn...

Power Automate

Answered

How can I create a dynamic table range in power automate?

(0) Share

Report

Report

Posted on by jhauw

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.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jhauw 20 on at

Like
a
(1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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:

A1:B@{add(length(variables('theArray')),1)}

Best Regards,

Bof

Was this reply helpful? Yes No
LeeS 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it does, I have been using it for years in combination with COUNTA as well to dynamically size a table

Was this reply helpful? Yes No

Join the conversation