I have some questions about loading Excel data into CDS.
Project background: I wrote a large PowerShell script to automatically create / update Dynamic Distribution Lists (DDLs) in Exchange Online based on our organization's management hierarchy. Each manager gets several groups as well as departmental groups that include all staff and another that includes just leadership in that department. For those unfamiliar with Dynamic distros, Outlook can't show you the membership of a DDL the way it does for a normal distro, because it uses rules based on user's profile attributes (such as Dept=Accounting, ManagerID=123456, etc) and dynamically finds users that match the criteria when the email is sent to the DDL. That being said, I currently run a report once a week using PowerShell to pull a snapshot of group membership and export it as a CSV which I then convert to an Excel Table that has about 18,000 rows of data.
I've uploaded that Excel Table into a CDS entity and built a PowerApp to allow my end users to look up people to see what groups they are members of and look up groups to see who their members are.
Now I'm looking into automating my process of getting that data file uploaded to CDS so I don't have to do it manually on a weekly basis.
Now that history is laid down, on to my questions:
1) Automap doesn't work when I walk through these steps. What can I do to fix that? I tried naming my columns in the Excel table after the custom destination field names, but that didn't seem to help. Is there anything I can do to make Automap work?
2) I see that Import from Excel into CDS has the option to auto refresh that data on an interval. This seems like a cool thing, but once it's configured I don't seem to have any control over making changes to that interval or even setting it back to manual only. Is there some place to change these settings or does walking through all the steps a second time overwrite existing settings? I had an issue where yesterday I was demoing the app and some kind of data load / refresh was happening in the background and it caused some issues with missing data during the demo that showed back up after a while.
Thanks!
