Value functions - PowerQuery M | Microsoft Learn In the data an opportunity number (column A) will be listed several times; one row person assigned to helping on the opportunity. This also will return true if the value exists. What i want to do is enter a new column in the first table which does the following: If any row in custom column contains the value 'Outstanding' for Table_2[sample_id] = Table_1[sample_id] then display Outstanding, else display Done. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Mira_Ghaly* Example 1. Whether you are brand new to the world of process automation or you are a seasoned Power Apps veteran. David_MA timl Returns a record containing the inputs metadata. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile. AhmedSalih Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. Returns the value if it is compatible with the specified type. Expand any Client-ID columnCustomColumn = if [#"Client-ID"] is null then "No"else "Yes". LaurensM 565), Improving the copy in the close modal and post notices - 2023 edition, New blog post from our CEO Prashanth: Community is the future of AI. David_MA Sundeep_Malik* KRider Pstork1* What's the cheapest way to buy out a sibling's share of our parents house if I have no cash and want to pay less than the appraised value? Thank you! Hardesh15 Connect with Chris Huntingford: You can add a conditional column to your query by using a dialog box to create the formula. If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. subsguts rubin_boercwebb365DorrindaG1124GabibalabanManan-MalhotrajcfDanielWarrenBelzWaegemmaNandiniBhagya20GuidoPreiteDrrickrypmetsshan StretchFredrik* Another column (Column B) will indicate the name of each person and another (Column C) for the role of each assigned person. They are titled "Get Help with Microsoft Power Apps " and there you will find thousands of technical professionals with years of experience who are ready and eager to answer your questions.
