dataverse relating rows in a loop

Like (0) Share

Report

Posted on 2 Sep 2022 17:06:38 by nick9one1

281

I have a table populated with rows that I would like to list and duplicate on the first of the month.
Two of the columns are related to other tables

Can I set the relationship directly in the create new item step?

All responses (3)

Answers (0)

AbdulWahab 517 on 02 Sep 2022 at 18:57:49

Like (0)

Report

Re: dataverse relating rows in a loop

Hi nick9one1

Yes, you can create relationships directly in the create new item step. Here is the format to set the lookup column value /entityNameDefinedINWebAPIEndPoint(GUIDofTheRecord)

Let me know if I can provide you with more details.

Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
nick9one1 281 on 02 Sep 2022 at 18:15:15

Like (0)

Report

Re: dataverse relating rows in a loop

something like this

but I dont want all evidence rows, only the ones that have a relationship to the current item.
How would I filter this?
nick9one1 281 on 02 Sep 2022 at 18:11:14

Like (0)

Report

Re: dataverse relating rows in a loop

I've mad a little progress with this.
I couldn't seem to set the relationship directly in the new item step so I did it with a 'relate' step.

there are three relationships in total. two are one to many and the third is many to many.

The first two work, but I'm a little unsure on how to relate the third. I guess I need to loop again?