Hi everyone,
So i have two Sharepoint lists.
I manually set up primary/foreign key (as Sharepoint lists are no relational db) with a column called Event_ID that is of string type (example of a value: EV-123456)
The relation between both tables (lets say table A and B) are from one-to-many.
Example:
Table A has got a unique event called EV-123456, in table B there are several Milestones of this event. The key is Event_ID as said before.
My objective is the following:
I am creating a flow that triggers when something changes in table B (Milestone table).
Then i want to write an Email that contains both information of table B AND of Table A.
For example:
"The following Milestone has been rescheduled.
Information of Milestone:
(data from table B)
Information from main event:
(data from table A)"
My issue:
I know that there is only ONE main event (one record in table A) that is associated to the Milestone that is updated.
Nevertheless, i see myself using GET ITEMS because Power Automats because in the ID input of GET ITEM, it does not allow me to put my primary/foreign key (Event_ID).
It bothers me to use GET ITEMS because, afterwards, when sending a mail, Power automate inserts the apply to each function. I understand why it does that but i know that there will always only be one record for that Event_ID.
I tried using a variable that take the Event_ID from Table B and use it as the ID in GET ITEM but it must be an integer..
Is there a way around this? i would hate to create a second key that is numerical only so that Power Automate allows me to apply GET ITEM..
Thank you in advance!
