cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vish_p
Level 8

Using Dynamic variable while limiting Get items by view

I have an issue ,actually my list has crossed maximum no:of lookup columns (12),now i would like to retrieve data from the list using flow but i have to "Limit Columns by View" in Get Items using a dynamic variable ,but it fails when i use a dynamic variable there,please help me out here.
I have attached screenshot fyrc.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Using Dynamic variable while limiting Get items by view

Hi @vish_p 

 

Thanks for your reply.  Please make sure you are mapping the view GUID for the dynamic content. The name doesn't work. I got the similar error when I used the name instead of GUID.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

7 REPLIES 7
Super User
Super User

Re: Using Dynamic variable while limiting Get items by view

Hi @vish_p 

 

Have a look at this post

 

https://www.about365.nl/2018/07/04/microsoft-flow-get-item-from-list-with-more-than-12-lookup-column...

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



vish_p
Level 8

Re: Using Dynamic variable while limiting Get items by view

@abm  Please understand the issue is not to bypass lookup column issue ,the issue is i have to use a dynamic variable in place of selecting the view in "get items" action as shown in image..please refer to that and guide accordingly

Super User
Super User

Re: Using Dynamic variable while limiting Get items by view

Hi @vish_p 

 

Thanks for your reply. Could you post your error you are getting from flow?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Super User
Super User

Re: Using Dynamic variable while limiting Get items by view

Hi @vish_p 

 

This is what I tried.

image.png

 

Here I have set the view ID in a compose action and set the custom value mapping as output of the compose action. This worked successfully for me. Initially I passed the view name and it failed. 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



vish_p
Level 8

Re: Using Dynamic variable while limiting Get items by view

@abm 

 

Please find the screenshots of error as below : C1.JPG

 

 

As well u can see the view opening successfully in browser :

 

c2.JPG

 

 

Super User
Super User

Re: Using Dynamic variable while limiting Get items by view

Hi @vish_p 

 

Thanks for your reply.  Please make sure you are mapping the view GUID for the dynamic content. The name doesn't work. I got the similar error when I used the name instead of GUID.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



View solution in original post

vish_p
Level 8

Re: Using Dynamic variable while limiting Get items by view

@abm  Thank you very much for the quick resolution 

I used GUID in place of view name and it worked as intended

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (5,398)