Unanswered

Create table relationships, SQL Azure

(0) Share

Report

Posted on by hilary_stoupa

421

I can connect to SQL Azure and write data to my table. How do I relate a second table? For example, if I were creating an expense report, I'd have one table with the main report info (dates, employee name, business purpose, etc) and then a second table with the details (individual expense line items).

Also - is there any documentation on what data types are supported? I am getting an "Error adding datasource. Please try again later." when attempting to connect to some tables & am trying to understand if it is an issue with a data type or something else. Does PowerApps log extended error info anywhere so I can find out why I can't connect to a given table?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

rc on at

Like (0)

Report

Hi! You might find this reference doc a good starting point for tables in general: https://powerapps.microsoft.com/en-us/tutorials/working-with-tables/ and there is some specific content on using lookup between tables here: https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

Also, some information on errors: https://powerapps.microsoft.com/en-us/tutorials/function-errors/

Hope these are helpful starting points!

Was this reply helpful? Yes No
hilary_stoupa 421 on at

Like (0)

Report

Thank you. The content on lookups had a comment from a few days ago that says joins aren't currently a feature, so that answers that question.

The error I'm wondering about is when I create a data connection - I didn't see anything in the function errors info you linked to on that. Do you know if there is any documentation specifically on allowed SQL Azure data types, or any way to find out the root cause of an error creating a data connection to a SQL Azure table?

Was this reply helpful? Yes No