I am attempting to modernize some complex Infopath forms that have data connections to other huge SharePoint lists (150+ columns), and keep running into roadblock after roadblock.
The latest one I am trying to hurdle is the limit of 12 lookup columns in SharePoint when trying to bind data to some drop-down combo boxes. In a PA forum I found that the only way to duplicate this is by using Flow/PowerAutomate, and did find this one article describing the process. It seems surprisingly complex for just retrieving column data to bind to a drop-down.
Has anyone found an alternate method? If there are none, has anyone been successful in getting the method described in that article to work?
Solved! Go to Solution.
What is the error that you are receiving with the drop down input when binding it to the SP list?
Is it related with this thread?
Yes. Same error!
The solution linked in that article is the same I am looking at. In and of itself it seems needlessly complex.
I see there was a vote for a "real" fix but no word if MS is doing anything and/or when.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!