What can you do with Power Automate expressions in real life workflows?

[@mangeshmehendale3731]

You have a superb channel! Where were you hiding so long!??!

[@decaturdon]

Exactly what I needed to help me solve a problem I was having using loops. THANKS! I appreciate your posts and always look forward to what you present next!

[@powerappstw]

It's a really cool video, and thanks for all you've done.

[@mdhidayat5706]

Trying this out on 18-Oct-2021 26:22 Do until is now fixed and can select the drop down 😉

[@sundrapillay6668]

Thank you Alireza

[@sashawarchoon1989]

I have a question for you, Ali. Are you familiar with Nintex workflows? If yes then what’s your view on Power Automate vs Nintex?

[@sashawarchoon1989]

I’ve started to watch the video on iPad but just paused it because I want to give it a try on my laptop. Challenge accepted😁

[@AlirezaAliabadi]

That's the spirit. I love it.

[@sashawarchoon1989]

Ok. I'm surrendering. It's Friday night and I don't want to wait till tomorrow. I haven't finished my solution but it's pretty heavy one already so I guess it would become a monster if I finish it. I'm sure there is much nicer solution and I'm about to watch it ;) In regards to what I have so far: 1) I'm getting values from excel list (list rows action) 2) I have to mess with dates because I have "44123", etc returned instead of dates and I'm fixing this with AddDays function and Select action (creating new array with correct dates values) 3) Then using "Do Until" action I'm generating array of dates from beginning of this week for next two weeks. It looks like this: [ "02-08-2021", "03-08-2021", "04-08-2021", "05-08-2021", "06-08-2021", "07-08-2021", "08-08-2021", "09-08-2021", "10-08-2021", "11-08-2021", "12-08-2021", "13-08-2021", "14-08-2021", "15-08-2021" ] 4) Then I'm looping through this array and within each iteration I'm filtering values from array from step 2 (see above). Within the same loop if length of result is 0 I append certain json object to another array. If not - I'll append another json object to the same array. So that I end up with the following: [ { "Date": "02-08-2021", "Meetings": "" }, { "Date": "03-08-2021", "Meetings": "Subject 1" }, { "Date": "04-08-2021", "Meetings": "" }, { "Date": "05-08-2021", "Meetings": "Subject 2" }, { "Date": "06-08-2021", "Meetings": "" }, { "Date": "07-08-2021", "Meetings": "" }, { "Date": "08-08-2021", "Meetings": "" }, { "Date": "09-08-2021", "Meetings": "Subject 3 Subject 4 Subject 5" }, { "Date": "10-08-2021", "Meetings": "" }, { "Date": "11-08-2021", "Meetings": "Subject 6" }, { "Date": "12-08-2021", "Meetings": "Subject 7 Subject 8" }, { "Date": "13-08-2021", "Meetings": "Subject 9 Subject 10" }, { "Date": "14-08-2021", "Meetings": "" }, { "Date": "15-08-2021", "Meetings": "" } ] Probably I'll be able to finish that one but it will be a monster. So I'm stopping development and starting watching the video again.

[@sashawarchoon1989]

@@AlirezaAliabadi , by the way - couple of complaints: 1) there is no link to the file so I had to build it from scratch 2) In the beginning of video excel screenshot has subject 1, subject 2, etc but final outcome has meeting 1, meeting 2, etc So it's confusing what is conversion between subject and meeting ;)

[@AlirezaAliabadi]

@@sashawarchoon1989 You got it. Great!

[@AlirezaAliabadi]

@@sashawarchoon1989 The link to the file is in the video description (the second link). About the subject 1 and meeting 1, you are right. When I was creating the JSON file, I just typed in some dummy values in there without really looking into the Excel file. Sorry about it 🙂