Unanswered

Cannot connect Gallery to Form

(0) Share

Report

Posted on by comeafteralone

Hello,

I have a Gallery1 that was linked to Power BI dashboard via PowerBIIntegration. My Gallery is displaying 4 fields: MAP ID, MAP Title, MAP Description, and MAP status.

I then added a Form and connect the form to a Data Source named Table 1, which is the same source where my Power BI Dashboard is built on. I added 3 fields from Table 1 to the form: MAP ID, MAP Title, MAP Status, Remarks.

I want to connect Form to Gallery by using Gallery1.Selected but it gave me an error (Invalid Formula. Expected a value compatible with Data Source).

I then tried using put in the Item property of the form this formula Lookup('Table1', ID=Gallery1.Selected.ID) but that didn't work either.

Can anyone please help??? I've been stuck at this step for 2 days straight

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

So.... I think that the problem is that you are using 2 different data sources. Even they are the same table, it assumes that they are different.

What you can try to do is set the datasource of the form to your DataSource and write this on item Property:

Lookup(OriginalDataSource, ID=Gallery1.Selected.ID)

You can also use the form with the PowerBI DataSource, add the fields and sue Patch function to patch them to the original datasource.

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-patch

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
comeafteralone 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Nogueira1306 for your response!

I was suspicious that the PowerApps recognizes my Data Source as 2 different sources too.
In my original data file (Excel file on One Drive), I formatted it as table. But afterwards, when loading to Power BI, the data shows up as a new table (Table 1) and my original sheet (called MAP).
When loading to PowerApps, the apps only recognize Table 1.
Honestly I am not sure what is going on...

Currently, both my BI Dashboard and my Apps are connected to Table 1, but again, it is being recognized as different databases.

I was trying your suggestion with this formula Lookup(OriginalDataSource, ID=Gallery1.Selected.ID) -- I should be changing OriginalDataSource to the name of my source, which is Table1, is that right?? --- but no luck so far 😕 😕

Was this reply helpful? Yes No