How to add new table to the source? Like teachers4 Table.
@Stevencyw883 күн бұрын
great. this is what i am looking for to trace changes
@EmilyForristel5 күн бұрын
Hi, can you link the video where you show how to prompt users to update a field (comment)?
@Enea4 күн бұрын
Sorry, I do not understand what you mean? 🤔
@lachmankrishen6 күн бұрын
Is it possible to start any flow with a flow identifier, and can we send a sharepoint record to the triggered flow from sharepoint
@Enea5 күн бұрын
The trigger needs to be the same as in the video. The ID you place in the format column JSON can also be dynamic. All you need is a list of IDs for the user to select from before clicking the button to trigger it
@lachmankrishen5 күн бұрын
@Enea but if I have 3 sharepoint sites that are using the same flow, is there another trigger that I could use? I want to create a global flow, that could be used by different sharepoint sites
@Enea5 күн бұрын
there are workarounds for this. Google and something will come up. Its a bit complicated for a comment
@Enea4 күн бұрын
@@lachmankrishen there are workarounds for this. Google and you will find something. I dont have a video for this usecase and explaining it here is impossible
@ManikanaRangaiah6 күн бұрын
Thanks for the detailed explanation... I tried to create a new flow by following the steps you have mentioned in the video. However, I am getting only one error. Request you to help me to resolve this error (Get_tables --> body --> value is coming blank). Thank you. unable to process template language expressions in action "Set_variable_2" inputs at line '0' and column '0': 'The template expression 'outputs('Get_tables')?['body/value'][0]['Name'] cannot be evaluated because array index '0' cannot be selected from empty array.
@Enea6 күн бұрын
It looks like your Excel has no tables. Have you formatted you data in Excel in a table format?
@ManikanaRangaiah6 күн бұрын
@@Enea Thank again for your swift response. Exactly, I have done the same mistake. I have formatted the data in Excel in a table format and it's working fine now. This video is very helpful :)
@Sandeepkumar-s2y8e7 күн бұрын
it worked. Thanks
@Akkkk8557 күн бұрын
Hi, Thank you for the tutorial. I am getting an error - type/format Number/double is not convertible
@Enea7 күн бұрын
It looks like you are trying to convert a double type of column to something else. What exactly are you trying to achieve?
@mfarzan-u3b7 күн бұрын
Thank you Enea fr saving my life from thorn rose
@Enea7 күн бұрын
Dont know who that is but happy I could help
@rolaogomes7 күн бұрын
Input parameters: "$filter": "558 eq SyncedID", "viewScopeOption": "RecursiveAll" } Output body: body { "value": [] } Followed this from your video 1 year ago, everything went to shaite since then.
@Enea7 күн бұрын
And now?
@MrDcdc23237 күн бұрын
Very helpful. Thank you!
@ViniciusBarbosa-yt8sj8 күн бұрын
Bro you just saved me from a helluva lot of work. Seriously, thank god you shared this.
@bintenasir711 күн бұрын
Hi, I have been following this flow you created however Name field in append to string variable is set to be on read only mode. What could be the reason?
@mxbcreative12 күн бұрын
I have a question that ive been banging my head against the wall. I have a Ticket # columns that is formula generated in Sharepoint, we have a flow set up to push this formula into a field Text Field in a different sharepoint list. But then i need to update certain fields back in Original List and the update doesnt run when i do the filter query + the lenght portion.
@Enea11 күн бұрын
Do you get any results from the filter query response?
@mxbcreative11 күн бұрын
@@Enea no it doesnt even trigger the modify action even when i manually trigger a change in the list.
@christophmeirich592813 күн бұрын
In my case the attachment is true false ... Did I something wrong? or may I change the type? Thx in advance ... Christoph P.S.: I choosed the wrong column ... I have to choose AtachmentFiles :-) Thx for sharing your vid :-)
@Enea13 күн бұрын
Happy you could solve it by yourself! :)
@silencyo235313 күн бұрын
Nice content @Enea, I would like to ask How to connect the powerapps to Azure sql database via AAD and my tenancy in Azure is guest account. I am having problem like Login failed for user '<token-identified principal>'. The server us bit currently configured to accept this token.
@wtstara14 күн бұрын
Great, thank you very much!
@KrzysztofAchinger-y8z14 күн бұрын
Amazing, thank you for sharing!
@SpaceNerdUffi15 күн бұрын
Hi Enea. Ich hab ein kleines Problem. Und zwar habe ich dein Tutorial mit den 2 synced Sharepoint Lists verfolgt. Funktioniert alles wunderbar, nur habe ich ein kleines Problem. Ich habe bei einem Reiter eine Dropdown Auswahl, also mehrere Elemente. Für das wird je eine column erstellt, z. B. Test A mit Abz Department Und Test A mit Exz Department Wie kann ich das fixen? Kannst du mir helfen? Ich hab dich auch via linked In angefragt. Kann dir da auch ein Abbild zukommen lassen.
@Enea15 күн бұрын
Hi! Ich dachte die Frage war bezüglich dieses Video. Ja meld dich auf LinkedIn und ich schaue mir das an. Kann aber nichts am Rechner testen, bin gerade im Urlaub
@SpaceNerdUffi15 күн бұрын
Hi Enea. Danke für deine Rückmeldung. Ich glaub ich hab’s gefixed. Jedoch werden die Daten nicht richtig angezeigt warum auch immer. Melde mich via LinkedIn 🙏🏽
@divyagoel826512 күн бұрын
@@Enea
@seatconnect22418 күн бұрын
Hi! is it possible to add action button for each row in table? I need to perform some action when click button (send POST request or trigger PA flow)
@Enea17 күн бұрын
Check out this video: Power BI Table to HTML & PDF kzfaq.info/get/bejne/iLV3oKuVpr-qeGw.html , one of the responses from Power BI integration allows you to do a per row action. Remember you only get 1000 rows
@seatconnect22417 күн бұрын
@@Enea Thanks!
@arthurandrade9819 күн бұрын
It worked perfectly, thanks a lot
@Mo-.-man10121 күн бұрын
This helped me realised it was Outcome I needed to use for the Conditions Thank you very much
@sojuturnip21 күн бұрын
I'm finding it an issue to transfer the text now from the input to a SharePoint file. If I don't wait long enough or move to another part of the app, it will only partially upload the text or nothing at all.
@Enea21 күн бұрын
Have you tried using one of the other properties? The key press option should transfer the text immediately as you see in the video
@TateSpirit22 күн бұрын
is there a file upload option available ?
@Enea21 күн бұрын
Unfortunately not yet, only via the „old way“ over Forms and then transferring the data via Power Automate
@dominicatuahene730322 күн бұрын
This is awesome sir, This video helped me solve a flow problem I have been looking for solution for 3 months now. Thank you so much. How can I also copy the attachment into the sharepoint document folder? do you have a video on that?
@Enea21 күн бұрын
Thank you, happy I could help! The process is very similar, only thing that changes is you use at the end the action „create a file“. Select your library and you are good to go 👍🏻
@Magpiekit22 күн бұрын
I have an app that creates a meeting (a training session created by a trainer). I want delegates to be able to book on to these training events. Is there a way to update an exiting meeting to add new participants?
@OntGooner25 күн бұрын
any clue why this will not work with the "Title" column?
@Enea25 күн бұрын
Shouldn’t play a role…whats the error?
@Baaasty25 күн бұрын
Thanks. I had the problem when I click on my save button the old title value was send. Only if i click outside first the value saved... i didn't know about this option. Danke dir Bruder
@Enea25 күн бұрын
Gerne :)
@thigy2226 күн бұрын
Can you collect the data without hitting submit? If there are multiple sections can you collect data from just hitting "Next" to go to the next section of the form?
@Enea26 күн бұрын
No, that is something you can do with Power Apps
@freddieaylward544026 күн бұрын
Thanks for making it easy. Appreciate
@asiffity498228 күн бұрын
Any idea how this can be applied to only sub folder? I'm and expert in PA so I understand everything there is that the Pa part is doing, but when it comes to sharepoint part I have no idea, I've created all of this but now I have folder structure of Main folder with multiple sub folders and I only want this flow to be triggered from on of the sub folders. Right now all my sub folder and Main folder can see this new column that can trigger my flow. Any tips?
@Enea28 күн бұрын
Create a SharePoint view and hide the PA-Trigger column. Only way
@thealchemist537629 күн бұрын
Thanks for the explanation! I'm always keen to learn more about power apps!
@EllieCarter5225Ай бұрын
I love all your videos I just wished it was a little bigger to see. Maybe I need new glasses.😔
@EneaАй бұрын
No Ellie, I need to remind myself to zoom in before starting recording. Sorry 😕
@EllieCarter5225Ай бұрын
@@Enea - NEVER be sorry! I appreciate the content and want to say Thank you! I do need better glasses though 🤓
@iron_polizeiАй бұрын
당신은 나에 구세주 입니다. 너무 간결하게 설명 잘 해주셔서 감사합니다. 고마윰을 꼳 표현 하고 싶었어요
@yojimatsui9055Ай бұрын
Thanks for the video. I was able to get data. Then, the question is how to connect this data with the original data by making one to many relationship.
@arunkaggarwal1962Ай бұрын
Thanks @enea for this video. I have been using this api for a year to retrieve all the forms results but last few weeks, it stopped working with error 400. Do you have any suggestions / insight what may have changed? Is Microsoft not wanting us to use this API anymore?
@EneaАй бұрын
Need to try it out again, haven’t played with it around since then mate! Would not surprise me though!
@Stevencyw88Ай бұрын
This is a very useful sharing and it support my use case. Thank you so much.
@Simon1997-j7bАй бұрын
Hey guys, I'm new to Power Automate and I want to integrate the Version History of specific items in a Power App. I copied the whole flow and I always get this error: The expression "web/lists/GetByTitle('Listname')/items[1]/Versions" is not valid. This one is with the Power Apps inplementation but it's the same error. I can't get this to work. Does anybody know how to do that? I Changed the list name for this post.
@Simon1997-j7bАй бұрын
Hey, I'm new to Power Automate and my flow always fails at the HTTP connector. Error details are: The expression "web/lists/GetByTitle('Listaname')/items[1]/Versions" is not valid. I used a manual Input and an variable with "1" and I exchanged the list name for this massage. Can anybody tell me why it's not working? If I copy exactly the same way like it this videos it doesnt work as well. Thanks for your help!
@cybersecurity_geekАй бұрын
@Enea Liçaj I have created a sharepoint list item which triggered an email to use via power automate flow i created. Now I want to trigger a follow up email on the existing email trail using power automate. Any idea how I can do it?
@asiffity498228 күн бұрын
You can create another flow with needed email trigger that will trigger this new from from incoming emails. You can search for existing Power automate template flows under 'Templated' section, maybe one of them will do exactly what you need or with little modifications. For example search 'Forward emails to a channel' in template search box and you will see a template to send a teams message when a new email has arrived.
@MateuszSlifirczykАй бұрын
This seems to work when you have just one multi value column. I have 3 and although I have done 3 tables to separate them all, I am unable to use them together for visuals as there's no relationship. The only relationship is to the main table with the key. Creating relationship between those dim tables only allows many-to-many which doesn't really work.
@AmauryVanEspenАй бұрын
Hey Robin ! very nice findings,do you believe that we can feed the choice list from an external API with for example a JSON ? regards. Amaury
@EneaАй бұрын
This is not Robins channel so I doubt he will receive this message. Try reaching out to him on LinkedIn 👍🏻
@davedroputubeАй бұрын
exactly what i was looking for! thank you!
@KomailButtАй бұрын
Hi. What is the difference between "For each" and "Apply for each"? And from where we can get this "For each" option?
@EneaАй бұрын
Its the same mate
@KomailButtАй бұрын
@@Enea I observed it different in one of my project. I was reading pdf files using AI builder (reading table from them) and storing the result like (adding a row into a table). When I used, Apply for each, it was just mixing the rows from different pdfs table, and when I used For each, it literally consider one document at a time, extract all rows from it and add all rows in excel table and then move to next pdf. The problem is now I forgot like from where I took For each in Power Automate.
@shathike4079Ай бұрын
HI Enea, Very Good Explanation, when a file deleted from sharepoint, required approval process to document owner notify approve or reject using power automate. Please make a demo for this
@AlbuquerqueFigueiraАй бұрын
I would like to point to a flow in a different environment than Default one. Where can I set it, cause now it is trying to find the flow in Default env?
@EneaАй бұрын
Didnt you place the ID of your Flow from the other environemnt?
@kyungahkim28Ай бұрын
This is very helpful! Thank you for sharing the information. I have been trying to find the details on connecting multiple MS lists (e.g., using Power Automate Flow), which helps find the information across lists. I would greatly appreciate it if you could share your insights! Thank you so much!
@EneaАй бұрын
Check my content, I have videos on how to sync multiple SP Lists with Power Automate
@kyungahkim28Ай бұрын
@@Enea Thank you!
@garyrowe58Ай бұрын
Great content - but the details on the screen are *really* small ... would be much easier ot follow if you enlarged the text
@EneaАй бұрын
Thanks for your feedback
@unfathomablePSNАй бұрын
Subbed! Great video with some really good tips. Having an icon to trigger the Flow in the List itself is nicer than having Flows stuck in the 'automate' button. Some other good tips in here too, you've given me an idea for another project while I was here as a bonus - GGs
@EneaАй бұрын
Thanks mate, happy I could help! :)
@deborahwilkinson2581Ай бұрын
Is there a video on how to have the link of the content file to show in the SharePoint list?
@EneaАй бұрын
The file is in the list item as an attachment. What link do you want to show? Why don’t just show the attachment column? 🤔
@digomattos93Ай бұрын
Great video, thanks. I found out a built-in power bi function that automatically transforms JSON into columns: "parse JSON" in 'add column' section of Power Query. I think it can be easier than manually split the columns.