You’re offline. This is a read only version of the page.
Announcements
Hi all,
I am trying to connect my .xlxs / csv file as a data source for a Model-Driven-App. Since I followed the docs provided by PowerApps, everything runs perfectly until the penultimate step "Refresh settings". I always encounter the error "We encountered an unexpected error." regardless of the typing (xlxs or csv) of data source. Below is the Mashup text I received:
section Section1;
shared Query = let
Source = Csv.Document(Web.Contents("CORRECT-FILE-PATH/Documents/MOCK_DATA.csv"), [Delimiter = ",", Columns = 6, QuoteStyle = QuoteStyle.None]),
#"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
#"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"id", Int64.Type}, {"first_name", type text}, {"last_name", type text}, {"email", type text}, {"gender", type text}, {"ip_address", type text}})
in
#"Changed column type";
Also, here is the Session and Request ID:
Hi @tienvu1402
You can't directly connect to a source other than DavaVerse tables (formerly CDS) to a Model Driven app. You can however embed a canvas app inside of Model driven app. The embedded canvas app can be connected to another data source. For the details of how this is done, see https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embed-canvas-app-in-form
Share
Report
All responses (
Answers (
721
