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

This Power Automate video is an introduction to Data Operations in flow. You'll learn about some common data operations in flow, such as Compose, Join, Select, Filter arrays, Create tables, and parse JSON. These actions are available to manipulate data when you create flows.
Flow Data Operations:
🔵 Compose Action - Use the Data Operation - Compose action to save yourself from having to enter the same data multiple times as you're designing a cloud flow.
🔵 Join - Use the Data Operation - Join action to delimit an array with the separator of your choice.
Select - Use the Data Operation - Select action to transform the shape of objects in an array
🔵 Filter Array - Use the Filter array - Data Operation action to reduce the number of objects in an array to a subset that matches the criteria you provide
🔵 Create CSV table - Use the Create CSV table - Data Operation action to change a JSON array input into a comma-separated value (CSV) table
🔵 Create HTML table - Use the Create HTML table - Data Operation action to change a JSON array input into an HTML table
🔵 Parse JSON - by providing JSON content and schema
Helpful Links 🔗:
Documentation for data operations
docs.microsoft.com/en-us/powe...
Learn Flow expressions
• Power Automate flow Ex...
#PowerAutomate #flow #PowerPlatform #SharePoint
Table of Contents:
00:00 - Introduction to Power Automate Data Operations
00:41 - What are the actions in flow for data operations?
01:10 - Compose action in flow
03:38 - Join action in flow
04:35 - Select action in Power Automate
07:27 - Filter array action
08:31 - Create HTML table & Create CSV table actions
09:29 - Parse JSON action in flow
10:59 - Use data operation actions in flow
11:25 - Use Select & Join to create semicolon separated strings in flow
14:35 - Create formatted HTML table in flow using JSON Array data
19:33 - Send scheduled email with HTML data using flow create HTML table action
20:25 - Generate Dynamic HTML data, CSV & PDF files using Create HTML & CSV table actions in flow
22:18 - Send Grouped Data as HTML using Compose, Select & HTML flow actions
23:48 - Document Review workflow tracking using Select, Filter & other data operation actions in flow.
25:02 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

[@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

[@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!

[@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!

[@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!

[@antonufy]

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

[@RezaDorrani]

Happy to hear that!

[@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 👍

[@renatofagundes5560]

Excelente como sempre! Obrigado, paçoca.

[@RezaDorrani]

Most welcome

[@clay4gli]

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

[@RezaDorrani]

Thanks for watching Clay

[@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.

[@binduhoney6717]

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

[@RezaDorrani]

Thank you very much!

[@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.

[@petaratanasov4153]

Amazing content as always! Thanks, Reza!

[@RezaDorrani]

Glad you enjoy it!

[@tranbangviet]

Thank you very much for the lessons and examples

[@RezaDorrani]

Glad you like them!

[@user-mx8mc2ud5k]

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

[@RezaDorrani]

Thanks Manoj

[@BraulioPatriota]

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

[@RezaDorrani]

Great to hear!

[@shaikhfirdos2723]

Extremely useful video . Thanks Reza..

[@RezaDorrani]

My pleasure!

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

[@alzaimoor79]

Thanks, very useful, well explanation

[@RezaDorrani]

Thank You

[@StephanOnisick]

Awesome Functionality!

[@RezaDorrani]

Thanks

[@elrevesyelderecho]

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

[@RezaDorrani]

👍

[@ExcelFormulasHacks]

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

[@RezaDorrani]

Glad to hear that

[@adityadeshmukh3150]

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

[@RezaDorrani]

Thanks a lot 😊

[@khaledalaqqad1934]

Very excellent explanation Thanks a lot

[@RezaDorrani]

Most welcome

[@DroneEyes]

Great explanation Reza!

[@RezaDorrani]

Thanks

[@efficiency365]

Excellent.

[@RezaDorrani]

Thank you! Cheers!

[@rthoughts7232]

Very nice video and tricks 👍🏼

[@RezaDorrani]

Glad you liked it!

[@mohamedfouad7958]

thanks a lot for your efforts

[@RezaDorrani]

Most welcome

[@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.

[@kingquadri1850]

Awesome info

[@RezaDorrani]

Thanks

[@inglesdicasdesafios9922]

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

[@RezaDorrani]

You’re welcome

[@FRANKWHITE1996]

Epic ❤

[@GergelyCsermely]

Thanks!

[@RezaDorrani]

Welcome!

[@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

[@canumaprass8804]

NICE!!

[@RezaDorrani]

Thanks!

[@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 :)

[@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.

[@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.

[@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.

[@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

[@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 😜😅

[@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

[@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

[@sundrapillay6668]

Thanks Reza

[@RezaDorrani]

Thanks Sundra

[@kunstdigital2242]

Great

[@RezaDorrani]

Thanks

[@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/

[@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.

[@ally1708]

thanksss

[@RezaDorrani]

Welcome

[@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

[@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.

[@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.

[@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

[@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/

[@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.

[@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.

[@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

[@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 ...

[@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.

[@DUVEDITZ]

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

[@RezaDorrani]

?

[@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

[@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.

[@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/

[@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.

[@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

[@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

[@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.

[@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

[@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.

[@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.

[@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

[@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

[@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.

[@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

[@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"

[@vijaykumar-kc7dt]

Hi Reza, Could you something show me the flow with SAP. Pulling the data using OData or Rest API. It would be very grateful.

[@RezaDorrani]

I have not worked with SAP connector. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@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

[@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

[@SergioItashop]

Hi Reza Dorrani. How do Customize this message "No item to display" in PowerApps ?

[@RezaDorrani]

Never tired it! I believe its out of the box. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@rishabhjain3708]

Thanks Reza for the amazing videos! Could you please help me with how I can create a flow that returns a string of direct and indirect reports of a manager. For example, A is the manager of B and they (A and B) both have two direct reports each. The result I want is the email address of all four (two direct reports of A and two direct reports of B) as string separated by a semi-colon.

[@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.

[@rishabhjain3708]

@@RezaDorrani thank you! :)

[@user-iy1gf4hk8d]

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

[@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.

[@mohammadafroz4611]

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

[@RezaDorrani]

I am not aware of any

[@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

[@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.

[@Relaxbi]

Hi Reza i want to ask how can i get the required attendees from outlook and add them all to a sharepoint list person or group field i'm having trouble with the content of the parse Json "The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: e. Path '', line 0, position 0.'." this is the error that im getting i have the flow that saves the required attendees in a single line of text but with that i can not filter the gallery in powerapps based if that field contains my email or not i would appreciate the help

[@RezaDorrani]

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

[@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

[@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 :)

[@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()')

[@hobirumahan85]

I have table with some columns and create filter array to select item in table, when i create html table from output array error why, i use syntax like this item()?[`data]

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@SirajAhmad-uo1gr]

Hello Reza, I hope you are doing well, I have a scenario plz help me. its a employee performance appraisal system. one employee can have multiple reviewers. each reviewer can have multiple employees to review. I have two sp list. List1 is primary list, containing all employees info List2 is foriegn key list. List2 has a column employeeId which is ID a primary key column in List1 I have fetch list of employees for each reviewer from list2 but i have employeeId in result. I want to fetch employee name from list1 using employeeid from list2. how can i achieve this. plz guide me.

[@RezaDorrani]

I do not have a video reference on this scenario. I will recommend checking on forums at powerusers.microsoft.com/ in case someone has done something similar

[@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

[@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

[@vandanapatil9947]

Hi Reza, if approver whose part of SP Approval Group upload document in library then no need to go through workflow and automatically Approval Status column should Approve I have try to fetch email of user present in group and compare with creater email but it is running only if 1 user is present. I want condition where All user in SP group I will get and compare and If user email match then set content Approval Status to Approve

[@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

[@MarkWork-oc6io]

Hi Reza, I am trying to create a select operation that filters out items previous to today's date, but the flow fails on Null values. InvalidTemplate. The execution of template action 'Select_2' failed: The evaluation of 'query' action 'where' expression '{ "@item()?['SignOutDateTime']": "@less(item()?['SignOutDateTime'], formatdatetime(utcNow('yyy-MM-dd')))" }' failed: 'Unable to evaluate template language expression '@item()?['SignOutDateTime']' as JSON property name: the expression value of type 'Null' could not be used as property name.'.

[@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.

[@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.

[@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.

[@kittyketan]

How can you do the same actions using power automate desktop

[@RezaDorrani]

I have not tried this with PAD. I will recommend checking or posting your query on forums at powerusers.microsoft.com

[@zeeshanfarooqui7610]

Hey Reza How can I display more than 2000 records in a combo box?

[@RezaDorrani]

kzbin.info/www/bejne/sIGwYYRraLFmqac Not an option

[@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

[@KhurramGohar]

Hi @Reza, I’m using an Ms form and i have multiple reviewers for a task. I have created automate flow and approval process. But I’m having difficulty in creating a dynamic approvers action. My ms form answers are saved in share points list using automate. Plz help

[@KhurramGohar]

What i want is if I select multiple reviewers in ms form, and when this data comes in automate, the approval emails should be sent to the people selected in ms form.

[@RezaDorrani]

Video is not about approvals :) 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

[@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

[@KhurramGohar]

@@RezaDorrani Thank you !! I will create a post there.