I understand that now , Power Automate have a limitation that the lookup column threshold limit it the maximum number (12) of lookup columns , please refer to below article.
http://www.benprins.net/2019/01/15/flow-working-around-the-lookup-column-threshold/
I am a new user in power automate but I need to maint some existing share-point site , I would have three question want to raise:
1) Are there any effect of the existing flow? Because some of my share-point list have more than 12 column and seems the workflow works well before. I am guessing the flow might create before ms set this limitation.
2) If I modified the workflow of the existing site , would the flow failed because of this new limitation? Because we will have a site re-vamp and may need to use some of the exiting flow. for example just add a "send an email " function and save the flow.
3) Do you have any suggestion rather than create flows with different view? Because this limitation make us hard to maint the existing site which currently have more than 12 columns.
Please help provide some suggestion as it is a site link to many work flows and we afraid that will cause some of the function works before re-vamp of the site but failed to use after we do the upgrade , this will cause a huge trouble and might irreversible.
