Answered

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

(0) Share

Report

Posted on by Sidhant_02

986

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.

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Pstork1 68,326 Most Valuable Professional on at

Like (1)

Report

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

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.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

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

Hi @Pstork1 ,
Like this:

Was this reply helpful? Yes No
Pstork1 68,326 Most Valuable Professional on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Pstork1 68,326 Most Valuable Professional on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Pstork1 68,326 Most Valuable Professional on at

Like (0)

Report

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

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

Was this reply helpful? Yes No