I have this really complex flow that I don't want to rewrite. Is it possible to use a formula to decide which SharePoint list to Get Items from?
If the answer to a forms question is x then get items from x SharePoint list, else get it from y sharepoint list on the same site. if(equals(formAnswer,'x'),x,y) and if(equals(formAnswer,'x'),'x','y') don't work, neither does referencing the lists using their identifer.
Solved! Go to Solution.
See my example below. I ran the Flow and it completes without error if I select List A or List B. My expression can be seen in the Action notes.
See my example below. I ran the Flow and it completes without error if I select List A or List B. My expression can be seen in the Action notes.
It works! I don't know why it didn't when I was trying it before, but thanks!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |