Power Automate - Community Question - Filter and find top scores from multiple lists.

This video explains how to filter and find top record using SharePoint. Also demonstrates how to use parent and child flow.
powerusers.microsoft.com/t5/Building-Flows/Counting-number-of-specific-entries-in-SharePoint-for-a-date/m-p/2279519/highlight/true#M253287
Expressions
variables('AllListScores')?[0]
formatDateTime(utcNow(),'dd-MM-yyyy')
utcNow()
length(outputs('Get_items')?['body/value'])
Date eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

[@salmanriaz5184]

Hi Ajit, I need your help, please. I have four tables: EmployeeInfo, Emp_Salary, Salary_Detail, and a Setup Table called "Allowances_Deduction." Now, the scenario is that I need to create a Payslip for each Employee using an HTML table with calculations for Gross Earning, Gross Deduction, and Net Pay. I'm really stuck on this and would appreciate your assistance. Thanks in advance!

[@abm4975]

Hi @salmanriaz5184 Thanks for your support and query. Is this table located under SharePoint or Dataverse? Thanks

[@y.blaschke4412]

Hey Ajit, i am also really struggeling with attaching a file to a planner task when i have it on my onedrive. Update task details is a bit complictaed I can't get the PDF (OneDrive) file get attached as a copy (not a link) to the Planner Task. I want to open the file directly in the task and not get to the OneDrive folder. 1. When a file is created on OneDrive in the folder "Jobs prepared". 2. Create a planner task which has the title of the OneDrive File. Attach the File to the Planner Task as an element which can be opended directly instead of open the OneDrive Folder. 3. When the Task gets marked as done "the file" must be relocated in the OneDrive folder "jobs done".

[@abm4975]

Hi Thanks for the question. Did you looked into this video?# kzbin.info/www/bejne/raO5fHuuadSLjqc Thanks

[@y.blaschke4412]

@@abm4975 Hey, Thank you so much for your answer!! I have seen your video but i dont want to use Email. I want to start in a sharepoint folder. Thing is - i am able to create a Task in Planner with the name of the sharepoint file and the file as an attachment, but i am not able to open the pdf file in the task. It says, that the file doenst exist or i dont have the permission..

[@abm4975]

Hi Could you connect me via teams. I could look into this. See my channel about section. Thanks