How to have dynamic xy map background image according to different sets of coordinates

[JamesZuo]

hi,

I have a table where in column H it contains different types floor (floor "M1" and floor "S0"), and i want my xy coordinates column I to have a dynamic background floorplan image, where if it's "M1" floor, the coordinates should show based on background image M1-floor.jpeg, and "S0" on S0-floor.jpeg... 

I've been working on this puzzle for a while now, really appreciate anyone's help to 

[Suvrutt_Gurjar]

You could try in the "Background image for the XY coordinates"  setting of the XY column an expression something like 

IFS([Floor]="S0", "S0-floor.jpeg",

       [Floor]="M1", "M1-floor.jpeg"

       )

[JamesZuo]

Thanks Suvrutt_Gurjar for the solution, this is already what i've been trying but to no success...i just cannot figure out what's the issue...

This is the setup in google sheet "Map" tab:

And i want to 'link' it to the database:

So, in Appsheet:

However in Appsheet, it's still showing no map at all:

[Suvrutt_Gurjar]

Thank you. Please try with 

IFS([HFB]="M1",  ANY(SELECT(Map[Map_Image], [Map Name]="M1")),

        [HFB]="S0",  ANY(SELECT(Map[Map_Image], [Map Name]="S0"))

      )

I observe that in the screenshot of the table you have shared, the data M1 and S0 is in the column name [Floor] but in the expression, you seem to be using [HFB]. You may want to confirm [HFB] is correct.