Hi everyone! Thank you Darren for a warm welcome! I'm a newbie! I'm offering consultancy to a company to improve their repetitive tasks that they make over microsoft dynamics. They pull various reports from the system in the morning and make one big report for the sales managers in the field. So my first task is to make this process automated. Unfortunately the system manager didn't allow me to have an API access. Still, I have a user access. I was trying to find another reliable way that I can systematically have to those reports and compile in one excel/airtable sheet as they do manually. Not sure if power apps would be helpful for this sort of process. Thanks in advance!

Hi Everyone, I’m working on a project that requires me to populate a word template in PowerAutomate.The columns I need to map are about 52 but word is only retrieving 46 has anyone faced this issue before? Kind Regards,

I have a gallery with a collection of data from the Students Dataverse table and adding a column from the Activities Dataverse table. ClearCollect(lStudent_col, With( { Items: SortByColumns( AddColumns( Students As S , AcummulatedPoints, Sum(Filter(Class_Activities, FK_Attending_Student.Surname = S.Surname), Points) ),"AcummulatedPoints", SortOrder.Descending)} , ForAll(Sequence(CountRows(Items)), Patch(Last(FirstN(Items,Value)), {RowNumber:Value}))); See Image Attached. I have added a Lookup Column to provide me with the State. "State: " & LookUp(Students As S, ThisItem.Email_Link = C.Email_Link, C.State) I need to filter off of all records in that State: Lookup Column with a value of "Inactive". How do I append this filtering to the Gallery?

Hi All, I recently joined an organisation that is starting it's journey with Power Platform.So I have had to create and configure the development ,test and production environments to ensure solutions follow the recommended ALM. I have created solutions and within those solutions I have PowerApps canvas app, Power Automate flows using teams connector.However, every time I try to open the solutions I get the error in the picture and this is not getting me worried as I've tried to troubleshoot but with no success I have tried Clearing my browser data and closed it down Logged out of my account and logged back in Tried using incognito Checked if I have the Environment maker / System Admin role (I have) Also checked if permissions have changed in m365 admin center but nothing has changed None of the above seems to work I would really appreciate your help on this please. Many thanks!

Is anyone here familiar with the 'create csv table' action in power automate? Specifically, the advanced option to sort the columns from the input. I used this flow to do an export of a gallery in my app, but I'm not really sure how to handle the 'Header' and 'Value' options to create the custom column order.