Answered

Collect in a map

(1) Share

Report

Posted on by Rober1

I try to create a collection that select in a map the selection in ComboBox1 and 2 rows in tabla1, but my code didn't run

Need Help 🙂

Navigate(MapScreen1; ScreenTransition.Fade) &&
ClearCollect(
colLocations;
ComboBox1.SelectedItems &&
First(Tabla1);
LookUp(Tabla1; RowNumber(Tabla1) = 31);
LookUp(Tabla1; RowNumber(Tabla1) = 32)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

developermct 37 on at

Like (0)

Report
Copy link

Link copied!
It looks like you're trying to use Power Apps to create a collection based on selections from ComboBox1 and specific rows from Tabla1. The ClearCollect function is a good choice for this, but the syntax you're using seems to be incorrect. The && operator is not used for combining collections in this context.

Here's a revised version of your code that should work:
Navigate(MapScreen1, ScreenTransition.Fade);

ClearCollect(
colLocations,
ComboBox1.SelectedItems,
First(Tabla1),
LookUp(Tabla1, RowNumber(Tabla1) = 31),
LookUp(Tabla1, RowNumber(Tabla1) = 32)
);
In this version, I separated the Navigate and ClearCollect functions with a semicolon, which allows you to execute multiple functions in sequence. Inside ClearCollect, I used commas to separate the different items you want to collect.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Rober1,

I think you have to provide more details about your need.

The way you generate the collection is wrong at some degree, ComboBox1.SelectedItems returns a column named Value, however, First(Tabla1) returns a single record including all the columns from Tabla1, so do the left 2 records returned by the LookUp() function.

Finally, you will get a collection as below:

Not sure if it is what you want, however, if it is, you need to modify your formula as below:

Navigate(MapScreen1; ScreenTransition.Fade);; ClearCollect( colLocations; ComboBox1.SelectedItems ; First(Tabla1); LookUp(Tabla1; RowNumber(Tabla1) = 31); LookUp(Tabla1; RowNumber(Tabla1) = 32) )

Was this reply helpful? Yes No
Rober1 18 on at

Like (0)

Report
Copy link

Link copied!

When I click on the button, it takes me to the Map Screen1 page, where I have a map with the points selected by comboBox1. What I need is to always have two fixed points displayed from table1, which are the starting point and the ending point of the route (and they are always the same and fixed).

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @Rober1,

"What I need is to always have two fixed points displayed from table1, which are the starting point and the ending point of the route (and they are always the same and fixed)."

I don't get it, and I could not imgine the data set on your side, you should provide more details to let me know how you want to save the data in the collection.

Was this reply helpful? Yes No
Rober1 18 on at

Like (0)

Report
Copy link

Link copied!

This is Tabla1
When I click on the button, it takes me to the Map Screen1 page, where I have a map with the points selected by comboBox1. What I need is to always have two fixed points displayed from table1, which are the starting point and the ending point of the route (and they are always the same and fixed).

I try this, and i think that this code is correct

Navigate(
MapScreen1;
ScreenTransition.Fade);;
ClearCollect(
colLocations;
ComboBox1.SelectedItems;
First(Tabla1);
LookUp(
Tabla1;
'Denominación OT' = "Inicio Ruta"
);
LookUp(
Tabla1;
'Denominación OT' = "Final Ruta"
)
)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

HI @Rober1,

Well, this formula is the modified one I gave you before.....

You replace the parameter in the LookUp() function apply to your need, which is greate.

Was this reply helpful? Yes No