Hey guys, I'm having real problems with understanding if/switch/multiple if statements š
I'm trying to set up a label text so that depending on whether certain quoted words are in a field, it shows the relevant text. My If statement below has been taken but only shows the first one.
If("Analytical Chemistry" in Gallery2.Selected.LabsChosen,"Analytical Chemistry: "&Char(10)&Gallery2.Selected.'Ana-Fulfilment'&Char(10)&Char(10),
("Biochemistry" in Gallery2.Selected.LabsChosen),"Biochemistry: "&Char(10)&Gallery2.Selected.'Biochem-Fulfilment'&Char(10)&Char(10),
("Cell Biology" in Gallery2.Selected.LabsChosen),"Cell Biology: "&Char(10)&Gallery2.Selected.'CB-Fulfilment'&Char(10)&Char(10),
("Microbiology" in Gallery2.Selected.LabsChosen),"Microbiology: "&Char(10)&Gallery2.Selected.'Microb-Fulfilment'&Char(10)&Char(10),
("Molecular Biology" in Gallery2.Selected.LabsChosen),"Molecular Biology: "&Char(10)&Gallery2.Selected.'Molecb-Fulfilment'&Char(10)&Char(10),
("Preparative Chemistry" in Gallery2.Selected.LabsChosen),"Preparative Chemistry: "&Char(10)&Gallery2.Selected.'PrepChem-Fulfilment',
IsBlank(Gallery2.Selected.LabsChosen),"")
If("Analytical Chemistry" in Gallery2.Selected.LabsChosen,"Analytical Chemistry: "&Char(10)&Gallery2.Selected.'Ana-Fulfilment'&Char(10)&Char(10),
If("Biochemistry" in Gallery2.Selected.LabsChosen,"Biochemistry: "&Char(10)&Gallery2.Selected.'Biochem-Fulfilment'&Char(10)&Char(10),
If("Cell Biology" in Gallery2.Selected.LabsChosen,"Cell Biology: "&Char(10)&Gallery2.Selected.'CB-Fulfilment'&Char(10)&Char(10),
If("Microbiology" in Gallery2.Selected.LabsChosen,"Microbiology: "&Char(10)&Gallery2.Selected.'Microb-Fulfilment'&Char(10)&Char(10),
If("Molecular Biology" in Gallery2.Selected.LabsChosen,"Molecular Biology: "&Char(10)&Gallery2.Selected.'Molecb-Fulfilment'&Char(10)&Char(10),
If("Preparative Chemistry" in Gallery2.Selected.LabsChosen,"Preparative Chemistry: "&Char(10)&Gallery2.Selected.'PrepChem-Fulfilment',
If(IsBlank(Gallery2.Selected.LabsChosen),"")))))))
Hey Zmansuri, it takes that thank you but again only shows the first one š¤ If two or more of those statements re in the field, I want it to show all of the relevant information, e.g. if Analytical Chemistry & Microbiology are in the field, show their true statement. Does that make sense? Is that possible?
it makes perfect sense. But, for some reason i can't seem to think of a way to do that. Straight forward approach would be to write all 36 combinations. But i am sure there must be good way to do it.
@WarrenBelz and @RandyHayes are good at this sort of things. Maybe they can help you.
Oh no this is what I was thinking, sadly it'd be more than 36 combinations as the user can select one to all six in any combination ššš¬
Hi @Lauren_ ,
If you want to display all the selected items, try this
With(
{
wChosen:Gallery2.Selected,
wItems:Gallery2.SelectedItems,
wBreak:Char(10) & Char(10)
},
If(
"Analytical Chemistry" in wItems,
"Analytical Chemistry" & wChosen.'Ana-Fulfilment' & wBreak
) &&
If(
"Biochemistry" in wItems,
"Biochemistry" & wChosen.'Biochem-Fulfilment' & wBreak
) &&
If(
"Cell Biology" in wItems,
"Cell Biology" & wChosen.'CB-Fulfilment' & wBreak
) &&
If(
"Microbiology" in wItems,
"Microbiology" & wChosen.'Microb-Fulfilment' & wBreak
) &&
If(
"Molecular Biology" in wItems,
"Molecular Biology" & wChosen.LabsChosen & wBreak
) &&
If(
"Preparative Chemistry" in wItems,
"Preparative Chemistry" & wChosen.PrepChem-Fulfilment & wBreak
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi Warren!
Thanks for replying, it's given me an error message, "cannot use record values in this context".
@Lauren_ ,
Problem with free-typing - I have had another go with corrected post. Note what you are trying to do is not straight-forward and I am not entirely confident this will work (I have a plan B if not)
Hey Warren, it was a good effort for free typing, much better than what I could do!!
Sadly it's still kicking off over witems with the same error message. Could we try plan B?
@Lauren_ ,
wItems should not contain an error - it is simply referencing the combo SelectedItems. I was more concerned with wChosen. Note the With() statement is only to avoid repetitive typing. The problem with the reference to the other fields is that you have chosen more than one item, meaning the reference is not valid - so
With(
{
wItems:Gallery2.SelectedItems,
wBreak:Char(10) & Char(10)
},
If(
"Analytical Chemistry" in wItems,
"Analytical Chemistry" &
LookUp(
YourListName,
LabsChosen = "Analytical Chemistry"
).'Ana-Fulfilment' & wBreak
) &&
If(
"Biochemistry" in wItems,
"Biochemistry" &
LookUp(
YourListName,
LabsChosen = "Biochemistry"
).'Biochem-Fulfilment' & wBreak
) &&
If(
"Cell Biology" in wItems,
"Cell Biology" &
LookUp(
YourListName,
LabsChosen = "Cell Biology"
).'CB-Fulfilment' & wBreak
) &&
If(
"Microbiology" in wItems,
"Microbiology" &
LookUp(
YourListName,
LabsChosen = "Microbiology"
).'Microb-Fulfilment' & wBreak
) &&
If(
"Molecular Biology" in wItems,
"Molecular Biology" &
LookUp(
YourListName,
LabsChosen = "Molecular Biology"
).'Molecb-Fulfilment' & wBreak
) &&
If(
"Preparative Chemistry" in wItems,
LookUp(
YourListName,
LabsChosen = "Preparative Chemistry"
).PrepChem-Fulfilment & wBreak
)
)
Please study this syntax before coming back - it is guidance based on the values you posted. If there is an issue with wItems, change it to Gallery2.SelectedItems.LabsChosen.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Episode Fifteen of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft MVP Lewis Baybutt aka Low Code Lewis, alongside the latest news and community blogs.Ā Ā Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.Ā Ā Ā Action requested:Ā Feel free to provide feedback on how we can make our community more inclusive and diverse.Ā This episode premiers live on our YouTube at 12pm PST on Thursday 1st June 2023.Ā Video series available at Power Platform Community YouTube channel.Ā Ā Upcoming events:Ā European Power Platform conference ā Jun. 20-22nd - DublinĀ Microsoft Power Platform Conference ā Oct. 3-5th - Las VegasĀ Join our Communities:Ā Power Apps CommunityĀ Power Automate CommunityĀ Power Virtual Agents CommunityĀ Power Pages CommunityĀ If youād like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.Ā Ā
Welcome to ourĀ May 2023 Community Newsletter, where we'll be highlighting the latest news, releases, upcoming events, and the great work of our members inside the Biz Apps communities. If you're new to this LinkedIn group, be sure to subscribe here in the News & Announcements to stay up to date with the latest news from our ever-growing membership network whoĀ "changed the way they thought about code". Ā Ā Ā LATEST NEWS "Mondays at Microsoft"Ā LIVE on LinkedIn - 8am PST - Monday 15th MayĀ - Grab your Monday morning coffee and come join Principal Program ManagersĀ Heather CookĀ andĀ Karuana GatimuĀ for the premiere episode ofĀ "Mondays at Microsoft"! This show will kick off the launch of the newĀ Microsoft CommunityĀ LinkedIn channel and cover a whole host of hot topics from across theĀ #PowerPlatform,Ā #ModernWork,Ā #Dynamics365,Ā #AI, and everything in-between. JustĀ click the image belowĀ to register and come join the team LIVE on Monday 15th May 2023 at 8am PST. Hope to see you there! Ā Ā Executive Keynote | Microsoft Customer Success Day CVP for Business Applications & Platform,Ā Charles Lamanna, shares the latestĀ #BusinessApplicationsĀ product enhancements and updates to help customers achieve their business outcomes. Ā Ā S01E13 Power Platform Connections - 12pm PST - Thursday 11th May Episode Thirteen of Power Platform Connections seesĀ Hugo BernierĀ take a deep dive into the mind of co-hostĀ David Warner II, alongside the reviewing the great work ofĀ Dennis Goedegebuure,Ā Keith Atherton,Ā Michael Megel,Ā Cat Schneider, and more. Click below to subscribe and get notified, with David and HugoĀ LIVEĀ in the YouTube chat from 12pm PST. And use the hashtagĀ #PowerPlatformConnectsĀ on social media for a chance to have your work featured on the show. Ā Ā UPCOMING EVENTS Ā European Power Platform Conference - early bird ticket sale ends! TheĀ European Power Platform ConferenceĀ early bird ticket sale ends on Friday 12th May 2023! #EPPC23Ā brings together the MicrosoftĀ Power PlatformĀ Communities for three days of unrivaled days in-person learning, connections and inspiration, featuring three inspirational keynotes, six expert full-day tutorials, and over eighty-five specialist sessions, with guest speakers includingĀ April Dunnam,Ā Dona Sarkar,Ā Ilya Fainberg,Ā Janet Robb,Ā Daniel Laskewitz,Ā Rui Santos,Ā Jens Christian SchrĆøder,Ā Marco Rocca, and many more. Deep dive into the latest product advancements as you hear from some of the brightest minds in theĀ #PowerAppsĀ space. Click here to book your ticket today and save!Ā Ā Ā DynamicMinds Conference - Slovenia - 22-24th May 2023 It's not long now until theĀ DynamicsMindsĀ Conference, which takes place inĀ Slovenia on 22nd - 24th May, 2023Ā - where brilliant minds meet, mingle & share! This greatĀ Power PlatformĀ andĀ Dynamics 365Ā Conference features a whole host of amazing speakers, including the likes ofĀ Georg Glantschnig,Ā Dona Sarkar,Ā Tommy Skaue,Ā Monique Hayward,Ā Aleksandar Totovic,Ā Rachel Profitt,Ā AurĆ©lien CLERE,Ā Ana InĆ©s Urrutia de Souza,Ā Luca Pellegrini,Ā Bostjan Golob,Ā Shannon Mullins,Ā Elena Baeva,Ā Ivan Ficko,Ā Guro Faller,Ā Vivian Voss,Ā Andrew Bibby,Ā Tricia Sinclair,Ā Roger Gilchrist,Ā Sara Lagerquist,Ā Steve Mordue, and many more. Click here: DynamicsMinds Conference for more info on what is sure an amazing community conference covering all aspects ofĀ Power PlatformĀ and beyond.Ā Ā Days of Knowledge Conference in Denmark - 1-2nd June 2023 Check out 'Days of Knowledge', aĀ Directions 4 PartnersĀ conference onĀ 1st-2nd June in Odense, Denmark, which focuses on educating employees, sharing knowledge and upgrading Business Central professionals. This fantastic two-day conference offers a combination of training sessions and workshops - all with Business Central and related products as the main topic. There's a great list of industry experts sharing their knowledge, includingĀ Iona V.,Ā Bert Verbeek,Ā Liza Juhlin,Ā Douglas RomĆ£o,Ā Carolina Edvinsson,Ā Kim Dalsgaard Christensen,Ā Inga Sartauskaite,Ā Peik Bech-Andersen,Ā Shannon Mullins,Ā James Crowter,Ā Mona Borksted Nielsen,Ā Renato Fajdiga,Ā Vivian Voss,Ā Sven Noomen,Ā Paulien Buskens,Ā Andri MĆ”r Helgason,Ā Kayleen Hannigan,Ā Freddy Kristiansen,Ā Signe Agerbo,Ā Luc van Vugt, and many more. If you want to meet industry experts, gain an advantage in the SMB-market, and acquire new knowledge about Microsoft Dynamics Business Central, click hereĀ Days of Knowledge Conference in Denmark to buy your ticket today! Ā COMMUNITY HIGHLIGHTS Check out our top Super and Community Users reaching new levels!Ā These hardworking members are posting, answering questions, kudos, and providing top solutions in their communities. Ā Power Apps:Ā Super Users:Ā @WarrenBelz,Ā @LaurensMĀ Ā @BCBuizerĀ Community Users:Ā Ā @Amik@Ā @mmollet,Ā @Cr1tĀ Ā Power Automate:Ā Super Users:Ā @ExpiscornovusĀ ,Ā @grantjenkins,Ā @abmĀ Community Users:Ā @Nived_Nambiar,Ā @ManishSolankiĀ Ā Power Virtual Agents:Ā Super Users:Ā @Pstork1,Ā @ExpiscornovusĀ Community Users:Ā @JoseA,Ā @fernandosilva,Ā @angerfire1213Ā Ā Power Pages: Super Users: @ragavanrajanĀ Community Users:Ā @Fubar,Ā @Madhankumar_L,@gospaĀ LATEST COMMUNITY BLOG ARTICLESĀ Power Apps Community BlogĀ Power Automate Community BlogĀ Power Virtual Agents Community BlogĀ Power Pages Community BlogĀ Check out 'Using the Community' for more helpful tips and information:Ā Power AppsĀ ,Ā Power Automate,Ā Power Virtual Agents,Ā Power PagesĀ
We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida. Ā Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more. Ā Register today: https://www.powerplatformconf.com/Ā Ā
We are excited to share the āPower Platform Communities Front Doorā experience with you! Ā Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well. Ā Ā Ā Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities. Ā Ā Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.Ā Ā Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.
Welcome! Congratulations on joining the Microsoft Power Apps community! You are now a part of a vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun! Now that you are a member, you can enjoy the following resources: Ā The Microsoft Power Apps Community ForumsĀ If you are looking for support with any part of Microsoft Power Apps, our forums are the place to go. 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. You now have the ability to post, reply and give "kudos" on the Power Apps community forums! Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered! Ā Microsoft Power Apps IdeasDo you have an idea to improve the Microsoft Power Apps experience, or a feature request for future product updates? Then the "Power Apps Ideas" section is where you can contribute your suggestions and vote for ideas posted by other community members. We constantly look to the most voted Ideas when planning updates, so your suggestions and votes will always make a difference. Ā Community Blog & NewsOver the years, more than 600 Power Apps Community Blog Articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on building Power Apps. On the Power Apps Community Blog, read the latest Power Apps related posts from our community blog authors around the world. Let us know if you would like to become an author and contribute your own writing ā everything Power Apps related is welcome! Ā Power Apps Samples, Learning and Videos GalleriesOur galleries have a little bit of everything to do with Power Apps. Our galleries are great for finding inspiration for your next app or component. You can view, comment and kudo the apps and component gallery to see what others have created! Or share Power Apps that you have created with other Power Apps enthusiasts. Along with all of that awesome content, there is the Power Apps Community Video & MBAS gallery where you can watch tutorials and demos by Microsoft staff, partners, and community gurus in our community video gallery. Ā Again, we are excited to welcome you to the Microsoft Power Apps community family! Whether you are brand new to the world of process automation or you are a seasoned Power Apps veteran. Our goal is to shape the community to be your āgo toā for support, networking, education, inspiration and encouragement as we enjoy this adventure together! Ā Let us know in theĀ Community FeedbackĀ if you have any questions or comments about your community experience.To learn more about the community and your account be sure to visit ourĀ Community Support AreaĀ boards to learn more! We look forward to seeing you in the Power Apps Community!The Power Apps Team