Few Records from MS Teams group chat not being added in the Excel

[Sidhant_02]

Hi everyone,
This is in continuation to my last query which was to post a excel file which contains all the members name from a Teams group at the start of every week automated task. But now I am facing one small issue which is new members that were added in the group later, their names are not being reflected in the Excel which is being shared by Power Automate scheduled flow every week on Monday morning, but all the names are properly getting extracted when the same file is being created on my OneDrive i.e. it contains all 59 members but in the Teams channel I am only able to see 50 records rest of the 9 records are missing.
So I removed the missing names from the Teams group (which is the source from which Power Automate adds the team members) and then added them again, in the flow I am able to see all the members (appending in the OneDrive excel) but when I am creating the same file referencing the same file it is missing last 8-9 records


The file shared in teams channel is missing last 10 records

In OneDrive I am able to see all the members:

So I am not sure what is going wrong here?.
This is the flow:

Please let me know how to resolve the following issue.

Regards,
Sidhant.

[Pstork1 · Accepted solution]

When editing an Excel file in a flow and then using it to create a new file there is some latency involved.  I suspect that is what is happening here.  Try adding a 1 minute delay between the loop that adds the rows to the Excel file and the action that gets the content and creates the new file in Teams.  If that works you can try shortening the delay.

[Sidhant_02]

Hi @Pstork1 ,
Like this:

[Pstork1]

Yes, That should give enough time for all the records to be committed to the file before you pull the file content.

[Sidhant_02]

Thanks @Pstork1 ,
Now I am able to see all the team members list as per the group size (which was 59) 

Just had one question is there a way that the excel sheet that is shared in Teams channel and OneDrive there is proper alignment between all the columns (currently I need to manually set it)
Actual: (What I have)

Expected:

Regards,
Sidhant.

[Pstork1]

When you look at a flow run are the email addresses included in the data you get back from the List Team members action you are doing?

[Sidhant_02]

Yes, I am able to get the Email for all users (previously I was just retrieving the SNo and Name) but now I have also added the email attribute to be added in the Excel (in the loop). Forgot to mention that in my last reply.
Now just want to know is there a way that we manage the styling (like column width) currently I need to manually resize the column, you can check my last reply for the image to know more.

Regards,
Sidhant.

[Pstork1]

I'm not aware of any way to manage the column width inside the flow.