Видео

How secure is this? Can the whole organization or potential outsiders see responses?

refresh did not work!!

Watched many videos about this subject from others, but this was the one for me. Thx! Very happy with my result.

well done. thanks alot.

Can you make one video update 2nd list that already have email and attachments there which usually update unable to update additional email and attachments added from master list. Thank you

Set(surl,ThisItem.'Link to Item'); Is not working for me. The error showing is : Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the types of values in other places in your app

how do you create the progressive ID in ID column? thanks

This was really helpful!! Thanks a lot

Hello, great video. What about if you want to add the changes to a 2nd sharepoint list and not via email. I’m trying to have a 2nd sharepoint list that logs all the changes/version history. Any suggestions on how to accomplish that instead of sending it through email. Thank you.

This was super helpful Prakash, thank you very much!!!

Thank you! But it says Unable to process template language expressions for action Condition at line 0 and column 0. The template language function contains expects its first argument collection to be dictionary, an array or a string. The provided value is of type Null. Can you help me out?

Very informative

Hi Prakash, I followed the same process as per your video but the src info within img tab disappears when it runs, meaning just the <img> is displayed when it is saved/run. Still, I receive the email with no image on it. Do we need a premium license to run the flow with the image? But just one day it worked for me to send an email with the image then I altered new columns in the SharePoint list and reselected the fields in power automate flow, it's gone and I keep trying it but no luck. Can you please advise me?

Hi, thanks for this very useful tip. Two questions: why do you change the data source in Canvas and not in json? Second, I tried both ways for the data source but my field cards are not updating their data source automatically - Canvas actually suggests to replace the cards with new ones but this creates a mess in the form. Do you know why this would happen?

Hi there, thank you for these great instructions, however I'm having a bit of trouble. I am trying to add the titles (names) of each questions in the body of the email to match to the dynamic value, however when I go to try to search for the dynamic value, I keep getting "There are no results for your search" . I must have missed a step in connecting my form. please help

"identifier" is not show up on the list

whenever my item is getting update with multiple coloumns it's creating an new entry rather just updating the same why so ?

This is really helpful thanks a lot

For those that have the error when there isn't attachments, follow this: 1.) Under your Initialize Variable that you named "fileUpload" create a Compose Data Operation action. 2.) For the input, use a length expression similar to the JSON made in the "Apply to each" field. You will do the exact same thing, select Expression tab, then enter: length("dynamic content for file attachments response") again, it's the same as the JSON we have to get response details. Make sure you click dynamic content while your cursor is within the parenthesis and select your forms name for the file attachments. This will check the character length of the response. 3.) Now create a condition and select the dynamic content from your Compose action "Outputs". Use the expression "Outputs" is greater than 0 4.) In the YES condition, put your "Apply for each" command and the send email action. This will run if the output from our data operation is greater than 0 which means there's attachments. 5.) Copy your send email action and add this action to the NO condition. Go in the advanced options and remove the fileUpload expression within attachments. Rename this to whatever you need that tells you it's with no attachments and the same for your other that sends with attachments. 6.) Save and test! Your flow should look like this: When a new response is submitted --> Get Response Details --> Initialize Variable --> Compose --> Condition Condition Flow: YES --> Apply to each --> Send Email With Attachments NO --> Send Email Without Attachments Hope this helps!

This is very easy and step by step explanation. Thanks for sharing

I keep getting an error in the Select_3 step. And my outputs have not looked the same as yours after the filter array step. ChatGPT is saying that my outputs appear to be a mixture of JSON-like structures, HTML, and other text. How do I fix my flow?

Thanks, this was really helpful years later!

Awesome technique, just to note that you cannot use negative numbers with Range function.

Hello Learning Tech I have also done it according to your instructions but when I update it makes me a new line every time. I don't know where I made the mistake.

am i need a domain for creating a forms for excel

i need help I have more than one file upload in each slot how put power automate

@LernenTech does this mean the user has to login twice? First using Microsoft PowerApps Login (OAuth) And then in-app login? Correct?

Thank you... I tried but got lost at Lookup(Usercredential,'User Name'.Email =TextInput2.Text where did that .Email part come from?

simple and to the point

Mine is working but it is sending blank

Excel sheet is not updating. Double checked and my flow is correct.

Can we reset the ID start from number 1 again

I'm sorry, but I don't understand your reasoning. If I select from Sunday October 1st till Friday October 6th, the calculation would exclude two days, Sunday and the Monday because is public holiday, so the results should be 4 instead of 3 days. Tuesday, Wednesday, Thrusday and Friday (because the 6th is included in the date range). In your example is like you are excluding Friday.

thank you

Hi, Will it work for mobile devices?

I was literally just starting to work on a side navigation gallery component and was having issues. I found this video and this is just excellent. Thank you for providing great tips and insight.

You are amazing

you are great!!!

Hi ,Here the source of data is from Sharepoint ,if it is from azure blob is there any possibility to get data from there directly into powerapps and download. Thank you!

thank u so much

woww! I was stuck at one point and you just solved that issue!

Thanks a lot mister ;) Very helpful 😍

I have three regions APAC, AMER, EMEA. I want something like if I'm creater folders it should to the respective folders instead to all the region. Like A folder in AMER, B Folder in EMEA and C folder in APAC. Can you help in tis

Thank you. Literally saved my few days of searching the solution. 😊

Hello How can I correctly add to this cycle that when the user updates information in the Destination lists, it is also updated in the Source lists? It is necessary that in both sheets it is possible to change the information in the record.

Nice work. You got appreciation from my Manager. Thank You!

Thanks! Much better than ChatGPT 3.5's suggestion and all forum posts.

Hello, its a very useful tutorial, just when im trying to do the same, i receive the following error on the condition yes:  InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. Could you help to solve?. thanks a lot.

what if we want to move specific files that are in a list in excel? Is there a way to link the excel sheet so power automate can grab the file names from the spreadsheet?

can we add dataverse to exiting app screen can you please provided solution