Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More

© Jeffrey M. Rhodes 2019

Jeffrey M. RhodesCreating Business Applications with Office 365https://doi.org/10.1007/978-1-4842-5331-1_12

12. Power BI Challenges with JSON, XML, and Yes/No Data

Jeffrey M. Rhodes¹ 

(1)

Colorado, CO, USA

 

Adding in multiple answers, multiple lines of text, and Yes/No responses leads to some additional challenges. For example, we did an IT Demographic Survey of all our academic personnel at the Air Force Academy. I used the same technique as the previous chapter to copy each response to a SharePoint list using Microsoft Flow. We see the first inkling of an issue when we look at the data in SharePoint as shown in Figure 67. The extra explanatory text after Level 4 gets copied (since it was part of the answer). More significantly, ...