Hi, Instead of sending teams notification I am trying to add a new row in dataverse but triggerOutput() returns error that it accept the object instead string and int
Really useful video ... I started trying to detect a new record using the "SharePoint method" ie. Create On = Modified On ... which doesn't work in dataverse. Your video provided the answer. Thanks.
Hi! Do you know what licenses would be required to use such an app with tables from 2 environments? I imagine one power app per app will be not enough here
Having abit of trouble trying to send an email to the user who modified the row. I cant find a way to extract the email address of the user. The get row by id on shows modified user (value) and i cant run this through the get profile as it needs a UPN? Is there a way to get this to work?
Power Automate trigger post changes therefore don't have old values However you can track old information through audit history. Sharepoint list has audit history and you can use the action item "Get Changes for an item or file", if you are using dataverse then make sure Audit is turned on. Other option is you have to have plugin to capture pre and post changes
Great video. I have a flow in my dataverse environment and am using the When a row is added, modified or deleted trigger. I want it it to trigger when a specific field is modified to a specific value OR a record is added [and that specific field has that value]. I use the 'Added or Modified' change type; I updated the advanced features to use the select columns (statuscode). and a filter of statuscode eq 100000001. This triggers if the record exists and the status is changed to that value. But if the status code is set to that value and THEN the record is created, it does not trigger. Any ideas?
It should trigger however I would suggest that use the trigger condition and it will trigger only when condition met, in above scenario it will trigger but won't perform any action. Please check below document how to apply trigger condition powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-made-EASY/ba-p/441348
Great video, Syed! I am trying to have a log of data that is modified in a table in dataverse, where when one modifies a column data in a different table (Let's say that this table has "Initial", "Processing", and "Finished" choice columns): Power automate to record the change of the old value and what the new value is in the log table. In your video I saw that for deleted product, you have the GUID. Is there a way to automate the task I said using the GUID or is there a better alternative? Thanks!
Hi Shamly, Dataverse has its own Audit History, you can turn on the Audit log in Dataverse. It is not a good idea to delete the record, best practice is to deactivate rather delete. Once you delete then you have nothing other than GUID which in my opinion is not that helpful other than you have to delete the record stored in somewhere else e.g. SQL or mySQL that contain the Dataverse GUID for reference
Hi Syed, thanks for this video... you've saved me some money using it instead of pdf connector from Adobe. I have a particular problem with a multiline field. When I see the output of the Json each new line appears as /n, but when it populates in the word file, all the text appears just in one line...
@@neusoltechnologies144 Hi, There is no option to add existing dataflows to solution.. Looks like the dataflow option is removed. Could you please check if you the option to add dataflows to solution? Thanks.
@@neusoltechnologies144 No it is not. The option to dataflows has been removed by Microsoft. Currently, the options are Cloud Flow, Custom Connectors, Desktop flow, Dialog & Process.
@@samsiva2004 It is very interesting, I can still see that option. And if I am correct you are using Add existing option, correct? If you share your email then I can send you a solution that have dataflow in it and you check to add more in that solution
Good article.. but it will not work if we have filters, in case if some one deleted the item in between Indexed key will be changed and it will not work in that scenarios
Hello nice video, I would like to ask If I want to notify the same to Owner of the record how to do that?? Because unable to get the email address of record. any workaround??
Scope can set based on rows ownership, if you want to limit to User then actions will be taken on rows owned by you, you can set on business unit or action on any change on environment level i.e. Organization. Hope that will answer your question.
@@neusoltechnologies144 but that's the core of your solution isn't it? Not only do you have to maintain the column but it may not tally with the position of an item on the list. In other words, an nth item will not necessarily have n in the IndexKey column which I think is necessary for the logic to work.
Could u help me understand how to generate pdf from a dynamic html? Inhave a SharePoint list which has a column for RTF and has to contain images and text dynamically, how do I convert this column to PDF?
Do you have sample or video that show how to pass the filters from powerapps to the flow? There are 4 dropdowns in your powerapps, but there's no demo showing how to pass those dropdown values to the flow.
Hello digital 5s can you please help me to build this power automate flow :'( I need to build a Power Automate flow that extracts data from a Power Bi report (csv or xlsx) and places the extract in a Sharepoint folder. The flow should be launched automatically every day. I have already created a button in the Power Bi report. When we click on this button, an extract is placed in the Sharepoint folder, but I don't know how to make this flow a scheduled flow. Can you please help me to find a solution for this flow ?
Can I use Power Automate to maintain a Dataverse database? For example, I put an excel with a list of products in a directory and Power Automate is able to insert these values into the Dataverse?
Hi, I've created a PowerBI report from a KPI/Goal scorecard, however the status shows up as a number rather than the status such as Ontrack, finished, not started etc. How can I have the status in my powerbi report???? thanks
You can create a new column and use the switch function Status Value = SWITCH('Values'[Status], 1, "On track", 2, "At Risk", 3, "Behind", 4, "Overdue",5, "Completed", "Not Started")
@@neusoltechnologies144 Thanks for the reply , I dont seem to be able to create a new column online or desktop. I cannot view the data table as I normally would?
@@mudda1994 Step1. Create a new Power BI file with one standard table in Power BI desktop Step2. Go to File menu->Options and settings->Options->Preview features and check the box DirectQuery for PBI datasets and AS if that is not already checked Step3. Bring your Power BI scorecard dataset in there Step4. You should be able to create new column in your datamodel and create the column that I provided you earlier
I think most people looking to do this don’t want to use premium connectors, also it might be worth investing in a better quality mic as the voice over is very tinny. Sorry to seem critical thanks anyway..
Hi Vankatesh, Did you create 4 different Power Automate flows and creating 4 pdfs? If yes, you may look for merge pdf action item, Adobe and Plumsail provide feature to merge multiple pdfs into one
7:22 <-- When I get to this point, only the primary column and owner shows up for editing. The others cannot be set, same for when I edit a record. Do you know why? Thanks!
Would you think that Goals would be good for 100+ metrics? Additionally, could you have different formats like percentages, yes/no results, etc.? Lastly, how do you think an executive would use/access this?
1. yes, I don't see any issue having 100+ metrics, if I understand correctly 2. Currently formats is predetermined in Goals and it is in Public preview. There is more flexibility in future roadmap. Please check on Power BI site for details 3. You can share workspace or share on Teams, outlook or provide the link to scorecard same way you share the Power BI reports
I'm trying to replicate this but I cannot see Dynamics-related table names (ie Products) and there is a D365 instance in my tenant (if I use "Fin & Ops" connector the D365 instance is showed for selection), someone knows what is needed to make D365 tables/entities appear in the drop down such as in this video ?
Fin & ops ask you for the environment and Dataverse connector aren't. Make sure you create Power Automate flow in the same environment where D365 tables reside