Answered

Use formula to decide which SharePoint list to Get Items from

(0) Share

Report

Posted on by uggliMuggli

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.

All responses (2)

Answers (1)

uggliMuggli 22 on at

Like (0)

Report

Re: Use formula to decide which SharePoint list to Get Items from

It works! I don't know why it didn't when I was trying it before, but thanks!!
Verified answer

ScottShearer 25,150 on at

Like (0)

Report

Re: Use formula to decide which SharePoint list to Get Items from

@uggliMuggli

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.