Any recommanded tutorial of learn use expression?
I want to learn how to take value from excel and check whether the value meet my condition.
value must be equal 9 character.
value must start from 'ABCD' with capital letter
5th character must be capital letter
and remain value must be number integer.
Hi @kahyong , thank you for posting in the Flow Community
Regards tutorials, yes, there are several but as a beginner, here is a video from @faustocapellanj that I would strongly recommend - https://www.youtube.com/watch?v=XMC6nOv83FY
I use the below guide every day and I would advise reading trhough every function (if you have time) then using "ctrl + f" to look for "if(" "concat(" "substring(" etc then applying the syntaxt to suit.
Functions reference for Workflow Definition Language in Azure Logic Apps and Microsoft Flow
I think on this one, I wont offer a solution (just yet) to what you ask as I see you are keen to learn so what I'd ask is that you go and give it a go and if and when you get stuck, please post back with some images of your Flow and either I or another from the community will assist.
Bonus: this may help - https://flow-joe.github.io/microsoft/microsoftpowerplatform/flow/infographic/2019/04/19/VisualExplanationOfFlowLogicalExpressions.html
If you have found my post helpful, please mark thumbs up.
Any other questions, just ask.
Thanks, Alan
WarrenBelz
146,587
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional