วีดีโอ

Thanks for the support. last(split(outputs('Converted_Data')[6],': ')) Expression looks ok to me. I need to see your data? Thanks

Ok next time. Thanks for the support.

Thanks Prashant. Appreciate your support.

Hi I haven't tried this in PAD yet. Thanks

Thanks for the support. Yeah its fun and games :-)

Hi At which stage you getting this error? Could you tell me my video timeline so that I can have a quick look and see. Thanks

Hi Sivaji Thats very kind of you saying this. I will try. Are there anything particular you looking for? Thanks

Yes it’s useful but I’m looking for power apps tutorial.can you please do it.

Glad it was helpful! Thanks for your comment and support.

Hi Is that two different emails. Then you need two different flows as trigger referring to those emails. Store the body in OneDrive or SharePoint. Once you received both then you can compare the body. You need three flows to achieve this. Thanks

Hi Good question. There is an api available for this. Let me check this and get back to you. Thanks

Hi @sudhindrak01 I made a video regarding this. Please have a look and comment. th-cam.com/video/tHHkrydI8xk/w-d-xo.html Thanks

So for me I already run the flow in my prep video. Then when I start using the same data Dept excel sheet is already created. For the demonstration purpose I did changed the dept name. In your case close the browser sessions and leave it for few minutes. Then run the flow. It won't get locked. If you need further help in this let me know. Thanks

@@abm4975 Thank you for your reply. I understood this part. However, is there any issue with the filter array output returning Body[]?

@@abm4975 Just to add, I managed to create the new department files but their contents were empty. I wonder if it has anything to do with the filter array output returning Body[].

@@abm4975 Specifically, it is at Apply to each 2 that the Output returns Body [].

Hi Sarah I need to check your flow. Could you check my channel about section. Send me an email. I could offer a screenshare help to progress this. Thanks

Thats great to hear. Thanks for your comments. Wishing the best.

Glad it was helpful! Thanks for your kind comments.

You're very welcome! Thanks for the support.

You need two different flows as the trigger is when an email arrives and set the unique subject under the trigger.

Hi Follow the below steps: Use the Get Files (properties only) Set your library name, folder and say include nested items Yes Under the Filter Query use FSObjType eq 0 This will get all the files only not any subfolders. Then use the delete file and use the identifier from the previous step to delete the file.

@@abm4975 Hi i did this with a few other references and got the issue sorted. Thank you so much for your response and the video

That's great to hear that all sorted. Wishing the best.

Different ways you could do this. Easiest way is read all the rows using list rows. Before the list rows declare a variable called Total as integer. Once the list rows are done add a compose and add an expression add() here map the excel value and the variable Total. Then again inside the loop use Set variable to map the output of the compose. Finally outside the loop you can use the Total variable which will be the sum of the column values of all the rows. Thanks

Hi You need to get the emails first from the excel. For this you need to use union() expression to get all the unique emails after reading the Excel sheet using List Rows. Next iterate the results of the union so that you get each email and use the Filter action step or List Rows with filter query matching each email. Next you can use this result to use the Select actions step to select the values which you want to email. Finally map the results from the select action step in your email. Thanks

I have already replied this in your other post.

Hi Its not easy to explain here as by comment. Check my Channel about section and contact me via email. I could offer a screenshare help. Thanks

@@abm4975 Thank you for your swift response! I will research your channel. How much would you charge for screen sharing help?

I don't charge for screenshare. Its a community work. Thanks.

Yes you can. Add a row into table action step (Excel Connector) provides the location to choose from Onedrive or SharePoint. Thanks

Hi Under the Get files (Properties only) Set the Orderby > Created desc Set the Top Count > 1 This will give the latest record.

@@abm4975 Amazing, thanks! It works.

Glad to hear all good.

Glad it was helpful! Thanks a lot

Hi Thanks for your kind comments. I need to see the flow. You can connect me via email. Its in my Channel about section. Send me an email and I could check this via a screeshare if that helps. Thanks

Thanks for the support Ryan.

Hi Is this option set or lookup? Thanks

It's a defined set of options. I want to make a checkbox rather than combobox

Try the below: Power Pages Management > Basic Forms > Open your form > Select Basic Form Metadata > Click New Basic Form Metadata Select the Type as Attribute. Control Style as Multiple Choice > Select Attribute logical name - Here select your multi-select field name.

@@abm4975 thank you it works

Hi Have a look at this blog. tomriha.com/parse-data-from-an-html-table-in-an-email-with-power-automate/ Also there are few videos out there regarding the same subject. th-cam.com/video/i4GHCGMAD88/w-d-xo.html Thanks

Hi @gavinobrien5361 Thanks for the comment and support. An interesting question you asked. Its client side you generate the adaptive card. Tell me more about you create using the designer or not? Not sure we can store this in a profile?

Hi Thanks a lot for your comment. I have checked the video and it looks ok to me. Once you start playing the video check the settings > click quality > set to high resolution (1080p). Let me know how it goes. Thanks

@@abm4975 Thanks a million bro. May GOD Bless You abundantly! I am now able to follow the video as the quality of improved on my screen. Your Video is exactly the guidance and teaching I needed to complete my current project. You have just captured a new follower, ha, ha ,ha! 😃🙏

Hi Thanks for your reply. Glad that all sorted. Any questions regarding Flow, Power Pages and Model Driven Apps let me know. Glad to help the community. Wishing the best.

Hi Andy I need to see the flow to determine what's going on. Check my channel about section and connect me via email. I could check via a screenshare and see. Thanks

Glad to hear that. Thanks for your kind comment.

Yes for the OneDrive when you create the file you can pass the dynamic folder name. It will automatically create the folder. If you need any further help in this please let me know. Thanks

Glad I could help! Thanks a lot.

You are welcome!

You're so welcome! Thanks for the support.

Hi Thanks for the question and support. Follow the below steps: 1. After the outlook trigger, add an action step called Create new folder. 2. Next action step Export email. Here pass the Message ID from the trigger. 3. Finally use the create file to save the email body to the specified folder we created earlier.

Thanks for watching!

You’re welcome 😊

Yes, you are right

Believe you are asking Excel reading rows. If you read via Graph API you can get the header names and columns. Thanks

Thanks a lot

Hi Thanks for your comment. In Power Automate Excel List rows action step. Expand the advanced options and set the date to ISO 8601. This will give the date in a readable format. Then in your email body use the expression eg: formatDateTime(items('Apply_to_each')?['DateColumnName'], 'dd/MM/yyyy'). Change the 'Apply_to_Each' mapping accordingly. Thanks

Hi Thanks for your kind comments. To get the supervisor email you need to collect that using another select action step.

​@@abm4975 thanks for the reply bro, if possible can you please suggest whether the select action would be inside the "For each" loop or outside

Hi Karthik Could you connect me via Channel about via email. Will do a screenshare and explain. Thanks

yes. Create another excel file as a template. Specify the columns and create a table. Store in SharePoint or Onedrive. Then read from the filter results and add rows into the new excel template.

So extend the filter using modified date. The expression you need is utcNow() expression. formatDateTime(utcNow, 'yyyy-MM-ddT00:00:00) Then use Delete file and pass the file identifier to delete the file. If you have any further questions please let me know. Thanks

Hi @Subham Great question. I will make a video about this and post the link by tomorrow. Thanks

Hi @shunbam-0n3rn I have created a tutorial video based on this. th-cam.com/video/597DqjvfNtw/w-d-xo.html Please have a look and comment. Thanks

@@abm4975 thanku sir

Watch the video and comment. Thanks

Hi Once you filter the values I believe you have reps in each columns. You can use a Select action step to get only the reps. Then map the values into email cc step. If you are struggling to do this, check my channel contact and send me an email. I could help you via a screenshare. Thanks

@@abm4975 This worked thank you!! I was missing the "?" from the item()?['xx'] which made everything go wonky so it was a few days before I figured out the issue, but now I'm up and running. Thank you again!

Thanks a lot

You're most welcome