Power Platform Community Forum Thread Details

Hi,

I am a newbie to Power Automate but I do have access to it at work. I was trying to automate a process where I have an excel file that has a column with user's full name. For each user I would like power automate to take the full name and go to Power BI and check if the name exists in dropdown (leader name) and if yes click on a button to download the report then move to the next user. If not found maybe capture that the user was not found (haven't figured out how to handle this yet). The reports have been developed in Power BI and I don't have access to the dataset. I have tried using some of the Power BI templates to query the Power BI dataset but have not been successful. Not sure how I should be approaching this. Any insight provided would be helpful