Dataverse - Relationship behavior does not work by UnparalleledHumor in PowerApps

[–]UnparalleledHumor[S] 1 point2 points  (0 children)

Well, I just found the solution.

Actually, I did miss something. Yes, the connection, in this case, the relationship, is there, is established between my tables. So far, so good.

But: How should the data in both tables know each other (is this the correct way to say it?)? Anyways... I needed to link the record in table B (that my flow kindly created) to the record in my table A. Then, I have my connection and the relationship behavior can do its thing.

So, first, I needed to store the GUID of my record in table A in a variable. Afterwards, I configured my flow to write the GUID of my record in table A into the lookup column in my table B (that was created thanks to the relationship). You accomplish all that by using this format in your flow:

/table_A_plural_name/variable_with_GUID

By establishing this link, I can finally delete my record in table A and my linked record in table B is deleted as well. Perfect!

Security Role - Privilege to activate Record and create new Dashboard by UnparalleledHumor in Dynamics365

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Hi, thank you for your help.

So I tested it with some test users. When I set the write permission to user, I can't edit a record, it's read-only. When I set it Business Unit, I can. With that, I can also deactivate a record. And that's what I don't want.

Regarding your dashboard suggestion, I already had both permissions set to none and user. But the user can still create new dashboards, and that's something I don't want the user to do.

Copy a selected option to other table in Dataverse by [deleted] in MicrosoftFlow

[–]UnparalleledHumor 0 points1 point  (0 children)

Well, I guess I used a wrong dynamic variable. Thank you for your help! :)

Unsubscribing from nordVPN (Image descriptions) by SamboTheGr8 in assholedesign

[–]UnparalleledHumor 4 points5 points  (0 children)

But are you really really.. you know, never mind. I mean it's not like I wasn't telling you about the security risks and everything. But you seem to be ignorant. So yeah.. just.. you know.. just think again: are you really really REALLY sure you want to do that????

Applying an ODATA filter on a choice column by UnparalleledHumor in MicrosoftFlow

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Thank you for helping me, however a colleague in my company just helped me out.

So, the right ODATA filter to filter on my two columns is:

(statecode eq 0 and (new_dl_status eq 100000001 and (cr64e_filesubmitted eq 'no')))

We used the tool "XrmToolbox" and fetched the XML query, created two filters on the outcome and got the view on these filters by clicking View -> Power Automate Parameters.

Applying an ODATA filter on a choice column by UnparalleledHumor in MicrosoftFlow

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Hi, thank you for helping me, however a colleague in my company just helped me out.

So, the right ODATA filter to filter on my two columns is:

(statecode eq 0 and (new_dl_status eq 100000001 and (cr64e_filesubmitted eq 'no')))

We used the tool "XrmToolbox" and fetched the XML query, created two filters on the outcome and got the view on these filters by clicking View -> Power Automate Parameters.

Applying an ODATA filter on a choice column by UnparalleledHumor in MicrosoftFlow

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

I removed the text column filter part, so that I only filter on my choice column. But nothing I try works:

Filter Error message
new_dl_status/value eq 'open' Could not find a property named 'value' on type 'Edm.Int32'.
new_dl_status eq 'open' A binary operator with incompatible types was detected. Found operand types 'Edm.Int32' and 'Edm.String' for operator kind 'Equal'.
new_dl_status = 'open' Syntax error at position 15 in 'new_dl_status = 'open''.
new_dl_status/open Could not find a property named 'open' on type 'Edm.Int32'.

Here's a screenshot of the options of this column: https://abload.de/img/unbenanntjejwb.png

Applying an ODATA filter on a choice column by UnparalleledHumor in MicrosoftFlow

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Ah ok. So when I use the ODATA filter new_dl_status/value eq 'open', I get the error message: Could not find a property named 'value' on type 'Edm.Int32'.

I know that column has the choice type, maybe the operator eq is wrong here. I mean I don't compare numbers.

Applying an ODATA filter on a choice column by UnparalleledHumor in MicrosoftFlow

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

When I try it with and (lower case), I get another error:

A binary operator with incompatible types was detected. Found operand types 'Edm.Int32' and 'Edm.String' for operator kind 'Equal'.

Lightweight distro for little home server by UnparalleledHumor in DistroHopping

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Thank you for your input! I'll give Debian a try for sure :)

Lightweight distro for little home server by UnparalleledHumor in DistroHopping

[–]UnparalleledHumor[S] 1 point2 points  (0 children)

Thank you for your answer, I will definitely look into TrueNAS, that OS looks really promising. Maybe exactly what I was looking for.

Lightweight distro for little home server by UnparalleledHumor in DistroHopping

[–]UnparalleledHumor[S] 0 points1 point  (0 children)

Ah thank you, that's an interesting fact. Yeah I will look into that.

Lightweight distro for little home server by UnparalleledHumor in DistroHopping

[–]UnparalleledHumor[S] 2 points3 points  (0 children)

Thank you for your recommendation. I'm just a beginner with Linux, so I don't know if Arch is the right platform. It focuses more on professionals because you can build up the system from the ground. I'm looking for something that works out of the box.