Good Day,
I am new to Power Automate and i am trying to create a notification flow that will be triggered onselect of a button in power apps.
I have the primary contact and secondary contact saved for different departments to my dataverse table for a particular ID, I want to be able to click a button in my power app that will trigger the flow such that within the flow i want to look at my dataverse table and filter the records i have in my table that matches that ID on the screen and send an email notification to each of the emails saved. I am having difficulty understanding how to get the specific items from my dataverse table within the flow.
I will appreciate any help i can get to help me achieve this.
Hi @v-chenzhi
Thanks for clarifying that out for me, However, i am having an issue in the Filter Row part of the List Row.
I have a table called Table A with some data in it and when a new record is created in Table A, i want to trigger my flow to Filter Table B where Column B (In Table B) equals Column A (in Table A).
In the filter Row column i wrote my Filter condition as seen below
The BLUE underlined internal column names is from Table B while the RED underline column is from Table A. When i try to run my flow i get this error message notification: Could not find a property named 'Central' on type 'Microsoft.Dynamics.CRM.cr2b1_Table B'.
How can i go about this? i will appreciate any help i can get.
Thanks
Advok8
Hi @Advok8 ,
Do you want to filter the dataverse in flow based on the ID selected in the app?
Could you please show me your dataverse table.
I assume you have two columns in dataverse like this and have a test for your reference, please try the following workaround.
I add a record like this.
I add a Button like this in canvas.
Receive such an email notification.
Best Regards,
Zhi Chen
Hello @Advok8,
There is an option called List Rows, you can use the same. You can find screen shot for your reference.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
WarrenBelz
146,631
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,976
Most Valuable Professional