Power Platform Community Forum Thread Details

I have this self made pivot table since real pivot tables don't link with power automate and I was hoping I could link it to automate an email to say how many "open" each person has, "open overdue" each person has, ect. but I need it to be a table format which isn't allowed because of the formula used. Is there anyway around this?

- this is the formula I used in excel. When I try to make it a table I get this error -