Hello @Sbsyx,
Use the old designer to paste this code into a dummy flow (manually triggered) to see how it works.
{"id":"9deb2881-86ce-4f41-8824-cede1c662020","brandColor":"#8C3900","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-b959cb53-5ecb-4b41-805f-06e7795a0bd2"}},"shared_teams":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_teams/connections/da0f4068677c48aba01f0613c77dcb5b"}},"shared_conversionservice":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_conversionservice/connections/shared-conversionser-c02d19aa-75cf-44e4-b0f1-c36e677a6a16"}},"shared_commondataserviceforapps":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_commondataserviceforapps/connections/62947705b1a746319ca1e59aae985afc"}},"shared_office365users":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365users/connections/60ec96ba306e4804b12d17065506e219"}},"shared_office365groups":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365groups/connections/shared-office365grou-a1427af6-957f-485c-9c2a-98f30090bcf9"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Scope_join_two_tables","operationDefinition":{"type":"Scope","actions":{"Compose_sale":{"type":"Compose","inputs":[{"contractor":"Jary","ID subscription Microsoft":"A789-98755-F5675","Sale":19.58,"subscription end":"9072-08-29"},{"contractor":"Ralfston","ID subscription Microsoft":"87C9-98755-F5675","Sale":1.04,"subscription end":"19630-09-02"},{"contractor":"Hedve","ID subscription Microsoft":"8789-98E55-F5675","Sale":5.56,"subscription end":"5037-08-28"},{"contractor":"Freddi","ID subscription Microsoft":"87W9-98755-F5675","Sale":10.23,"subscription end":"6851-04-09"},{"contractor":"Diann","ID subscription Microsoft":"878P-98755-F5675","Sale":3.52,"subscription end":"16159-03-05"}],"runAfter":{}},"Compose_subscription":{"type":"Compose","inputs":[{"Country":"Oman","ID subscription":"A789-98755-F5675","User number":646},{"Country":"Syrian Arab Republic","ID subscription":"87C9-98755-F5675","User number":220},{"Country":"Norway","ID subscription":"8789-98E55-F5675","User number":815},{"Country":"Tokelau","ID subscription":"87W9-98755-F5675","User number":574},{"Country":"Namibia","ID subscription":"878P-98755-F5675","User number":641},{"Country":"Antarctica","ID subscription":"8789-98755-F5675","User number":90},{"Country":"Cook Islands","ID subscription":"8789-9875O-F5675","User number":819},{"Country":"Western Sahara","ID subscription":"87Z9-98755-F5675","User number":949},{"Country":"Spain","ID subscription":"8789-9875Y-F5645","User number":558},{"Country":"Jamaica","ID subscription":"878Z-98755-F5675","User number":991}],"runAfter":{"Compose_sale":["Succeeded"]}},"Compose_subscription_xml":{"type":"Compose","inputs":"@xml(json(concat('{ \"root\": { \"array\": ', outputs('Compose_subscription'), '}}')))","runAfter":{"Compose_subscription":["Succeeded"]}},"Select_version1":{"type":"Select","inputs":{"from":"@outputs('Compose_sale')","select":{"contractor":"@item()['contractor']","ID":"@item()['ID subscription Microsoft']","Sale":"@item()['Sale']","subscription end":"@item()['subscription end']","Country":"@first(xpath(outputs('Compose_subscription_xml'), concat('root/array[ID_x0020_subscription=\"', item()['ID subscription Microsoft'], '\"]/Country/text()')))","User number":"@float(first(xpath(outputs('Compose_subscription_xml'), concat('root/array[ID_x0020_subscription=\"', item()['ID subscription Microsoft'], '\"]/User_x0020_number/text()'))))"}},"runAfter":{"Compose_subscription_xml":["Succeeded"]}},"Select_version2":{"type":"Select","inputs":{"from":"@outputs('Compose_sale')","select":{"Sale":"@item()","Subscription":"@json(first(xpath(outputs('Compose_subscription_xml'), concat('root/array[ID_x0020_subscription=\"', item()['ID subscription Microsoft'], '\"]'))))['array']"}},"runAfter":{"Select_version1":["Succeeded"]}},"Select_version3":{"type":"Select","inputs":{"from":"@outputs('Compose_sale')","select":"@addProperty(item(), 'Subscription', json(first(xpath(outputs('Compose_subscription_xml'), concat('root/array[ID_x0020_subscription=\"', item()['ID subscription Microsoft'], '\"]'))))['array'])"},"runAfter":{"Select_version2":["Succeeded"]}}},"runAfter":{}}}
You will have to press "Ctrl+v" if you are on the "My clipboard"-page.
I created 3 versions. Choose the one you like the most.
version1 has more code but also the conversion back to a number included.
version2 and 3 are almost the same but have a different layout. They use less code and will work the same even if you are joining more columns.
