Power Automate Compose, Join, Select, Filter, Create tables, Parse JSON | Data Operations in flow

[@tenisviejos]

Hey Reza, it's been a while since I last saw a video from you. I love to see the huge improvement in the way you show us the actions, results and effects. The "flow" of your videos (no pun intended) is better than ever! Unfortunately, my current job does not allow me to leverage powerAutomate, but it's always good to keep updated on the best practices. Keep it up!

[@RezaDorrani]

Thanks so much. I have worked a lot on the flow of my videos :)

[@tomoleusz]

Dear Reza, I can't express my gratitude for you work! I run into issues with filtering array and couldn't find any solution until I found your video. One section in this video was more helpful than Power BI forum, Google and Char GPT combined. Thank you so much!

[@RezaDorrani]

You’re most welcome

[@gavinobrien5361]

@RezaDorrani: I've watched many of your videos over the last year and my confidence and understanding of programming is getting better. I am SO grateful for your support -- you provide incredible value to all of us!! 😊

[@RezaDorrani]

Awesome! So happy to hear that. I will keep trying my best.

[@Icy-uh8pc]

Reza, I think you are my hero. It will works well for me to finish my flow to catch data from sharepoint list for approval. ❤

[@RezaDorrani]

Great to hear

[@ricardobunge5957]

Outstanding! Was not aware of Join, and the last bit, with the multi-select text on manual trigger is great! Lots of possibilities. Thanks again!

[@RezaDorrani]

Glad you enjoyed it!

[@RanjitSingh-xk9sb]

Very helpful. I usually rename data operations like this "Compose - Name" this helps me identify the type of action used in the future. Especially when more than one data operations are used.

[@RezaDorrani]

That is a nice tip 👍

[@ExcelFormulasHacks]

Very useful Came here after enrolling a course on udemy. Wanted to learn more about data operations which was not covered in that course

[@RezaDorrani]

Thanks for watching

[@kman40469]

Reza, thank you for explaining this in detail. Even though the video is older it still provides that piece that i was missing with the data operations. Thanks!

[@ulovepresent]

This is really great video to understand data operation in power automate. Nice lecture, Reza. It's from Korea.

[@RezaDorrani]

Thank you very much!

[@antonufy]

Amazing tutorial with examples. You make us shine in our office.. Thank you for your time.

[@RezaDorrani]

Happy to hear that!

[@ManojThiruppathi]

Thanks a Lot Reza..I'm a Big fan of your Power Automate sessions...

[@RezaDorrani]

Thanks Manoj

[@robofski]

You’re my ultimate dinner party guest, I learn something from every one of your videos. Never mind Einstein or Churchill, give me Reza any day!!!! Awesome work as always.

[@RezaDorrani]

Wow, thank you so much!

[@AnnikaSchulz-t2o]

Thank you so much, Reza. A great overview of all the possibilities. I was looking for something specific and learned so much more! 🥰 I just might need to rework some of my flows now🤣

[@RezaDorrani]

Glad it was helpful! I do pack a lot of info in my videos.

[@ExcelFormulasHacks]

Superb sir! Data operations is something which I was looking for on KZbin. Very helpful video

[@RezaDorrani]

Glad to hear that

[@johnshoowa8760]

You are amazing Reza. Thanks for a clear, precise and informative video as always. Your use cases always relate to real-world scenarios. Thank you for always being my superhero, I am your work's no1 fan.

[@RezaDorrani]

You’re most welcome and thanks so much for watching and learning from my videos

Terrific tips as always. Regarding select data operation you can Add new properties to your array items with expression: addProperty(, '', ) so you can add for e.g. a 'url' property and a value based on the name and some string manipulation. #powerautomateexpressionsFTW

[@RezaDorrani]

Thanks for sharing your tip

[@Filmy_recommends]

Your efforts for making this video are highly commendable. Great content.

[@RezaDorrani]

Thank you very much!

[@oluwatobiyusuf]

Thank you Reza. One of your use case is the solution I have been looking for. Thank you as always

[@RezaDorrani]

Happy to hear that! Thank You for watching.

[@hardyy6238]

Hello Reza, I have watched many of your videos which helped me to do more and more with power automate. This video is Great which helped me understand each data operations. Could you please create a sample video of how I can extract information from a large email body for creating a sharepoint list. Thank you! ❤

[@RezaDorrani]

You are most welcome and thanks so much for watching and liking the videos. My rule for creating videos is set - Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

[@BraulioPatriota]

Excellent video! It has helped me several times. Cheers from Brazil : )

[@RezaDorrani]

Great to hear!

[@AmmarRamadan]

Microsoft is lucky to have you there Reza. waiting for a big change on the power platform specially on Powerapps behavior in the development mode.

[@RezaDorrani]

Riza cannot make changes, but maybe Reza can :)

[@AmmarRamadan]

@@RezaDorrani 😜😅

[@clay4gli]

Wow - amazing video. So many possibilities. Thank you!

[@RezaDorrani]

Thanks for watching Clay

[@anatolijkovalenko9696]

Hello! I really enjoyed your tutorials on Power apps. Maybe you can upload a video on how to create a power apps visitor registration form where you can see the time, when they arrived, when they left, who came and to whom. How to enable search and edit data. Thank you very much.

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@tranbangviet]

Thank you very much for the lessons and examples

[@RezaDorrani]

Glad you like them!

[@renatofagundes5560]

Excelente como sempre! Obrigado, paçoca.

[@RezaDorrani]

Most welcome

[@televisi]

Thanks for such a clear instruction!

[@RezaDorrani]

Most welcome

[@swethakandukuri6831]

Great to see your new video Reza Dorrani. Please make a video on- Creating auto slideshow(dissolve or slide) where images stored in a dataverse table are retrieved. (Images in table are Saved using binary format). unable to find this criteria anywhere.

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@shaikhfirdos2723]

Extremely useful video . Thanks Reza..

[@RezaDorrani]

My pleasure!

[@gintomino4136]

awesome this is pretty straightforward! thanks!

[@RezaDorrani]

You're most welcome!

[@kylekintner9366]

Thanks for all the great content. Question, How do you escape special characters like & in power automate expressions?

[@RezaDorrani]

Most welcome. I have shown that as part of some of flow videos (do not remember which ones) There are many examples of this on forums - powerusers.microsoft.com

[@elrevesyelderecho]

9:08 Thanks! It works! I can get what I was expecting

[@RezaDorrani]

👍

[@1999prasad]

Great Stuff! Can we have detailed videos of how you built the examples shown by you at the end. Please!

[@RezaDorrani]

They already may be videos on them. Check my flow playlist - kzbin.info/aero/PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0

[@khaledalaqqad1934]

Very excellent explanation Thanks a lot

[@RezaDorrani]

Most welcome

[@Heliumcool1]

Very helpful, thank you.

[@RezaDorrani]

Glad it was helpful!

[@adityadeshmukh3150]

Another great video with useful Ideas @Reza. Big fan..!! 🙂👍

[@RezaDorrani]

Thanks a lot 😊

[@petaratanasov4153]

Amazing content as always! Thanks, Reza!

[@RezaDorrani]

Glad you enjoy it!

[@tonya3308]

This is a great video - however, when we collect data in the Apply to each, and then join them in the email it would be helpful to see the expression for the join. Thanks!

[@RezaDorrani]

Expression is join. Check syntax for expression in documentation.

[@DanielWeikert]

Great video Reza, is there a way to extract elements from an array of objects without using the for each loop? If so have you covered that in a video? br

[@RezaDorrani]

I may have shown that as part of my usage of expressions in flow videos but I do not remember which ones.

[@rikkers258]

Just what I needed, grouped HTML, can I ask what’s the Clean html at 23:08 just before the append to array. Thanks

[@RezaDorrani]

That was shown in a different video hence did not cover it again kzbin.info/www/bejne/jJ-6mGB7pN1mbbM

[@biju2001]

Thank you for this video and all the wonderful work you do. I am looking for a way to update my approvers list based on the response data from a wait for an approval action. The select data operation has all the users, their email id, and approval status. How can I update the approvers SharePoint list. Please note that the flow is configured into a different list.

[@RezaDorrani]

Check approvals playlist on my channel. I may have covered this in one of the videos.

[@DroneEyes]

Great explanation Reza!

[@RezaDorrani]

Thanks

[@inglesdicasdesafios9922]

Thank you so much I’m making soft so fast now back then I was confused, thanks

[@RezaDorrani]

You’re welcome

[@raj7sam]

Very nice video and tricks 👍🏼

[@RezaDorrani]

Glad you liked it!

[@dougydoe]

I always look forward to your videos because I know I'll learn something new even if I have a fairly good idea about the feature/topic you're going to discuss. As usual I wasn't disappointed. You do an excellent job at sharing so much however brief the video is. Thank You. One quick question, What will the convertFromUtc equivalent be for those of us living in the UK? I used "British Summer Time" but I kept getting errors as I worked alongside..

[@RezaDorrani]

Check documentation for convertfromutc. It has all the time zone names.

[@alzaimoor79]

Thanks, very useful, well explanation

[@RezaDorrani]

Thank You

[@smithp3302]

Hello @Reza, thanks for putting this video together for al the functions. I am running into a scenario where I need to send a notification to multiple users that may have 1 or more pending tasks. I am able to query the data however having issues with combining Parse JSON and Filter function since the column in our data set has user (which has name, email, dept, etc.) instead of just their email. Thoughts on how to address this scenario?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@tlfneversummer]

very helpful, thanks a lot

[@RezaDorrani]

Glad it helped!

[@federico3784]

Hello Reza, I was wondering if you have or plan to create a video about 'group by' and 'sum' in Power Automate? Something similar to a pivot table in Excel or GROUP BY and SUM in SQL. I feel like this must be a simple task in Power Automate, but I'm missing how to handle it. Anyway, thanks for this video and all your work; I'm a fan of your channel and have learned a lot of good stuff here.

[@RezaDorrani]

Hey thanks for watching the videos and following the channel. I do not have any video plans currently for group by or sum in power automate. I have 10-12 video ideas lined up.

[@abdulbasith8129]

Hi Reza, thanks alot you saved me a lot of time through this video. And how to make the csv table with style?

[@RezaDorrani]

You are welcome! Table style -> kzbin.info/www/bejne/jJ-6mGB7pN1mbbM

[@StephanOnisick]

Awesome Functionality!

[@RezaDorrani]

Thanks

[@chingpernchan5981]

Thanks for the amazing tutorials. Can you make a tutorial on datepicker pls?

[@RezaDorrani]

Datepicker in flows?

[@chingpernchan5981]

@@RezaDorrani yes sir. Let's say I had keyed in a specific date in excel, and I want the mouse to click on the datepicker according to the date in my excel sheet. What should I do? Thanks a million

[@RezaDorrani]

@@chingpernchan5981 I have no clue about this one. I will recommend posting your query on forums at powerusers.microsoft.com

[@galdancio]

How did you create the document view at 23:58, it looks awesome!

[@RezaDorrani]

Check kzbin.info/www/bejne/mWXEZJKMiqmqoZI and specially the description of video which includes links for JSON formatting.

[@galdancio]

@@RezaDorrani Thanks so much I appreciate it.

[@mohamedfouad7958]

thanks a lot for your efforts

[@RezaDorrani]

Most welcome

[@Rational1234]

Hi ,great work . I have 2 questions 1. How to handle race conditions in power automate? Ex : a flow,say like running after a button click in Power app . Two users click button at exact same time , flow getting data from sharepoint list at exact same time .. how to handle this ? 2. How to stop power apps user from directly editing data from datasource like SharePoint list . If they have access they directly go to sharepoint site at modify the list . I want users to communicate with list only from power app . Thank you in advance.

[@RezaDorrani]

1 - Power Apps is user specific. Im not sure if there is a way to avoid multiple users calling flow at same time. 2 - Power Apps does not impersonate permissions. User must have access in order to perform the actions.

[@hbird8071]

Hi Reza. You've won a new subscriber here. Keep up the good work. The only thing that confused me a bit in your 2nd last example is the mechanism used by the 'apply to each' to filter the SharePoint list. Does it pull the whole list and then filter somehow in the select action (which means I misunderstood the select action) or is the 'get list' action implicitly filtering the list from each status. If the latter how does it know which data field to filter in the SharePoint list? i.e. When you say query you mean filter query in the advanced option? Not so obvious if so because it is not expanded in your video like other parts... Loved the video, especially the use cases with diverse examples focusing on the data operation theme. Thank you.

[@RezaDorrani]

Thanks for the sub! Get Items SharePoint - one should always use filter query (odata) - I have done 2 videos on it. I meant filter query :)

[@nathanielmasih2285]

Hi Reza - Great Video, very informative. I was wondering if you would be able to post your Style compose here by any chance?

[@RezaDorrani]

ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

[@kingquadri1850]

Awesome info

[@RezaDorrani]

Thanks

[@efficiency365]

Excellent.

[@RezaDorrani]

Thank you! Cheers!

[@galdancio]

Great video as usual! Any chance you could add the JSON files sometimes, following along is a great learning method

[@RezaDorrani]

Add JSON files to?

[@galdancio]

@@RezaDorrani In a notepad underneath, I just typed them out but if it's not too much hassle that would be great :)

[@RezaDorrani]

@@galdancio Sorry but Im confused as to what is the ask. Can you point to a time in video where I showcase something you need?

[@galdancio]

@@RezaDorrani sorry I wasn't very clear, the content of the array shown at 4:34 minutes would be handy if you following along.

[@RezaDorrani]

@@galdancio Its just sample data I prepared. I build 10-20 flows a week and keep reusing. May not even have this anymore and would need to search. You can pause and see the data and try and replicate 2 or 3 items of the array.

[@jaimeangulo3449]

Reza, What video or tutorial can I make the gallery that you have implemented in power app? 21:44 min

[@RezaDorrani]

That video is coming soon ...

[@nitinchamroo5748]

Hi Reza, your video is super helpful for all office 365. I am trying to sum up a row when a new rating is submitted using PowerApps, but I am not sure which action to use. Any advice?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@manouchehr777]

Thank you for your interesting tutorial. Is it possible to put the username of the user in Windows in a variable?

[@RezaDorrani]

Windows? Not sure if thats an option.

[@arvin6606]

Hi Reza, i'm new here to your channel. I'm now an university student doing internship in a company. I was told to use Office app like Power Automate, Power Apps, SharePoint, etc. which i never used during my time studying. Can you explain to me how to use Power Automate to populate a fillable PDF from MS Form? This is the flow i was thinking: MS Form > populate fillable PDF > flatten PDF > Send email I'm now stuck at filling checkbox (or radio button), multiple choice checkbox, image, attachment, and dropdown. Thanks in advance. Edit: what i mean by fillable PDF is it was an existing PDF which i already add text area, checkbox, etc.

[@RezaDorrani]

I do not have a video reference on your scenario and would have to try it out to provide guidance. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@arvin6606]

@@RezaDorrani I've been searching about this in the internet and forums, but i can't find anything about making checkbox or multiple choice checkbox filled in PDF from MS Forms input. Most of them are just talking about moving MS Forms text input to fillable PDF. It would be a great help if you're able to make it because you'll be the first one to do it.

[@RezaDorrani]

@@arvin6606 I make videos when I receive multiple requests on a topic. I will need a lot more folks requesting this. I have video ideas with over 20 requests that are in my backlog.

[@Argentinian]

Can I only set one condition for evaluation in the 'filter array'? What if I want to filter by two columns? Do I need to create another filter array?

[@RezaDorrani]

You can write expressions there and combine with ANDs & ORs

[@hamytube]

Hello Reza, What is the difference between "Start time" and "At these hours", "At these minutes" in Recurrence actions? Define hours and minutes in both places?

[@RezaDorrani]

learn.microsoft.com/en-us/power-automate/run-scheduled-tasks

[@florindascalu207]

Hello Reza, thank you for all these videos, they are very inspiring. I have a question and i think you can help me: have you made any video with multiple contract approvals flow where every approval can download the contract submitted and then make track changes and uploads then into the approval email his variat of contract with his comments? So my problem is related to be able any approval to attach files (Word, Excel.. ), is this possibile? Thank you!!

[@RezaDorrani]

I do not have a video on this scenario. Possible - I would say Yes, but something to investigate on. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@florindascalu207]

Thank you Reza for your repply! I think this scenario deserves your imput! I will check also în the direction you mentioned! BR

[@RezaDorrani]

@@florindascalu207 I make videos or add them to my backlog when many people request a topic. Very few have asked for this scenario.

[@kabax5]

Will the HTML Table be able to include all of the choices for a multi-select choice column from a List?

[@RezaDorrani]

Yes but it would be in JSON array format. You could use join expression to convert it into a string with a delimiter.

[@okidipekimbambo]

Suggestion: Could You create a tutorial on getting data from Excel files without Tables? I heard it should be possible using Office Scripts.

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@shaktipattanayak7065]

Hii reza Which styling attributes you are using ??

[@RezaDorrani]

I think I showed those in a different video May be this one kzbin.info/www/bejne/jJ-6mGB7pN1mbbMsi=BK7EV6yH2D5CvkMs

[@shinshae7882]

Hello Reza, Is there is any way to get only property names of a json array? Array of propert names

[@RezaDorrani]

I haven't tried that so not sure

[@DUVEDITZ]

my gms/softex softs terrible and way different then urs what do i do

[@RezaDorrani]

?

[@paolovr1970]

🙏🙏Reza thanks, I've power app that call a flow passing a one table contains a header and details data on all the row. I've a JSON to post by API but I need to create a JSON file that contains nested one header and multiple rows details, how I can create a JSON file without the header and inserted the row details for each rows details? Do you have some example? 🙏🙏🙏 Thanks in advance. Paolo Italy

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@McIlravyInc]

For grouping, is there a way to further filter the get items based on another column? I have a list of tasks, with column of assigned to and another column (multi person) for backups. I want to send email to each user showing past due tasks, with one table where they are assigned (have this working) and another table of items they are backup for that are past due. Is there a way to do that without a second get items action? Thanks!

[@RezaDorrani]

Not sure if that is possible without a second get items action. This would be something I would have to try to know its feasibility. I would recommend checking or posting your query on forums in case someone has done something similar powerapps.microsoft.com/en-us/

[@pasupuletiramyabhargavi8268]

Hi Reza, I have a query about the power Automate cloud flow. I am trying to execute a stored procedure (Procedure to insert a record with details and which generates autogenerated primary key id in the table). I wanted the autogenerated id to get fetched to Power Automate cloud flow for further steps of the process. Can you please tell me how to retrieve the autogenerated id to access in power Automate cloud flow?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@gauthulachanna]

very nice, Reza. I have a Question for you- If I want to send the data from one application to another application automatically when ever a new record is created using the power automate. can you suggest any?

[@RezaDorrani]

Trigger flow when a new record in created in app 1, and then within the flow, create an item in app 2

[@gauthulachanna]

@@RezaDorrani do you have any blog or any reference, to get a clear idea

[@RezaDorrani]

@@gauthulachanna I do not have a specific video reference on this scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@gauthulachanna]

@@RezaDorrani thank you

[@SkyLee91]

Hi Reza, how you build the Document Review at 23:54 and Asset Details at 23:47? It is helpful for my company flow.

[@RezaDorrani]

All of those videos are on my channel. Check my SharePoint and Approvals playlists.

[@ThreeWhiteSoldiers-jr2sy]

Dear @Reza, can you please help to get the style you added inside the create HTML Table before PDF generation please?

[@RezaDorrani]

Check description of kzbin.info/www/bejne/jJ-6mGB7pN1mbbMsi=rczkQj8okKRCl25h for reference link

[@ThreeWhiteSoldiers-jr2sy]

@@RezaDorrani Thanks a lot

[@fsfasable]

Hello @RezaDorrani How can we filter array of arrays? Scenario 1 - Remove User1 Input: { "approvers":[["user1","user2"],["user3"],["user4"],["user5","user6"]] } output: { "approvers":[["user2"],["user3"],["user4"],["user5","user6"]] } Scenario 2 _ Remove User2 Input: { "approvers":[["user2"],["user3"],["user4"],["user5","user6"]] } output: { "approvers":[["user3"],["user4"],["user5","user6"]] }

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@wcstroud]

I'm trying to run a script and create separate documents based on selected rows in an excel table. When I only select 1 or 2 rows at a time it works consistently, but if when doing larger groups (4+) it seems to skip running the script for some files. it creates the file from the template, but then doesn't populate it. However, its inconsistent - skipping row 2 sometimes and row 4 others. Any ideas?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@707jeevan]

Your videos are very very helpful. I need help with something..I have to display datatable(from sharepoint list) in canvas app..it's source should be dynamic bcz any number of lists could be created in that sharepoint site.so I have to display only the one that is searched for ..please suggest a way..if not datatable..then in any form but it should Display the sharepoint list..Iframe is not showing whole page

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@707jeevan]

@@RezaDorrani I have tried posting it in forum. But no luck. No one could reply with solution for this. It would be of great help if you could do one such video with this scenario soon.

[@RezaDorrani]

@@707jeevan Forums is a free platform. You may or may not get a response. I make videos when I get multiple requests on a topic. This is the first one for this topic. I have topics with over 20 requests in my backlog.

[@dhivyasrinivasan8052]

Hello Reza, first I really want to thank you for uploading such useful videos. It helped me a lot. Now I'm looking for cascading drop-down. I saw your video regarding that where you have used single line of text field in SharePoint list. But in my case, there is a need to create drop-down for the Person or group field in SharePoint list. Kindly help me with this.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@dhivyasrinivasan8052]

@@RezaDorrani 👍👍 Thanks

[@GergelyCsermely]

Thanks!

[@RezaDorrani]

Welcome!

[@Peanut_memes123]

I’m following along and this is so helpful! But I keep getting an error about ‘Array elements can only be selected using an integer index’. Are you able to help?

[@RezaDorrani]

I cannot guess the error here on chat. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@sophiadcosta-braganza5954]

Hi Reza, I had a question please.. I have an email that contains a table. The email will be triggered based on date and OData filters set in Get Items linked to a sharepoint list.. I am using HTML to generate a table that will go into the table which has some information for each record that meets the filter.. the list has a person field though which is multi select.. So when I initiate a variable to pull the display names from that field, all names pulled are listed for each record.. Do you know how I can get only the relevant fields for each record please? Thank you..

[@RezaDorrani]

I did not understand the question. Il recommend posting your query with screenshots on forums at powerusers.microsoft.com/

[@mutantlabor]

Are you using the terms Array and Object interchangeably here? Seems like you’re saying Array when talking about Objects with key:value pairs.

[@RezaDorrani]

Apologies if there was any confusion. What time in video was the object/array shown?

[@mutantlabor]

@@RezaDorrani At 4:46 you start talking about transforming the shape of the objects in an array. Now that I'm looking at the output, it's objects inside of an array, so perhaps I was misunderstanding.

[@RezaDorrani]

@@mutantlabor Yes, that is objects in an array :)

[@nickelce10]

Hello, font color doesn't works in my example can you explain me, this action for just send email with green value if >0 with an html table. Tkanks a lot

[@RezaDorrani]

I don’t remember running into any issues with it. It’s been a while since I did this video. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@kilaj1]

Ive been struggling to find a solution that would allow me to get the items from 2 different SPO lists and add them to a CSV/HTML table in a single row. One list has a single row of data the other has multiple rows "linked" to the other table via ID. When i use the select + Union operation it adds multiple rows to the final result. the join operation seems to give a single row but its a string. Have you come across this type of issue before?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@kilaj1]

@@RezaDorrani Thanks for the reply, just posted it with more details "Combining SharePoint list into a single row"

[@canumaprass8804]

NICE!!

[@RezaDorrani]

Thanks!

[@sparshraikar4333]

Hello Reza I have a requirement in which I need to filter an array and the filter query must be dynamic ( there is a sp list with all the parameters which needs to be included/excluded) , I tried developing this , but the dynamic query which I create is of the type string (has “” )so it is failing in the filter array action , it’s not evaluating into Boolean value. How can I solve this issue ? . I can use variables to store the filter field and value but how can I manage the length of the query for ex if I have to filter users based on their job titles ( contractors and managers) , how can I dynamically build a query incorporating both the conditions since the variable can hold only one job title and for adding another I have to create another query and AND it with the first?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@annapurnabonakurthi9174]

Hi Reza,Nice expalination.Is it possible to download the BAI2 file format and download the transactions into General ledger.Could you plz sugeest Thanks

[@RezaDorrani]

I have no clue what that format is and have not tried this scenario. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@annapurnabonakurthi9174]

Thanks Reza for the valuable resource…

[@annapurnabonakurthi9174]

Hi Reza It is Bank statement file format(text)at in USA.Thanks

[@RezaDorrani]

@@annapurnabonakurthi9174 oh ok

[@SravanKumar-fe6zx]

Hi Reza I’m building a flow and facing issue can you help me with this I’ve build a flow when a response is submitted on MS form a record is created in an activity entity with the response and is working fine. Now after creating a record in custom activity it needs to be attached with the existing contact record with same email matching to it. I’m unable to do it, is there anyway to do that? Please help

[@RezaDorrani]

I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@sri2900]

How to fetch only the keys from the select action ?

[@RezaDorrani]

You get keys and values from select. I am not aware of how to only get keys.

[@grobbelm]

Reza, I have two integers in power automate that I get from get items. I need to divide integer A into integer B and filter on the results. I then want to filter on the result of the division, for example, filter on fields that are less than 50%. How would I do this please.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@grobbelm]

@@RezaDorrani thank you Reza

[@gregoryoliveira8358]

Hi. Thanks for sharing with us this amazing content. May you help me? I need to create a left join with two JSON inputs in Power Automate. I applied the following steps: 1. Initiated an empty array. 2. Iterate by each rows in the first JSON. 2.1 For each row, I filtered the second JSON based in the id collumn from the first JSON. 2.2 If there are values in the second JSON, I appended the array with all information from the fisrt JSON and the desired information from the second JSON. 2.3 If there are not valeues, I appended the array with all information from the fisrt JSON and the desired information with 0. 3. I parsed the array into a JSON. Thanks again.

[@RezaDorrani]

Thanks Gregory. I do not have any video reference for your scenario and would have to try it out to provide guidance. I will recommend checking or posting your scenario on forums in case someone has done something similar powerusers.microsoft.com

[@keithnxumalo412]

Hi Reza, once again thanks for the amazing videos. how would you handle an object eg { "AED": 4.502592, "AFN": 109.520363, "ALL": 139.035129, "AMD": 514.867387 } and you only wanted to select values AMD , ALL and AED. the compose action is giving an object and not an Array. ~Thanks in advance

removeProperty(outputs('ComposeObject'),'AFN')

[@RezaDorrani]

This is not an array. so you would need to work with these objects one by one. Response from Kristóf Borkowski is a good one!

xpath(xml(json(concat('{ "values": ', removeProperty(outputs('ComposeObject'),'AFN')))), '/values/*/text()')

[@yanuja-o1w]

hello sir i would like to know is there any way to send excel data from power automate to powerapps to populate the dropdowns instead of direct connection in powerapps ?

[@RezaDorrani]

I do not have any video references on this and would have to try to know its feasibility. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@andrews441]

I’m confused as to how to create an array. I was trying to initialize an array with a key and two variables. Then I want to increment one of the two variables based on another list. Do you have some documentation or other videos on how to initialize an array and then modify the array by incrementing a variable based on criteria?

[@RezaDorrani]

I do not have any documentation or other video references. May be a video I did a while ago on power automate variables may help. It would be best to post your issue with screenshots on the forums at powerusers.microsoft.com

[@andrews441]

@@RezaDorrani, thank you!. I did some searching and then went back through our video and figured out variable reference was my issue. This item()?[ ‘varname' ] was key. I don't think I would have figured it out had I not watched your video. I'm now watching the power apps videos to create flows from sharepoint lists! Keep doing videos.

[@RezaDorrani]

@@andrews441 Glad to hear that! Thanks Amy

[@mohammadafroz4611]

Hi Reza, Is there any book to learn Low Code ?

[@RezaDorrani]

I am not aware of any

[@SagarNarender]

Hi Reza, I have specific query (may not be related to this particular thread). I have a sharepoint list having various column types (choice, text etc). Can you please help me figure out, how to pass data from Forms or from another list to a Choice column? Multiselect option is not enabled in My choice column. And I don;t need multiselect in my scenario, I want to add a single choice only. Thanks for your support.

[@RezaDorrani]

Check kzbin.info/www/bejne/oZPUiaaBhbmgkM0

[@vscii2410]

hi, I'm using a create html table function in my flow. for some reason, some of the field will return null although they have data in it. how could I rectify this issue? they input data shows the value they capture but when output it became null

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com