Dataverse table question

[Syndicate_Admin]

I'm trying to create error handling and notification for Power Automate cloud flows using the Dataverse tables via Dataflows. I am querying the flowsession table (to get failures) and the workflow table (to get the cloud flow names), but flowsessionid does not equal workflowid. Does anyone know how to either a) connection these two tables or b) get the name of cloud flow into the flowsession table? Pls and thanks.

Also, I can see that when I click on [Record] in the workflow column in the flowsession table the workflowid is there but I don't know how to access it.  

[v-jingzhang]

Hi FreeRangeDingo

You can add a custom column to extract workflowid field values from the workflow records. Record.Field - PowerQuery M | Microsoft Docs

Record.Field([workflow], "workflowid")

To get the name of cloud flow into the flowsession table, you can use Merge queries feature. Select the common workflowid column as the matching column. Merge queries overview - Power Query | Microsoft Docs 

This should work well. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Syndicate_Admin]

I'm almost there.  You showed me how to add a custom column. I created the custom column and joined successfully.  Now, I needed data from the "other" table in my join.  I assume the answer is that I need another custom column.  I know that I will need a Table function rather than the Record function.  I checked out Table functions here - https://docs.microsoft.com/en-us/powerquery-m/table-functions - but everything I create gets an error, and the descriptions of the functions don't make a lot of sense.  Here are some screenshots. 

Thank you very much for your help so far.  I'm almost there!

[Syndicate_Admin]

That looks extremely promising.  Can't wait to try that out later today.  Thank you!