Unanswered

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.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
uggliMuggli 22 on at

Like (0)

Report

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

Was this reply helpful? Yes No