Hello,
Have a private MS Teams channel that I need to write a dynamic Excel table to. From my research it indicated that the Power Automate Excel function does not allow writing a dynamic Excel table to a private Share point channel folder.
My workaround was to write the dynamic Excel table to a different Share point site file (File A) and then copy that File A to the private channel folder (File B). It worked except ... File A has all the records from the dynamic Excel table 👍 but File B only has the heading and first record from the dynamic Excel table 👎.
I am thinking that I need to put in some type of loop that checks if all of the dynamic Excel table records are written to File A first before the copy of File A to File B is initiated. Thoughts or other approaches on how to get this to work?
THANK YOU!!!
