HI, is there a way to update the current sharepoint list, using MS Forms. - Like you update the form and the form updates the information across to that particular document metadata? Love the content thanks :)
Hi, this video is cool. Is there any way to see a summary what you have put and send an email to the owner of this registration form and send a confirmation to the user with the information?
Hi Enea, this was really helpful video. However, I am struggling at one point. In the filter query, the query against which I am adding the filter is a person/group type, hence it is throwing error again and again and running the create part rather than update flow. But when I make it single column it works fine. Can you help me how can this be resolved
With a group column you now have a table you need to filter. I would create an array variable and append the group members in that variable. Then you can do a filter array and use that later in the validation. Hope it makes sense
@@Enea thank you it works. However, whenever my update flow works it updates the existing entry well but side by side creates a new entry as well.. how to resolve it
@@mridulgrover21 you should check the input of the validation (if statement) and the output you are expecting of it. I am not familiar that an if statement outcome can go to the true and false paths, but only one. You might need to check on that logic again
Great video - can this also be used to filter on malicious attacks (i.e. someone tries to enter links, or HTML, code, injections, etc etc into a text field)....I'd like to filter and remove those types of attacks.
Hi Ilias, Very Interesting this video, Creating multiple MS Forms with 1 List in SharePoint, if it is possible to receive email notifications for one MS form that includes multiple section submissions, i.e. 5 section submission to receive notification for 5 different people??? with 1 Lists, please advise
Thank you for this useful video! I am trying to do essentially the same exact thing only connecting with Excel (instead of sharepoint lists) and using an expression pointing to redundant entries on a single day (as opposed to calendar week). Given the differences, I have a couple questions as I am new to Power Automate. 1) Should I be using the 'get a row' function instead of 'get items' function to connect to Excel instead of sharepoint lists? If so, is there an easy way to set up the same conditions using that function since the 'filter query' option is not available in 'get a row' for the Excel connector? 2) if I want to use 'calendar day' instead of 'calendar week' should my 'compose' expression look something like: add(dayOfYear(outputs('Get_response_details')?['body/submitDate']),1) -essentially just removing the div by 7 component? Or is there perhaps a much simpler path to the same outcome for this? Thank you in advance for any help you can provide.
Hey Andrew, thank you for commenting. Excel is a whole different story. Since many people have asked, I might do a "Part-2" next week and use Excel instead of SP :)
Hi thank you for this video! it works for the create function. However my update item keeps failing, as it seems to not be able to pick up from 'get items'. As a result, item are just keep on created. Could you help me with this?
Hi, what do you mean its not able t pick up from "get items"? If you have the action "get items" before the "update item", you should be able to find the dynamic content of that action. Otherwise reach out to me on LinkedIn or Facebook and we can take a look
@@Enea Hi thank you for the offer. The get items seems to work now, but I have further error with other customize flow between sharepoint lists as a result of this form. I will kindly reach out via linkedin or facebook
Hi, would you mind to do tutorial about how to connect microsoft form with sharepoint and sharepoint to word. I means combined the video. I need to do for my special project.
Is it possible to make it so that the SharePoint List is automatically updated if someone enters the same email into a form? For example my setup is for employees to enter their completed training, if they need to update this at the moment they will complete the form and it will add a new line to the list, am I able to make so that it just updates the already existing line for that employee?
Aren’t we already doing that in the validation? If the item exists, it will update, if now it will create. What you use for the validation (ID, Email,etc.) is up to you. I don’t understand what piece are you missing for your solution
@@Enea I'm quiet new to pwer automate so don't have a great understanding of it. I don't really get the calendar week/composure part. Do i need that if i only want it to update if its an entry from an already existing person?
@@Enea How do I change the validation to check if a name already exists on the list. I'm new too and I don't understand the Compose function. I want to check if the name is already on then update if not then create new.
@@juliecampbell6044 you need to do a get items with a filter query and then see if the length of the response is 0 or not in a condition action. If it is 0 then it means the item does not exist so you can go and create it. If it is not 0 it means the item exists and you can use the ID in the response to update it. I have showcased something similar it in this video: ruclips.net/video/looyVm_8OKI/видео.html
@@Enea Thanks so much for replying - I've managed to get the flow to work however, it has created a new item instead of updating it - so I now have 2 items with the same name. I'm not sure what I've done wrong for it not to update instead of create item. Thanks.
Hi, is there a method in SharePoint to trigger an event based on a value in a field? For example when my drivers license expires so I would get an email and text message sent to me a couple of weeks reminding me. Thanks 🙏🏿
You can create a calculated column that will change to true if expire date of your drivers license is equal to today and hide that column. Then have an automated cloud flow check on that column by using the „when an item is modified“ trigger with an extra trigger condition on that hidden column. Next step would be to send a notification. Makes sense?
HI, is there a way to update the current sharepoint list, using MS Forms. - Like you update the form and the form updates the information across to that particular document metadata? Love the content thanks :)
Hi, this video is cool. Is there any way to see a summary what you have put and send an email to the owner of this registration form and send a confirmation to the user with the information?
Hi Enea, this was really helpful video. However, I am struggling at one point. In the filter query, the query against which I am adding the filter is a person/group type, hence it is throwing error again and again and running the create part rather than update flow. But when I make it single column it works fine. Can you help me how can this be resolved
With a group column you now have a table you need to filter. I would create an array variable and append the group members in that variable. Then you can do a filter array and use that later in the validation. Hope it makes sense
@@Enea thank you it works. However, whenever my update flow works it updates the existing entry well but side by side creates a new entry as well.. how to resolve it
@@mridulgrover21 you should check the input of the validation (if statement) and the output you are expecting of it. I am not familiar that an if statement outcome can go to the true and false paths, but only one. You might need to check on that logic again
Great video - can this also be used to filter on malicious attacks (i.e. someone tries to enter links, or HTML, code, injections, etc etc into a text field)....I'd like to filter and remove those types of attacks.
Sure, you need to define the criteria first and then filter based on that.
Hi Ilias, Very Interesting this video,
Creating multiple MS Forms with 1 List in SharePoint, if it is possible to receive email notifications for one MS form that includes multiple section submissions, i.e. 5 section submission to receive notification for 5 different people??? with 1 Lists, please advise
Thanks, sorry I cannot understand what you are trying to achieve. Can you please explain a bit more?
Thank you for this useful video! I am trying to do essentially the same exact thing only connecting with Excel (instead of sharepoint lists) and using an expression pointing to redundant entries on a single day (as opposed to calendar week).
Given the differences, I have a couple questions as I am new to Power Automate.
1) Should I be using the 'get a row' function instead of 'get items' function to connect to Excel instead of sharepoint lists? If so, is there an easy way to set up the same conditions using that function since the 'filter query' option is not available in 'get a row' for the Excel connector?
2) if I want to use 'calendar day' instead of 'calendar week' should my 'compose' expression look something like:
add(dayOfYear(outputs('Get_response_details')?['body/submitDate']),1)
-essentially just removing the div by 7 component? Or is there perhaps a much simpler path to the same outcome for this? Thank you in advance for any help you can provide.
Hey Andrew, thank you for commenting. Excel is a whole different story. Since many people have asked, I might do a "Part-2" next week and use Excel instead of SP :)
@@Enea That would be amazing! Thanks so much for considering
Hi, I just managed to finish and post the Excel version. Take a look here: ruclips.net/video/I4mniT9Wcew/видео.html
Hope it helps :)
Hi thank you for this video! it works for the create function.
However my update item keeps failing, as it seems to not be able to pick up from 'get items'. As a result, item are just keep on created. Could you help me with this?
Hi, what do you mean its not able t pick up from "get items"? If you have the action "get items" before the "update item", you should be able to find the dynamic content of that action. Otherwise reach out to me on LinkedIn or Facebook and we can take a look
@@Enea Hi thank you for the offer. The get items seems to work now, but I have further error with other customize flow between sharepoint lists as a result of this form. I will kindly reach out via linkedin or facebook
Hi, would you mind to do tutorial about how to connect microsoft form with sharepoint and sharepoint to word. I means combined the video. I need to do for my special project.
Maybe :)
Is it possible to make it so that the SharePoint List is automatically updated if someone enters the same email into a form? For example my setup is for employees to enter their completed training, if they need to update this at the moment they will complete the form and it will add a new line to the list, am I able to make so that it just updates the already existing line for that employee?
Aren’t we already doing that in the validation? If the item exists, it will update, if now it will create. What you use for the validation (ID, Email,etc.) is up to you. I don’t understand what piece are you missing for your solution
@@Enea I'm quiet new to pwer automate so don't have a great understanding of it. I don't really get the calendar week/composure part. Do i need that if i only want it to update if its an entry from an already existing person?
@@Enea How do I change the validation to check if a name already exists on the list. I'm new too and I don't understand the Compose function. I want to check if the name is already on then update if not then create new.
@@juliecampbell6044 you need to do a get items with a filter query and then see if the length of the response is 0 or not in a condition action. If it is 0 then it means the item does not exist so you can go and create it. If it is not 0 it means the item exists and you can use the ID in the response to update it. I have showcased something similar it in this video: ruclips.net/video/looyVm_8OKI/видео.html
@@Enea Thanks so much for replying - I've managed to get the flow to work however, it has created a new item instead of updating it - so I now have 2 items with the same name. I'm not sure what I've done wrong for it not to update instead of create item. Thanks.
Hi, is there a method in SharePoint to trigger an event based on a value in a field? For example when my drivers license expires so I would get an email and text message sent to me a couple of weeks reminding me.
Thanks 🙏🏿
You can create a calculated column that will change to true if expire date of your drivers license is equal to today and hide that column. Then have an automated cloud flow check on that column by using the „when an item is modified“ trigger with an extra trigger condition on that hidden column. Next step would be to send a notification. Makes sense?
@@Enea - Understood. I will give it a try. Thanks a bunch. 🙏🏿🙏🏿 😊
You are welcome. Subscribe if you like my content, would mean a lot :)