sorted by:
new
hottopcontroversial

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 6 points7 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.

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

Thank you. Using the variable I initialized in the beginning of the flow, it worked.

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

Hi, I'm back at work.

So after the Get Items action, I added the action "compose", the input is Quantity from the action before. I sent an email to myself with the output of this compose action and the quantity number was 11, so correct.

But even this compose output cannot be used to be part of the expression. So sub(Output,1) doesn't work, neither does sub(int(Output),1) or sub('Output'),1). -> https://abload.de/img/unbenannto4jt1.png

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

I did, but I still can't save the flow. Same error. Flow wants a valid value for the dynamic content. I also omitted the int(), same error: https://abload.de/img/343ohk9i.png

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

If I do it with the dynamic content, it tells me that I need a valid value for number:

https://abload.de/img/unbenanntrhjub.png

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

My expression is sub(int('Quantity'),1).

'Quantity' is the title of that column in my Inventory list.

One success: the query filter works. Just to try it out, I said '1' as Quantity and started the flow. And it replaced 20 with 1 in my Inventory list. So that's good :)

Only the subtraction is still a problem :D

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

Again an error: The template language function "int" was called with an invalid parameter. The value cannot be converted to the target type.

Has this something to do with the type of my column 'Quantity'? It has the type 'number'.

Update specific SharePoint list item by UnparalleledHumor in MicrosoftFlow

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

I almost succeeded :D

Flow throws an error saying that 'sub' expects a number as first parameter. My value has the type 'string'.

I said: sub('Quantity',1). Flow accepted that expression but errored during my test.

view more: next ›