I have a text input that must contain both numbers and letters in order for the user to proceed. Power Query Function that Returns Multiple Values - RADACAD As we learned in the … Pivot Text Values in Power Query - Explained - Gorilla BI to use Power Query you need Excel with Power Query (I don't know which version you have right now, away from home)with XL2016 : Data tab - New Query - From Other Sources - Blank Query then open Advanced Editor and replace all there with code copied from the post Posted on 17 febrero, 2022; By . PowerQuery (M) Text.Contains function with OR logical operator Convert logic (if I understood it correctly) to Power Query that's with some coding. I want to determine if certain selections have been made and hide additional edit cards … Now we have to fix this so it is a conditional join. power query if text contains multiple values power query if text contains multiple values. Solved: Checking if numbers and letters are in a text inpu... - Power ... power query if text contains multiple values How do I check for this input … From these three functions, the last two can check if a list contains either one or all of multiple values. You could use the OR function. List.Contains - PowerQuery M | Microsoft Docs