![]() ![]() Use Power Automate to Send an Email Reminder 24 Hours Before an Event – Lindsay T. ![]() Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.Ġ:00 Cold Open00:12 Show Intro00:45 Hugo Bernier Interview23:12 Blogs & Articles31:48 Outro & BloopersĬheck out the blogs and articles featured in this week’s episode:ġ. The above conditional is accepted by PAD but when I run it it doesn't seem to be working as intended as it is not realizing that the cell value is actually Payer.Įpisode Eight of Power Platform Connections sees David Warner have an in-depth conversation with co-host and Microsoft Community Program Manager Hugo Bernier, alongside the latest news, product reviews, and community blogs. With the above conditional I get an Invalid Value message, you might have noticed I removed the double equal signs, I have tried with the double equal signs and it also says invalid value in this way.įirst Operand: %ExcelData = 'payer'% || %ExcelData = 'doc'% I have already tried to express it in different ways but I haven't been able to achieve this logic, this is what I have tried so far:įirst Operand: %ExcelData = "Payer" || ExcelData = "Doc"% In my case I am reading a single cell value from excel which is stored into the variable %ExcelData%, I would like to use an If conditional to review if the variable's value is either "Payer" or "Doc" I need it to do certain actions, but if it is blank I need it to go into a different set of actions. ![]() I have tried to express it in this way in Power Automate Desktop and it is not working. ![]() The OR "||" operator can be used in a similar wayįirst Operand: %TextVar_1 = "ABC" || TextVar_2 = "DEF"% The AND "&" operator can be used inside an "If" condition using the following formatįirst Operand: %TextVar_1 = "ABC" & TextVar_2 = "DEF"% I would like to know how to include the logical AND/OR operators in conditionals, previously on WinAutomation this could be achieved like this: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |